Olympic Cost Analysis for Summer and Winter Olympic Games

Jul 26, 2024, 5:51 PM

Show me the cost per athlete for the summer and winter games, also show me the cost per event for both

The datasets for both the Summer and Winter Games have been loaded successfully. Here is a preview of the first few rows:

Summer Games

Year	City	Cost per Athlete (USD 2022, millions)	Cost per Event (USD 2022, millions)
1960	Rome	NaN	NaN
1964	Tokyo	0.1	1.8
1968	Mexico City	NaN	NaN
1972	Munich	0.1	5.5
1976	Montreal	1.2	35.7

Winter Games

Year	City	Cost per Athlete (USD 2022, millions)	Cost per Event (USD 2022, millions)
1960	Squaw Valley	NaN	NaN
1964	Innsbruck	0.0	0.1
1968	Grenoble	0.9	28.5
1972	Sapporo	0.1	3.4
1976	Innsbruck	0.1	2.8

Next, I will visualize the cost per athlete and cost per event for both the Summer and Winter Games.

Can you plot the winter and summer games on the same plot, can you also plot the cost per events on the same plot

Label the cities where the event was happening in

This is a noisy because there are too many cities. Any ideas how we can make this more presentable?

One way to make the plots more presentable is to use hover labels instead of static text labels. This way, the city names will only appear when you hover over the data points, reducing the clutter on the graph.

Let's update the plots to use hover labels for the city names.

Can you show some of the cities that are particularly high in cost? or maybe show every second city? I am exporting the image as a static plot so I would like to see the cities and probably the cost too

The arrows are perfect actually, can you please keep the annotations with the arrows, can you also add a new line below those with arrows to add the total cost, can you also remove the other labels that are present? Right now it is showing all the cities on each plot

Can you remove the text of `Total cost`? Just add a dollar sign to the cost and add it to a new line so it should be city name, then new line then the cost with a dollar sign in the millions as you have it now

Can you make some of the arrow lengths a bit varied? Specifically for Torino in the cost per athlete, it is overlapping a bit with London for both cost per event and athlete. Rio is overlapping with Beijing and Lillehammer is also overlapping with barcelona too

This is looking a lot better, for barcelona instead of it being pointed towards the bottom, can you make the arrow be on the top left of the point? That will also avoid an overlap. For Beijing, I would make the arrow be on the top right of the point

Can you try to show these actually as a vertical bar chart and have the labels of the host cities be the y axis where it is `<City> (<Year>)`

Show all of them, this just shows a subset

Can you order these by year?

Can you make the bars wider? Can you also show all the city labels.

This is ordered by cost, can you order it by year now as well?

Can you add an annotation to the right of the chart that includes the cost in Millions. Place it to the right of each bar

Can you add back the black outline around each of the bars, can you also add back the legend that shows summer / winter. Also add a dollar sign to the front of the amount

The legend doesn't show Winter for some reason, just the summer

This is looking great, only small addition is to make the black border a little thinner on the bar plots. Can you also change the red and blue to be colors more representative of summer and winter?

The borders look good, just the colors are still a little off for me. Can you come up with a better pair?

The red for summer is good, the blue for winter seems to fade into the background a bit too much. Can you adjust that?

Get started with Vizly