Change language

Python | Pandas.pivot_table ()

The levels in the pivot table will be stored in MultiIndex objects (hierarchical indexes) in the index and columns of the resulting DataFrame.

Parameters:

data: DataFrame
values: column to aggregate, optional
index: column, Grouper , array, or list of the previous
columns: column, Grouper, array, or list of the previous

aggfunc: function, list of functions, dict, default numpy.mean
-" If list of functions passed, the resulting pivot table will have hierarchical columns whose top level are the function names.
-" If dict is passed, the key is column to aggregate and value is function or list of functions

fill_value [scalar, default None]: Value to replace missing values ​​with
margins [boolean, default False]: Add all row / columns (eg for subtotal / grand totals)
dropna [boolean, default True]: Do not include columns whose entries are all NaN
margins_name [string, default ’All’]: Name of the row / column that will contain the totals when margins is True.

Returns: DataFrame

Code:

# Create a simple data frame

 
# pandas import as pd

import pandas as pd

import numpy as np

 
# create data frame

df = pd.DataFrame ({ < code class = "string"> ’A’ : [ ’ John’ , ’Boby’ , ’ Mina’ , ’Peter’ , ’ Nicky ’ ],

  ’ B’ : [ ’Masters’ , ’Graduate’ , ’ Graduate’ , ’Masters’ , ’ Graduate’ ],

  ’ C’ : [ 27 , 23 , 21 , 23 , 24 ]})

 
df

# A simple pivot table should have a data frame
# and an index / index list.

table = pd.pivot_table (df, index = [ ’A’ , ’B’ ])

  
table

# Creates a pivot table data frame

table = pd.pivot_table (df, values ​​ = ’ A’ , index = [ ’B’ , ’C’ ],

  columns = [ ’B’ ], aggfunc np. sum )

 
table

Shop

Gifts for programmers

Learn programming in R: courses

$FREE
Gifts for programmers

Best Python online courses for 2022

$FREE
Gifts for programmers

Best laptop for Fortnite

$399+
Gifts for programmers

Best laptop for Excel

$
Gifts for programmers

Best laptop for Solidworks

$399+
Gifts for programmers

Best laptop for Roblox

$399+
Gifts for programmers

Best computer for crypto mining

$499+
Gifts for programmers

Best laptop for Sims 4

$

Latest questions

PythonStackOverflow

Common xlabel/ylabel for matplotlib subplots

1947 answers

PythonStackOverflow

Check if one list is a subset of another in Python

1173 answers

PythonStackOverflow

How to specify multiple return types using type-hints

1002 answers

PythonStackOverflow

Printing words vertically in Python

909 answers

PythonStackOverflow

Python Extract words from a given string

798 answers

PythonStackOverflow

Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?

606 answers

PythonStackOverflow

Python os.path.join () method

384 answers

PythonStackOverflow

Flake8: Ignore specific warning for entire file

360 answers

News


Wiki

Python | How to copy data from one Excel sheet to another

Common xlabel/ylabel for matplotlib subplots

Check if one list is a subset of another in Python

How to specify multiple return types using type-hints

Printing words vertically in Python

Python Extract words from a given string

Cyclic redundancy check in Python

Finding mean, median, mode in Python without libraries

Python add suffix / add prefix to strings in a list

Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?

Python - Move item to the end of the list

Python - Print list vertically