Pivot table in Python

create a pandas dataframe-

import numpy as np
import pandas as pd
cars_data= pd.DataFrame([[10,5,3,'X'], [1,2,3,'Y'],[3,4,5,'X'], [10,5,3,'X'], [1,2,3,'Y'],[3,4,5,'X']], columns=['A','B','C','Type'])

 cars_data
A B C Type
0 10 5 3 X
1 1 2 3 Y
2 3 4 5 X
3 10 5 3 X
4 1 2 3 Y
5 3 4 5 X

 create pivot_table a method in pandas

# using pivot to convert rows to column

pivot_car= cars_data.pivot_table(columns=['Type', 'A'], aggfunc= [np.mean, np.amax])

mean amax
Type A
B X 3 4 4
10 5 5
Y 1 2 2
C X 3 5 5
10 3 3
Y 1 3 3

Comments

Post a Comment

Popular posts from this blog

Automatically open and do some actions on web pages in python using different packages

1) Automatically open web url using Selenium- get chrome driver from here- https://chromedriver.storage.googleapis.com/index.html?path=80.0.3987.106  place the chrome driver in user/username/bin location from selenium import webdriver browser = webdriver.Chrome(executable_path = '/Users/abcarp/bin/chromedriver') browser.get('https://in.linkedin.com/') sleep(10) browser.close() 2) Automatically login to Linkedin and do some action using selenium- from selenium.webdriver.common.keys import Keys      # url of LinkedIn  url = "https://www.linkedin.com/login?fromSignIn=true&trk=guest_homepage-basic_nav-header-signin"   # path to browser web driver  driver = webdriver.Chrome( '/Users/esisarp/bin/chromedriver')       driver.get(url)  # getting the user-name element username = driver.find_element_by_id("username")   # Sending the keys for username        username.s...
Read more

Explainability in Data Science:- Data, Model & Prediction

Image
XAI( Explainable AI  ) is grabbing lime-light in machine learning. How can we be sure that image classification algo is learning faces not background ? Customer wants to know why loan is disapproved? Globally important variable might not be responsible/ imp for individual prediction. Here XAI comes to rescue- We have taken data from  classification_data This has some sensor values and an output class.  A) Data Explainability - what are the basic understanding required from data perspective.  1)       Identify missing values, co-linear feature, feature interaction, zero importance feature, low important feature, single value feature and handle missing values, remove/ handle features accordingly. 2)       Missing values- no missing values from data description 3)       No good correlation between variables- can be seen from correlation plots 4)    ...
Read more