Vizly: Separating Summer and Winter Olympics Data

noc_regions.csv

Missing file

Can you separate the summer and winter olympics?

The provided file noc_regions.csv contains information about National Olympic Committees (NOCs) and their respective regions. However, it does not contain any information about the Summer and Winter Olympics.

To separate the Summer and Winter Olympics, we would need a dataset that includes information about the events, such as the type of Olympics (Summer or Winter), the participating NOCs, and other relevant details.

If you have such a dataset, please provide it, and I can help you separate the Summer and Winter Olympics.

athlete_events.csv

Missing file

Can you separate the summer and winter olympics?

Show code

The data has been successfully separated into Summer and Winter Olympics.

Summer Olympics

Here are the first few rows of the Summer Olympics dataset:

ID	Name	Sex	Age	Height	Weight	Team	NOC	Games	Year	Season	City	Sport	Event	Medal
1	A Dijiang	M	24.0	180.0	80.0	China	CHN	1992 Summer	1992	Summer	Barcelona	Basketball	Basketball Men's Basketball	NaN
2	A Lamusi	M	23.0	170.0	60.0	China	CHN	2012 Summer	2012	Summer	London	Judo	Judo Men's Extra-Lightweight	NaN
3	Gunnar Nielsen Aaby	M	24.0	NaN	NaN	Denmark	DEN	1920 Summer	1920	Summer	Antwerpen	Football	Football Men's Football	NaN
4	Edgar Lindenau Aabye	M	34.0	NaN	NaN	Denmark/Sweden	DEN	1900 Summer	1900	Summer	Paris	Tug-Of-War	Tug-Of-War Men's Tug-Of-War	Gold
26	Cornelia "Cor" Aalten (-Strannood)	F	18.0	168.0	NaN	Netherlands	NED	1932 Summer	1932	Summer	Los Angeles	Athletics	Athletics Women's 4 x 100 metres Relay	NaN

Winter Olympics

Here are the first few rows of the Winter Olympics dataset:

ID	Name	Sex	Age	Height	Weight	Team	NOC	Games	Year	Season	City	Sport	Event	Medal
5	Christine Jacoba Aaftink	F	21.0	185.0	82.0	Netherlands	NED	1988 Winter	1988	Winter	Calgary	Speed Skating	Speed Skating Women's 500 metres	NaN
5	Christine Jacoba Aaftink	F	25.0	185.0	82.0	Netherlands	NED	1988 Winter	1988	Winter	Calgary	Speed Skating	Speed Skating Women's 1,000 metres	NaN
5	Christine Jacoba Aaftink	F	25.0	185.0	82.0	Netherlands	NED	1992 Winter	1992	Winter	Albertville	Speed Skating	Speed Skating Women's 500 metres	NaN
5	Christine Jacoba Aaftink	F	25.0	185.0	82.0	Netherlands	NED	1992 Winter	1992	Winter	Albertville	Speed Skating	Speed Skating Women's 1,000 metres	NaN
5	Christine Jacoba Aaftink	F	27.0	185.0	82.0	Netherlands	NED	1994 Winter	1994	Winter	Lillehammer	Speed Skating	Speed Skating Women's 500 metres	NaN

Would you like to perform any specific analysis or visualization on these datasets?

Save each to a csv file for me

Show code

The summer olympics file is not downloading correctly

Show code

Give the link to file as markdwon

The files have been saved successfully.

You can download them using the following links:

Feel free to ask if you need any further analysis or visualizations!