Python:
Pandas DataFrame
Construct two data frames Revenue and Calls from CSV files sales_calls.csv and sales_revenue.csv.
Plot a line graph of the monthly average amount per call.
# codes
%matplotlib inline
import pandas as pd
import numpy as np
# see text for these
calls = pd.read_csv("sales_calls.csv")
revenue = pd.read_csv("sales_revenue.csv")
# Plot a line graph of the monthly average amount per call as shown below
# xxx fill in missing piece of code here
Expected Output:
sales_calls.csv:
Team member, Territory, Month, Calls
Jorge, 3, 1, 107
Jorge, 3, 2, 88
Jorge, 3, 3, 84
Jorge, 3, 4, 113
Ana, 1, 1, 91
Ana, 1, 2, 129
Ana, 1, 3, 96
Ana, 1, 4, 128
Ali, 2, 1, 120
Ali, 2, 2, 85
sales_revenue.csv:
Territory, Month, Amount
1, 1, 54228
1, 2, 61640
1, 3, 43491
1, 4, 52173
2, 1, 36061
2, 2, 44957
2, 3, 35058
2, 4, 33855
3, 1, 50876
3, 2, 57682
560
Call Amount
540
520
500
480
scroll output; double click to hide
440
420
10
15
2.0
2.5 Month
3.0
3.5
4.0