Now that we have learnt details of Table API, let's try to apply this knowledge to a real life use case. Consider we have a dataset with us, which has information about the Olympic athletes and their performance in various games.
The sample data looks like that shown in the following table:
Player |
Country |
Year |
Game |
Gold |
Silver |
Bronze |
Total |
Yang Yilin |
China |
2008 |
Gymnastics |
1 |
0 |
2 |
3 |
Leisel Jones |
Australia |
2000 |
Swimming |
0 |
2 |
0 |
2 |
Go Gi-Hyeon |
South Korea |
2002 |
Short-Track Speed Skating |
1 |
1 |
0 |
2 |
Chen Ruolin |
China |
2008 |
Diving |
2 |
0 |
0 |
2 |
Katie Ledecky |
United States |
2012 |
Swimming |
1 |
0 |
0 |
1 |
Ruta Meilutyte |
Lithuania |
2012 |
Swimming |
1 |
0 |
0 |
1 |
Dániel Gyurta |
Hungary |
2004 |
Swimming |
0 |
1 |
0 |
1 |
Arianna Fontana |
Italy |
2006 |
Short-Track Speed Skating |
0 |
0 |
1 |
1 |
Olga Glatskikh |
Russia |
2004 |
Rhythmic Gymnastics |
1 |
0 |
0 |
1 |
Kharikleia Pantazi |
Greece |
2000 |
Rhythmic Gymnastics |
0 |
0 |
1 |
1 |
Kim Martin ... |