Top "Pivot-table" questions

A "pivot table" is a method of summarizing data in tabular form.

How to remove multilevel index in pandas pivot table

I have a dataframe as given: df = {'TYPE' : pd.Series(['Advisory','Advisory1','Advisory2','Advisory3']), 'CNTRY' : pd.Series([…

python pandas pivot pivot-table
How to get rid of multilevel index after using pivot table pandas?

I had following data frame (the real data frame is much more larger than this one ) : sale_user_id sale_…

python pandas dataframe pivot-table data-analysis
Pivot Tables or Group By for Pandas?

I have a hopefully straightforward question that has been giving me a lot of difficulty for the last 3 hours. It …

python pandas count group-by pivot-table
Google Sheets Pivot Table Not Updating

I have a google app script which submits info to an organized sheet and would like to create a pivot …

google-apps-script google-sheets pivot-table
Report connections for Pivot table slicer doesn't show all pivot tables?

I have 3 sheets with several pivot tables on each and one sheet with the source data. These 4 sheets were copied …

excel pivot-table slicers vba
Is there any way to create a Pivot Table in Excel using Apache POI?

I am currently working on the automation of Excel, and add such I have made a good use of the …

java excel apache-poi pivot-table
Count occurrences of values

I have a column of text values with repeated values. I want to create a new column of unique values (…

excel count excel-formula pivot-table countif
Pandas pivot table Percent Calculations

Given the following data frame and pivot table: import pandas as pd df=pd.DataFrame({'A':['x','y','z','x',…

python-3.x pandas pivot-table percentage
Insert data to a pivot table in laravel

I have 3 tables: posts, tags, post_tag. Each Post has many tags so I use hasMany method for them. But …

php laravel eloquent pivot-table
Pivot table strings grouping under pivot column?

JOB ENAME -------- ---------- ANALYST SCOTT ANALYST FORD CLERK SMITH CLERK ADAMS CLERK MILLER CLERK JAMES MANAGER JONES MANAGER CLARK …

sql sql-server sql-server-2008 pivot pivot-table