Answered step by step
Verified Expert Solution
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
Create new cells as needed to start analyzing the Olympics dataset. Remember to comment on your code. You may return to Datacamps Intermediate Python course to code the Pandas and MatPlotLib librariesPlease 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 librariesRun the provided code to inspect the datasetHow many rows and columns are in the dataset? Familiarize yourself with its structureWrite code to do the following:aCreate a new DataFrame with only US athletes in it Name it usonly. use the variable noc USAbUse 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 usonly DataFrame you created previously. Name this new DataFrame goldussummer.cList the names and ages of all the US athletes who won gold medals in swimming in Sort the list by age ascending. HINT: use the sortvalues functiondCreate 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started