In [1]:

    

import pandas as pd
import numpy as np


    

In [ ]:

    

Employees = pd.read_excel('/home/data/AdventureWorks/Employees.xls')
Territory = pd.read_excel('/home/data/AdventureWorks/SalesTerritory.xls')
Customers = pd.read_excel('/home/data/AdventureWorks/Customers.xls')
Orders = pd.read_excel('/home/data/AdventureWorks/ItemsOrdered.xls')


    

In [ ]:

    

# import pandas and numpy in answer file:


    

In [2]:

    

%%sh
cat << EOF > hw5_answers.py

import pandas as pd
import numpy as np

EOF


    

In [4]:

    

%%sh 
# Question 1
cat << EOF >> hw5_answers.py

def get_manager(Employees):
    pass # your code goes here

EOF


    

In [ ]:

    

%%sh
# Question 2
cat << EOF >> hw5_answers.py

def get_spend_by_order(Orders, Customers):
    pass # your code goes here

EOF


    

In [ ]:

    

%%sh
# Question 3
cat << EOF >> hw5_answers.py

def get_order_location(Orders, Customers, Territory):
    pass # your code goes here

EOF


    

In [ ]:

    

%%sh
# Question 4
cat << EOF >> hw5_answers.py

def employee_info(Employees):
    pass # your code goes here

EOF