How to plot pivot chart in python?

python pandas pivot-table pivottable.js
Mithil Amin picture Mithil Amin · Apr 20, 2017 · Viewed 9k times · Source

Currenly, I am new in python scripting I am using panda, pivottablejs for creating a script. I have one csv file and I read that csv file using panda and I got the table like this. enter image description here

Now, I want to generate the pivotchart using pivottablejs so for that I have to pass dataframe object in the pivot_ui();

I want to Plot in Pivot Chart the total number of issue status created for every OriginationPhase.

So I tried something like this.

LabelsReviewedByDate = issues_df.groupby(['Status','OriginationPhase'])

pivot_ui(LabelsReviewedByDate)

I know this is wrong but I am new in python scripting. So help me to find the solution.

Thank you

Answer

Andrew L picture Andrew L · Apr 21, 2017

You can just pass the dataframe right to pivot_ui:

import pandas as pd
from pivottablejs import pivot_ui

a= [ [1,'Requirements','bug'],[2,'Design','bug'],[3,'Testing','bug'],[4,'Requirements','bug'],[5,'Requirements','Inquiry'] ]

df  = pd.DataFrame(a,columns =['Issue#','OriginationPhase','Category'])

pivot_ui(df)

enter image description here

Related questions

Python Pandas : pivot table with aggfunc = count unique distinct

df2 = pd.DataFrame({'X' : ['X1', 'X1', 'X1', 'X1'], 'Y' : ['Y2','Y1','Y1','Y1'], 'Z' : ['Z3','Z1','Z1','Z2']}) X Y Z 0 X1 Y2 Z3 1 X1 Y1 Z1 2 X1 …

Read More
Pandas Pivot tables row subtotals

I'm using Pandas 0.10.1 Considering this Dataframe: Date State City SalesToday SalesMTD SalesYTD 20130320 stA ctA 20 400 1000 20130320 stA ctB 30 500 1100 20130320 stB ctC 10 500 900 20130320 stB ctD 40 200 1300 20130320 stC ctF 30 300 800 How can i group subtotals per state? State City SalesToday SalesMTD SalesYTD stA ALL 50 900 2100 stA ctA 20 400 1000 stA ctB 30 500 1100 …

Read More
Pandas Pivot Table List of Aggfunc

Pandas Pivot Table Dictionary of Agg function I am trying to calculate 3 aggregative functions during pivoting: Count Mean StDev This is the code: n_page = (pd.pivot_table(Main_DF, values='SPC_RAW_VALUE', index=['ALIAS', 'SPC_PRODUCT', 'LABLE', 'RAW_…

Read More