Question: Risk Assignment: Pandas The following code loads the olympics dataset (olympics.csv), which was derrived from the Wikipedia entry on All Time Olympic Games Medals, and

Risk Assignment: Pandas The following code loads
Risk Assignment: Pandas The following code loads the olympics dataset (olympics.csv), which was derrived from the Wikipedia entry on All Time Olympic Games Medals, and does some basic data cleaning. The columns are organized as # of Summer games, Summer medals, # of Winter games, Winter medals, total # number of games, total # of medals. Use this dataset to answer the questions below. Part 1 Task 1 Which country has won the most gold medals in summer games? This function should return a single string value. Task 2 Which country had the biggest difference between their summer and winter gold medal counts? This function should return a single string value. Task 3 Which country has the biggest difference between their summer gold medal counts and winter gold medal counts relative to their total gold medal count? (Summer Gold-Winter Gold)/Total Gold Only include countries that have won at least 1 gold in both summer and winter. This function should return a single string value. Task 4 Write a function that creates a Series called "Points" which is a weighted value where each gold medal (Gold. 2) counts for 3 points, silver medals (Silver.2) for 2 points, and bronze medals (Bronze. 2) for 1 point. The function should return only the column (a Series object) which you created. This function should return a Series named Points of length 146

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!