Articles → Pandas → Pivot_Table Function In Dataframes In Pandas
Pivot_Table Function In Dataframes In Pandas
Purpose
Example
import pandas as pd
# Create a dictionary
dict = {
"company": ["Google", "Microsoft", "Apple", "Google", "Microsoft", "Apple"],
"year": [2017, 2017, 2017, 2018, 2018, 2018],
"Profit": [20000, 40000, 60000, 80000, 70000, 50000],
}
df = pd.DataFrame(dict)
df.pivot_table(columns="company", values="year")
Output
Click to Enlarge