2023_08_08_hot_ones_episodes.qmd

---
title: "Hot Ones Episodes"
date: 2023-08-08
format: html
execute: 
  echo: true
---

# TidyTuesday

Join the R4DS Online Learning Community in the weekly #TidyTuesday event!
Every week we post a raw dataset, a chart or article related to that dataset, and ask you to explore the data.
While the dataset will be “tamed”, it will not always be tidy! As such you might need to apply various R for Data Science techniques to wrangle the data into a true tidy format.
The goal of TidyTuesday is to apply your R skills, get feedback, explore other’s work, and connect with the greater #RStats community!
As such we encourage everyone of all skills to participate!

```{r}
#| label: setup
#| include: false

library(tidyverse)
library(tidytuesdayR)

library(scales)
theme_set(theme_light())
```

# Load the weekly Data

Download the weekly data and make available in the `tt` object.

```{r}
#| label: Load

tt <- tt_load("2023-08-08")

```


# Readme

Take a look at the readme for the weekly data to get insight on the dataset.
This includes a data dictionary, source, and a link to an article on the data.

```{r}
#| label: Readme
#| eval: interactive()

tt

```


# Glimpse Data

Take an initial look at the format of the data available.

```{r}
#| label: Glimpse

tt %>% 
  map(glimpse)

```

# Wrangle

Explore the data and process it into a nice format for plotting! Access each dataset by name by using a dollarsign after the `tt` object and then the name of the data set.

```{r}
#| label: Wrangle

episodes <- tt$episodes
sauces <- tt$sauces
seasons <- tt$seasons
```

15 failures to finish.

```{r}
episodes |> 
  filter(!finished)
```

15 guests failed to finish. One for each guest.

```{r}
failed_guests <- episodes |> 
  filter(!finished) |> 
  count(guest, sort = TRUE) |> 
  pull(guest)
```

Eric André failed to finish in the 2nd appearance.
14 failed guests never retried.

```{r}
episodes |> 
  filter(guest %in% failed_guests, guest_appearance_number > 1)
```

11 guest appeared 2 times. 10 guests finished in both times, and Eric André is the only guest who failed to finish in the 2nd time. 

```{r}
guests_2times <- episodes |> 
  filter(!is.na(guest)) |> 
  count(guest, sort = TRUE) |> 
  filter(n > 1) |> 
  pull(guest)
```

# Visualize

Using your processed dataset, create your unique visualization.

```{r}
#| label: Visualize

episodes |> 
  count(season, finished) |> 
  ggplot(aes(season, n)) +
  geom_col(aes(fill = finished))
```

```{r}
hottest_sauces <- sauces |> 
  group_by(season) |> 
  slice_max(sauce_number) |> 
  ungroup()
```

```{r}
hottest_sauces |> 
  ggplot(aes(season, scoville)) +
  geom_line()
```

```{r}
p <- episodes |> 
  filter(guest %in% guests_2times) |> 
  left_join(hottest_sauces, by = join_by(season)) |> 
  mutate(
    finished2 = if_else(finished, "Finished", "Not-finished")
  ) |> 
  arrange(guest, season) |> 
  ggplot(aes(scoville, guest)) +
  geom_col(aes(fill = finished2),
           position = position_dodge2(padding = 0.1)) +
  scale_x_continuous(expand = expansion(), labels = label_comma()) +
  scale_fill_manual(values = c("steelblue", "red")) +
  guides(fill = guide_legend(reverse = TRUE)) +
  labs(x = "Hottest sauce in Scoville heat units",
       y = "Guests\n(Down: 1st; Up: 2nd apperance)",
       fill = NULL,
       title = "Eric André is the only guest who appeared twice and\nfailed to finish in Hot Ones",
       caption = "Source: Wikipedia articles: Hot Ones and List of Hot Ones episodes")
```

# Save Image

Save your image for sharing. Be sure to use the `#TidyTuesday` hashtag in your post on twitter! 

```{r}

# This will save your most recent plot
ggsave("image/hot_ones_episodes.png", p, width = 7, height = 5)

```