Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please find the data sets from following Google Drive and use Python to solve the problems: https://drive.google.com/file/d/1iM6icsP6nJL2yeq2IDieaoKXA3O7VHpy/view?usp=sharing Data contains the details of over 11,000 athletes,

Please find the data sets from following Google Drive and use Python to solve the problems:

https://drive.google.com/file/d/1iM6icsP6nJL2yeq2IDieaoKXA3O7VHpy/view?usp=sharing

image text in transcribedimage text in transcribed
Data contains the details of over 11,000 athletes, with 47 disciplines, along with 743 Teams taking part in the 2021(2020) Tokyo Olympics. This dataset includes the details of the Athletes, Coaches, Teams participating as well as the Entries by gender. It contains their names, countries represented, discipline, gender of competitors, name of the coaches. There are 5 datasets in xlsx format: Athletes.xlsx: Contains details about the participating Athletes Coaches.xlsx: Details about coaches, countries and disciplines along with event EntriesGender.xlsx: Details about the Discipline and the number of females and males participating Medals.xlsx: Contains the Medals and Scoreboard of countries that participated in Tokyo Olympics Teams.xlsx: Details about the Teams, discipline, Name of Country and the event . Read the 5 xlsx to beyour pandas data frame into your kernel. . In Athletes.xlsx and Coaches.xlsx, how many athletics {Discipline = \"Athletics\") where the NOC of athletics and coaches are different. . In EntriesGender.xlsx, please find the top 5 disciplines having highest proportions of females. . In Medalsxlsx, please draw a stacked bar chart, medals no. against countries, having appropriate colors for various medal types, ordering countries by rank in the dataset. Show top 30 countries only. . In Teams.xlsx, how many countries where the names are different from NOC ? please show results with Python code

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

Basic College Mathematics With Early Integers (Subscription)

Authors: Elayn Martin Gay

4th Edition

0135181267, 9780135181263

More Books

Students also viewed these Mathematics questions