Q1. DataFrame from CSV
The UIC2016MensBasketBall.csv records the game results of the 2016 Men’s Basketball. Implement Python code to load the exact data into a data frame df2016.
Q2. Column Names
Assign column headers to:
Date
Opponent
UIC Score
Opp Score
UIC Field Goal Percentage
Opp Field Goal Percentage
UIC 3 point Field Goal Percentage
Opp 3 point Field Goal Percentage
UIC Rebound
Opp Rebound
UIC Assists
Opp Assists
Q3. Missing Data
Fill the missing data cell with a hyphen sympol ‘-‘.
Q4. Data Types
What are the data types used in this data frame?
Provide the answer using a Markdown cell.
Q5.
How many school opponents did Men’s Basketball played in 2016?
Provide the answer using a Markdown cell.
Q6.
List all the games that UIC scored more than 65 points.
Provide the answer using a Markdown cell.
Q7. Win-Los-Tie
Calculate numbers of games of Wins, Losses and Ties, accordingly.
Provide the answer using a Markdown cell.