As we see in the plot Conchita Velasco and Raphael repeat representing Spain on Eurovision. The colour in the plots show their position (greener the better).
spanish_artists <-
eurovision_1 %>%
filter(section=="final"| section=="grand-final") %>%
filter(artist_country == "Spain") %>%
select(year, artist, song, host_city, host_country, rank)
spanish_artists %>%
group_by(year) %>%
mutate(artist = fct_reorder(artist, year)) %>%
ggplot(aes(x = year, y = artist)) +
geom_tile(aes(fill = rank), colour = "red") +
scale_fill_gradient(low="green", high="red", limits=c(1, 26)) +
scale_x_continuous(breaks = seq(1956, 2022)) +
theme(axis.text.x = element_text
(angle = 90, vjust = 0.5, hjust = 1)) +
labs(y = "Spanish artist on Eurovision by year", y = "Year")