Olympic medals by nation AND gender?

[Will Hopkins]

Does anyone know of a list of Tokyo medals won by females and males in each nation? Ditto the Sochi medals? It's easy to find lists of medals by nation, but the breakdown by nation and gender doesn't seem to be out there.

Will

[Jeff Rothschild]

Hi Will,

I was able to get the Sochi data from a Tidy Tuesday dataset. I've attached a csv of the medal count by medal, nation, and sex, and all medal winners, as well as the R code below for how I got there...

library(tidyverse)

library(tidytuesdayR)

tt_data <- tt_load("2021-07-27")

df <- tt_data$olympics

sochi_medals_data <- df %>% 

  filter(games == "2014 Winter") %>% 

  filter(!is.na(medal)) 

medals_by_sex_nation <- sochi_medals_data %>% 

  group_by(sex, noc, medal) %>% 

  count(sort = T) 

Best,

Jeff Rothschild

jrot...@aut.ac.nz