MVCC Jupiter Notebook File Data Frame from Records Program

Date11/13/2015
11/17/2015
11/24/2015
11/28/2015
12/2/2015
12/5/2015
12/12/2015
12/16/2015
12/19/2015
12/22/2015
12/29/2015
1/2/2016
1/8/2016
1/10/2016
1/14/2016
1/16/2016
1/18/2016
1/22/2016
1/24/2016
1/28/2016
1/30/2016
2/6/2016
2/11/2016
2/13/2016
2/16/2016
2/19/2016
2/21/2016
2/26/2016
2/28/2016
3/5/2016
Opp
UIC Score
San Francisco
Western Illinois
Roosevelt
Drake
DePaul
UCF
Illinois
Illinois State
Loyola (IL)
Purdue Calumet
Northern Illinois
Valparaiso
Detroit
Oakland
Green Bay
Milwaukee
Cleveland State
Northern Kentucky
Wright State
Youngstown State
Cleveland State
Valparaiso
Wright State
Northern Kentucky
Youngstown State
Detroit
Oakland
Green Bay
Milwaukee
Wright State
Opp Score
75
57
96
62
55
58
79
60
47
91
65
47
69
61
76
62
53
69
66
78
72
55
64
79
91
72
63
69
85
43
UIC FG
78
84
58
83
82
88
83
72
64
72
70
75
87
86
78
87
70
82
80
82
70
73
59
77
92
83
74
85
98
74
Opp FG
28
15
35
23
20
22
17
18
30
20
18
21
21
29
21
20
23
22
21
19
22
24
38
24
24
22
30
12
UIC 3P
24
30
22
31
29
26
25
25
20
26
22
25
26
25
29
31
23
25
29
29
26
28
21
27
35
27
28
30
30
29
8
3
1
4
2
4
9
7
5
10
4
2
2
5
4
2
1
2
5
4
2
5
7
6
4
3
6
9
2
Opp 3P
UIC TRB
8
5
5
10
7
9
2
4
8
8
8
4
4
4
8
9
9
9
14
4
7
6
9
5
7
7
9
15
14
Opp TRB
36
40
52
30
31
43
38
31
32
36
30
28
35
32
33
29
36
36
36
49
35
28
40
45
60
34
42
31
36
39
UIC AST
42
42
23
34
36
32
25
43
29
33
39
32
30
40
32
37
34
25
37
34
40
30
30
45
36
44
44
39
39
Opp AST
17
6
5
12
10
18
15
7
21
18
11
6
10
20
11
6
3
16
13
8
13
13
12
9
12
7
13
5
15
16
15
18
19
14
18
14
9
18
19
12
10
11
19
24
15
14
14
21
16
20
14
16
11
19
16
17
25
20
Assignment 5
. Please write your code in a Jupyter Notebook file (ipynb) and submit it on Blackboard
• Make sure to label your answer of each question clearly and add comments to make it
readable.
• You are allowed to discuss with other students (up to three) or the instructor. Please put
all the names of students that you discussed with. However individual students must write
their own solutions
• Copying a program, or letting someone else copy your program, is a form of academic
dishonesty. Any referred material must be cited properly
Maximally leverage Piazza to benefit other students by your questions and answers,
. Try to be updated by checking notifications in both Piazza and Blackboard class
webpage
Exercise 1. DataFrame from CSV (10pts)
The UIC2016 Mens Basketball.csv records the game results of the 2016 Men’s Basketball. Implement
Python code to load the exact data into a data frame (2016.
Exercise 2. Column Names (10pts)
Assign column headers to
Date
Opport
UIC Score
Op Score
LIC Field Goal Percentage
Opp Field Goal Percentage
UIC 3 point Field Goal Percentage
Oppipois Field Goal Percentage
UC Rebound
Opy Rebound
UIC Assist
Opg
Exercise 3. Missing data (1pts)
Fill the missing data cell with a hyphen symbol
Exercise 4. Data Types (10pts)
What are the data types used in this data frame? Provide both Python code and the answer
Exercise 5. Count (10pts)
How many school opponents did Men’s Basketball played in 2016? Provide both Python code and the
answer
Exercise 6. Filter (20pts)
List all the games that UIC scored more than 65 points. Provide both Python code and the answer.
Exercise 7. Win-Los-Tie (Jopt>
Calculate numbers of games of Wins, Losses and Ties, accordingly.