Reference no: EM132356506
Question
Using Pandas in python language
The UMTerps2016MensSoccer.csv records the game results of the 2016 Men's Soccer.
1. Write a Python program to load the exact data into a data frame df2016.
2. Write a Python program to assign the column headers to:
· Date
· Opponent
· UM Rank
· Opp Rank
· Location
· UM Score
· Opp Score
· Overtime
3. Write a Python program to fill the missing data cell with a hyphen symbol '-'.
4. Write a Python program to list the data types used in this data frame.
5. Write a Python program to list school opponents that Men's Soccer played against in 2016.
6. Write a Python program to list numbers of games that Men's Soccer played at each location in 2016.
7. Write a Python program to list all the games ended in overtime.
8. Write a Python program to count numbers of wins, losses and ties, accordingly.