hidden cell
hidden cell
# Write and run code here
hidden cell
hidden cell
# Write and run code here
Postcode Sales_Rep_ID Sales_Rep_Name Year Value
0 2121 456 Jane 2011 84219.497311
1 2092 789 Ashish 2012 28322.192268
2 2128 456 Jane 2013 81878.997241
3 2073 123 John 2011 44491.142121
4 2134 789 Ashish 2012 71837.720959
hidden cell
# Write and run code here
Postcode Sales_Representative_ID Sales_Representative Year Value
0 2121 456 Jane 2011 84219.497311
1 2092 789 Ashish 2012 28322.192268
2 2128 456 Jane 2013 81878.997241
3 2073 123 John 2011 44491.142121
4 2134 789 Ashish 2012 71837.720959
hidden cell
hidden cell
# Write and run code here
(390, 5)
hidden cell
# Write and run code here
0
hidden cell
# Write and run code here
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 390 entries, 0 to 389
Data columns (total 5 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 Postcode 390 non-null int64
1 Sales_Representative_ID 390 non-null int64
2 Sales_Representative 390 non-null object
3 Year 390 non-null int64
4 Value 390 non-null float64
dtypes: float64(1), int64(3), object(1)
memory usage: 15.4+ KB
None
hidden cell
# Write and run code here
count 390.000000
mean 49229.388305
std 28251.271309
min 106.360599
25% 26101.507357
50% 47447.363750
75% 72277.800608
max 99878.489209
Name: Value, dtype: float64
hidden cell
hidden cell
# Write and run code here
hidden cell
# Write and run code here
hidden cell
hidden cell
# Write and run code here
hidden cell
# Write and run code here
hidden cell
# Write and run code here
array([2011, 2012, 2013])
hidden cell
# Write and run code here
hidden cell
# Write and run code here
count 130.000000
mean 50587.583777
std 29878.520275
min 106.360599
25% 23263.014933
50% 51462.750310
75% 76913.658015
max 99878.489209
Name: Value, dtype: float64
hidden cell
# Write and run code here
hidden cell
# Write and run code here
count 130.000000
mean 47322.615181
std 27944.690905
min 1246.105766
25% 26474.435621
50% 41818.462250
75% 69658.827311
max 99436.424098
Name: Value, dtype: float64
hidden cell
# Write and run code here
hidden cell
# Write and run code here
count 130.000000
mean 49777.965956
std 26968.856306
min 429.356425
25% 28824.251006
50% 52441.187887
75% 70873.817709
max 98199.933992
Name: Value, dtype: float64
hidden cell
hidden cell
# Write and run code here
Year Value
0 2011 6.576386e+06
1 2012 6.151940e+06
2 2013 6.471136e+06
hidden cell
# Write and run code here
hidden cell
hidden cell
# Write and run code here
Year Sales_Representative Value
0 2011 Ashish 46829.122073
1 2011 Jane 56205.908485
2 2011 John 49643.635644
3 2012 Ashish 50141.586408
4 2012 Jane 47333.772158
5 2012 John 43912.806087
6 2013 Ashish 50580.899288
7 2013 Jane 50974.143450
8 2013 John 47779.602629
hidden cell
# Write and run code here
hidden cell
hidden cell
# Write and run code here
hidden cell
# Write and run code here
hidden cell