// there is more to the excel sheet

// using jupyterLab

//pandas

import pandas as pd df = pd.read_excel('SummerOlympic.xlsx')

//In PYTHON pull data from xlsx file based on the following questions

1. From 1980 to 2008, which country won the most medals in Wrestling?

2. List the number of medals won by USA athletes from 1996 to 2008. In other words, create a dataframe with the following columns: "country", "year", "gold", "silver", "bronze".

3. Are there athletes who won medals in three or more different Olympics? If so, print the names, their countries, and the years they won. In other words, create a dataframe with the columns: "athlete", "NOC", "year1", "year2", "year3", "year4", etc.

//In PYTHON pull data from xlsx file based on the following questions

E 7 Y City Athens Athens Athens Athens Athens Athens Athens Athens Athens B C Edit - Sport 1896 Aquatics 1896 Aquatics 1896 Aquatics 1896 Aquatics 1896 Aquatics 1896 Aquatics 1896 Aquatics 1896 Aquatics 1896 Aquatics 1896 Aquatics innri D Discipline Swimming Swimming Swimming Swimming Swimming Swimming Swimming Swimming Swimming Swimming IC Athlete HAJOS, Alfred HERSCHMANN, Otto DRIVAS, Dimitrios MALOKINIS, loannis CHASAPIS, Spiridon CHOROPHAS, Efstathios HAJOS, Alfred ANDREOU, Joannis CHOROPHAS, Efstathios NEUMANN, Paul ornor in F G H NG Gend - Event HUN Men 100m freestyle AUT Men 100m freestyle GRE Men 100m freestyle for sailors GRE Men 100m freestyle for sailors GRE Men 100m freestyle for sailors GRE Men 1200m freestyle HUN Men 1200m freestyle GRE Men 1200m freestyle GRE Men 400m freestyle AUT Men 400m freestyle Event_gend Medal | M Gold M Silver M Bronze | M Gold | M Silver M M Bronze M Gold IM Silver IM Bronze M Gold rib Athens AL... 10 A cornu Annu