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

Speech Recognition using PyAudio and SpeechRecognition Libraries

This is simple program to convert audio into text. I have used speec_recognition library to do it. import speech_recognition as sr r = sr.Recognizer() with sr.Microphone() as source:     print("Speak Anything :")     audio = r.listen(source)     try:         text = r.recognize_google(audio)         print("You said : {}".format(text))     except:         print("Sorry could not recognize what you said") Output- Speak Anything : You said : internet is required to access the Google API if there is no internet you will not be able to convert voice into text to install SpeechRecognition- https://pypi.org/project/SpeechRecognition/ one of the dependencies is PyAudio which is not supported after 3.6. For python verison 3.6+ one needs to download wheel (  https://python101.pythonlibrary.org/chapter39_wheels.html )  and install PyAudio separately. https://sta...
Read more

open multiple sites in python Script using web browser package

including required packages- ! pip install random ! pip install webbrowser import random import webbrowser import os adding multiple sites in a list- ls=['/2016/08/business-analytics-on-sales-data-of.html', '/recommendation-engine-market-basket.html', '/2016/08/optimizing-e-commerce-site-using.html'    ,'/2016/08/8-simple-ways-to-increse-your-blog.html', '/2016/08/business-analytics-on-sales-data-of.html',    '/2017/12/gaussian-state-space-model-in-r-using.html', '/2017/09/assumptions-of-linear-regression.html',    '/2017/09/neural-network-forward-propagation-in.html', '/2018/06/lda-linear-discriminant-analysis-where.html',    '/2018/10/religious-demographics-of-india-in.html', '/2020/04/forecasting-total-deaths-from.html',    '/2019/11/automatic-ticket-resolution-for.html', '/2019/09/sentiment-analysis-using-nltk-and.html', '/2019/07/deep-learning-with-h2o-in-py...
Read more

SHAP (SHapley Additive exPlanations) for variable importance in Python

Image
it is a unified approach to explain the output of any machine learning model. pip install shap ( on anaconda prompt) import xgboost import shap # load JS visualization code to notebook shap.initjs() # train XGBoost model X,y = shap.datasets. boston () model = xgboost.train({ " learning_rate " : 0.01 }, xgboost.DMatrix(X, label = y), 100 ) # explain the model's predictions using SHAP values # (same syntax works for LightGBM, CatBoost, and scikit-learn models) explainer = shap.TreeExplainer(model) shap_values = explainer.shap_values(X) # visualize the first prediction's explanation (use matplotlib=True to avoid Javascript) shap.force_plot(explainer.expected_value, shap_values[ 0 ,:], X.iloc[ 0 ,:]) The above explanation shows features each contributing to push the model output from the base value (the average model output over the training dataset we passed) to the model output. Features pushing the prediction higher are shown...
Read more