Question: 1 0 . Create new cells as needed to start analyzing the Olympics dataset. 1 1 . Remember to comment on your code. You may

10.Create new cells as needed to start analyzing the Olympics dataset. 11.Remember to comment on your code. You may return to Datacamps Intermediate Python course to code the Pandas and MatPlotLib libraries.12.Please note that the Pandas library is already imported as pd and that the Olymp DataFrame has already been created for you. However, you might need to import the numpy and the matplotlib libraries.13.Run the provided code to inspect the dataset.14.How many rows and columns are in the dataset? Familiarize yourself with its structure.15.Write code to do the following:a.Create a new DataFrame with only US athletes in it. Name it us_only. (use the variable noc == USA).b.Use the logical operator and to create a new DataFrame with those who won a Gold Medal (medal == Gold) in Summer Sports (season == Summer). Derive this new DataFrame from the us_only DataFrame you created previously. Name this new DataFrame gold_us_summer.c.List the names and ages of all the US athletes who won gold medals in swimming in 2016. Sort the list by age ascending. (HINT: use the sort_values() function).d.Create a bar chart with the number of gold medals for the USA in ALL the years in the dataset. What year did the US win the most gold medals and the least?

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 Databases Questions!