Pivoting data

PHOTO

Sat Jan 23 2021 20:49:29 GMT+0000 (Coordinated Universal Time)

Saved by @exe

pd.pivot_table(df, index='Company',
              columns='Department',
              values='Employees')

This method takes many arguments which you can find in the documentation, but for now we will look at three of these: index: the column you want to set as index columns: the column which will be transformed to a new column for each unique value. values: which column will be the value in each cell.

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

Data Analysis

@exe

Filtering with multiple conditions '&' operator Filtering Boolean indexing with square brackets Filtering Boolean indexing with .loc Filtering with multiple conditions 'or' operator Agreggation Groupby #1: get total sum Agreggation Groupby #2: get the highest date Pivoting data Creating conditional columns numpy.where Conditional columns with list comprehension Aggregation with multiple functions groupby

Browse more snippets >>