python-pandasHow to create pivot table from data frame
import pandas as pd
df = pd.DataFrame({
'type': ['A', 'A', 'A', 'B', 'B', 'C'],
'age': [1, 3, 6, 3, 4, 1]
})
pvt = pd.pivot_table(df , index=['type'], aggfunc=['max'])ctrl + cimport pandas as pdload Pandas module | pd.DataFramecreates Pandas DataFrame object |
pd.pivot_tablecreates pivot table from given DataFrame and configuration | index=defines list of columns to use as pivot indexes (rows) |
aggfunc=defines aggregate functions to use for column values | |
Usage example
import pandas as pd
df = pd.DataFrame({
'type': ['A', 'A', 'A', 'B', 'B', 'C'],
'age': [1, 3, 6, 3, 4, 1]
})
pvt = pd.pivot_table(df , index=['type'], aggfunc=['max'])
print(pvt)output
max
age
type
A 6
B 4
C 1
More of Python Pandas
- How to floor values in dataframe
- How to replace values in dataframe
- What is opposite of melt() in Pandas
- How to convert column values to Int
- How to use melt() with dataframe - example
- How to melt() multiple columns
- How to set data frame index
- How to load dataframe from Excel (XSL)
- How to create dataframe from Mysql table
- How to rename dataframe column by index
See more codes...