project:tour_de_france_history

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
project:tour_de_france_history [2014/05/23 20:05] dergrafproject:tour_de_france_history [2014/05/24 11:23] (current) dergraf
Line 11: Line 11:
   * how has Tour developed? how has the elevation/distance/distance per stage/number of stages changed? how have the sizes of teams changed?   * how has Tour developed? how has the elevation/distance/distance per stage/number of stages changed? how have the sizes of teams changed?
   * another interesting challenge would be to get data of individual riders and see how they perform during the race (eg. trainingpeaks has some riders data including heart rate, watts, speed during the race etc.)   * another interesting challenge would be to get data of individual riders and see how they perform during the race (eg. trainingpeaks has some riders data including heart rate, watts, speed during the race etc.)
 +
 +Besides these sports related ideas it would be interesting to correlate external historical events (such as advancements in technology or drug abuse in sports) with the trends discovered in the historical Tour de France data. For a further discussion of these topics we compiled a dataset through scraping //letour.fr// and //bikeraceinfo.com// that brings together the average overall performance of the Tour de France over years with the performance of the winning athlete.
 +
 +{{url>http://docs.google.com/a/dergraf.org/spreadsheets/d/10tWLI0jpPBspbrBun_CEWtTdx-7LwiHN9yYBSdMpHc4/gviz/chartiframe?oid=122673592 371 773 noscroll noborder}}
 +Unfortunately the data between 1904 and 1914 is incomplete, that mainly comes from the different performance measuring system applied during the tour (points vs. time). For the years 1915-1918 and 1940-1946 no data exists due to the 1st and 2nd world wars.
 +
 +The Winner data also **includes** athletes that were later disqualified due to e.g. doping.
  
 ===== Data ===== ===== Data =====
Line 23: Line 30:
  
 [[http://ledicodutour.perso.sfr.fr/etapes/classements_etapes/classement_etapes_1987_1996/classement_etapes_1994.htm|ledicodutour.perso.sfr.fr]] [[http://ledicodutour.perso.sfr.fr/etapes/classements_etapes/classement_etapes_1987_1996/classement_etapes_1994.htm|ledicodutour.perso.sfr.fr]]
 +
 +[[https://docs.google.com/spreadsheets/d/10tWLI0jpPBspbrBun_CEWtTdx-7LwiHN9yYBSdMpHc4/edit?usp=sharing|Own compiled dataset]]
  
 ===== Team ===== ===== Team =====
  • project/tour_de_france_history.txt
  • Last modified: 2014/05/24 11:23
  • by dergraf