python_wf_1.py

import pandas as pd
import yfinance as yf
orders = pd.read_csv('/Users/anbento/Documents/Data_Sets/Medium/customer_orders.csv', 
                     parse_dates = ['order_date'], index_col = ['order_date'] )

orders.insert(0, 'order_month', pd.DatetimeIndex(orders.index).to_period('M') )
orders.reset_index(inplace = True)
orders.columns = ['Order Date', 'Order Month' ,'Order ID', 'Customer ID', 'Item ID', 'Item Price', 
                  'Quantity', 'Amount Paid (£)'] 
print(orders.shape)
orders.head(10)

#orders.groupby('Customer ID')['Order ID'].count())
#orders.groupby('Customer ID')['Amount Paid (£)'].sum()