Create an Account

Already have account?

Forgot Your Password ?

Home / Questions / Risk Assignment: Pandas The following code loads the olympics dataset olympics csv, which ...

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

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

Aug 27 2020 View more View Less

Answer (Solved)

question Subscribe To Get Solution

Related Questions