CoCalc -- 12-8-21 Participation_by_Erik

Project: Erik Yan - Fall 2021 MAT1630

Path: Participation/12-8-21 Participation_by_Erik_Yan.ipynb

Views: ³⁵
Image: ubuntu2004

Kernel: Python 3 (system-wide)

In [3]:

import pandas as pd

In [4]:

df = pd.read_excel('SampleData.xlsx')

In [6]:

df.head()

Out[6]:

In [12]:

df_central = df[df['Region'] == 'Central']

The line above groups only the data that are located in the Central region.

In [13]:

df_central.groupby(by = "Item").sum()

Out[13]:

The line above shows us the unit cost and total of all the items in the Central region. So the total number of Binders sold were 5,762.

In [0]: