Did-Not-Participate-1976-to-2008
Supplementary csv for the Summer-Olympics-medals-1976-to-2008 dataset
@kaggle.welikeike_didnotparticipate1976to2008
Supplementary csv for the Summer-Olympics-medals-1976-to-2008 dataset
@kaggle.welikeike_didnotparticipate1976to2008
Starting from the original dataset (Summer-Olympics-medals-1976-to-2008).
I wanted to find the average number of medals won for each country, i then noticed however that many countries didn't participate in all the olympics, counting their non-presence as 0 medals won would unfairly worsen their average.
And so I took all the countries that appeared in the original dataset and checked on Wikipedia which olympics they didn't participate.
I then manually created a csv.
CREATE TABLE did_not_participate_1976_to_2008 (
"country" VARCHAR,
"year" BIGINT
);
Anyone who has the link will be able to view this.