The 24th Winter Olympic Games came to a successful conclusion in Beijing on February 20. This Winter Olympics, The Chinese sports delegation created a number of records, won 9 gold, 4 silver and 2 bronze winter Olympics history best record!

From 1980, when China first competed in the winter Olympic Games, to 1992, when China won its first winter Olympic medal, to this year, when China ranked Top3 in the medal tally, Beijing became the “city of both Olympics”. China’s ice and snow sports have been climbing new heights step by step.

How much do you know about China’s “frozen”? This article reviews the course of The Chinese delegation in the Winter Olympic Games. ** Based on open source and public data, we used Tableau, a data visualization analysis tool, to explore the data related to the Winter Olympics in China. ** The following is the process and results of our data exploration.

Data preprocessing

Data Source Description

We use open source data from Kaggle data source address: www.kaggle.com/heesoo37/12… **

Data preprocessing process

  1. Firstly, we filter and export the data related to Chinese athletes from the open source data according to the nationality (Team) field.

  2. Create a new table in Hive based on predefined data analysis dimensions and insert exported offline data into the new table.

  3. Source data are preprocessed for fields such as Gender, Age, Year, Sport and Medal, including null value filling, integration of synonymous fields and elimination of invalid fields.

  4. Based on data display requirements, relevant fields are grouped, aggregated, and de-weighted to provide data support for visual analysis.

Data exploration results and visual presentation

The largest participation in history: The Beijing Winter Olympic Games for the first time

In the 42 years from 1980 to 2022, The cause of ice and snow sports in China has been developing continuously, and the Chinese delegation has participated in more and more types of Winter Olympics events. This year, China has achieved 7 major events, 15 sub-events in all events, whether in the “ice events” or in the “snow events”, this year’s Beijing Winter Olympic Games are the Chinese sports delegation in the history of the largest participation in a Winter Olympic Games.

So many Olympic events, which belong to the Advantage of Chinese ice and snow athletes? We have made statistics on the number of MEDALS won by China in various categories of winter Olympic events.

You can always trust China’s short track speed skating team!

Statistics show that short track speed skating is the most advantageous ice and snow event for The Chinese delegation, with a total of 30 athletes winning winter Olympic MEDALS in this event.

The short track speed skating team, which has long been called the “gold medal team” of the Chinese Ice and snow Team, maintained its strong standard to win the first gold medal of the Chinese delegation at the Beijing Winter Olympics. As netizens said, “You can always trust the Chinese short track speed skating team”! They defend the honor of “gold medal division” with super strength, and create a “good start” for the people of the whole country in the sixth day of the year!

The situation of “strong ice and weak snow” of Chinese team was reversed: 4 new gold MEDALS were added for the first time in snow events

We also sorted out the events in which The Chinese delegation won the first gold medal at the previous Winter Olympics **. According to statistics, the first winter Olympics event in which China achieved zero gold MEDALS was short track speed skating, followed by freestyle skiing aerials and figure skating. This shows that China has not only won more MEDALS in these three winter Olympics events, but also achieved zero gold MEDALS earlier, reaching the world leading level ten years ago.

It can be seen from the time dimension that the 2022 Beijing Winter Olympics has achieved the largest number of gold MEDALS in China, winning the first gold medal in seven winter Olympics events. They are snowboarding men’s big jump, speed skating men’s 500m, short track speed skating mixed 2000m relay, short track speed skating men’s 1000m, women’s halfpipe freestyle skiing, women’s big jump freestyle skiing, women’s aerial freestyle skiing.

It can be seen that among the seven gold MEDALS won at this year’s Beijing Winter Olympic Games, four gold MEDALS were won by metal on snow. This shows that China’s competitive level of snow sports is constantly improving, and the situation of “strong ice and weak snow” in China has finally changed.

23-25 years old is the golden age for winter Olympic athletes, and the largest age difference for gold medal is 19 years old

We also analyzed the age distribution of Chinese ice and snow athletes. As can be seen from the figure below, 23-25 years old is the age when Chinese ice and snow athletes win a large number of winter Olympic MEDALS, which to some extent indicates that 23-25 years old is the golden age for Chinese Winter Olympic athletes.

Comparing the maximum and minimum ages of athletes who won gold MEDALS, we found that the maximum age difference between Chinese winter Olympic champions’ gold MEDALS was 19 years. At the 2010 Vancouver Winter Olympics, Zhao hongbo, 36 years old, came back to compete and teamed up with Shen Xue to win the gold medal in pairs skating with a total score of 216.57, the first gold medal in Chinese figure skating history. The record was set by su Yiming, a 17-year-old Chinese snowboarder who became China’s first snowboarding champion at the 2022 Beijing Winter Olympics.

Zhang Hao participated in the Winter Olympic Games for the most times. Figure skater’s career is not short

Through the analysis of the number of Chinese ice and snow athletes participating in Winter Olympics, we find that figure skater Zhang Hao has participated in the most winter Olympics, taking part in a total of five times. He made his first appearance in the 2002 Winter Olympics in Salt Lake City and announced his retirement before the Beijing Winter Olympics. His figure skating career has lasted for more than 30 years.

Combined with the fact that the maximum age record for winning gold MEDALS was also set by figure skater, we can conclude that figure skater’s sports career is not short among Chinese ice and snow athletes.

Eighteen of them have won at least three winter Olympics MEDALS, with Wang Meng topping the medal tally

We also analyzed the number of winter Olympic MEDALS won by Chinese ice and snow athletes. Statistics show that **, a total of 18 athletes have won at least three MEDALS in the Winter Olympics, including wang Meng, Yang Yang, Wu Dajing, Li Jiajun, Yang Yang and other five short-track speed skaters have won at least five MEDALS. **

Topping the medal table of China’s Winter Olympics is Wang Meng, who attracted millions of fans for his humorous and professional commentary during the Beijing Winter Olympics. In the 2006 Turin Winter Olympics, Wang Meng won 1 gold, 1 silver and 1 bronze. She won three gold MEDALS at the 2010 Vancouver Winter Olympics. She has accumulated 6 winter Olympic MEDALS. Although she has retired, the name “Wang Meng” is still widely rumored in the ice and snow rivers and lakes.

conclusion

The above is the process and result of our visual analysis of the data of Chinese delegation winning awards in previous Winter Olympic Games. Through the above data visualization chart, what are your different perceptions of China’s “frozen”?