Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Reliability Engineering Designing And Operating Resilient Database Systems

Authors: Laine Campbell, Charity Majors

1st Edition

978-1491925942

More Books

Students also viewed these Databases questions