Breaking News: Grepper is joining You.com. Read the official announcement!

Pivot table with numpy

Elisabeth Engering answered on April 29, 2022 Popularity 9/10 Helpfulness 5/10

answer Pivot table with numpy

related pivot table in pandas

Pivot table with numpy

Comment

import numpy as np

# Get pivit table with statistic and fill missing values
df.pivot_table(values = "weekly_sales", index = "type", aggfunc = np.sum, fill_value = 0)

# Get pivit table with multiple statistics and fill missing values
df.pivot_table(values = "weekly_sales", index = "type", aggfunc = [np.sum, np.min, np.max], fill_value = 0)

# Get pivit table with multiple statistics and variables and fill missing values
df.pivot_table(values = "weekly_sales", index = "type", aggfunc = [np.sum, np.min, np.max], columns = "store", fill_value = 0)

# Get the sum of all rows and columns in pivot table
df.pivot_table(values = "weekly_sales", index = "type", aggfunc = [np.sum, np.min, np.max], columns = "store", fill_value = 0, margins = True)

# Display DataFrame
print(df)

Popularity 9/10 Helpfulness 5/10 Language python

Source: pandas.pydata.org

Tags: numpy pivot-table python

Link to this answer
Share Copy Link

Contributed on Apr 29 2022

Elisabeth Engering

0 Answers Avg Quality 2/10

Closely Related Answers

pivot table in pandas

Comment

#Determine pivot table
impute_grps = data.pivot_table(values=["LoanAmount"], index=["Gender","Married","Self_Employed"], aggfunc=np.mean)
print impute_grps

Popularity 8/10 Helpfulness 1/10 Language python

Source: www.analyticsvidhya.com

Tags: pandas pivot-table pivot-t

Link to this answer
Share Copy Link

Contributed on Mar 08 2024

Ashamed Angelfish

0 Answers Avg Quality 2/10

Pivot table with numpy

Contents

More Related Answers

Pivot table with numpy

Closely Related Answers

pivot table in pandas

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.