project:tour_de_france_history

Differences

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

Link to this comparison view

Next revision
Previous revision
project:tour_de_france_history [2014/05/23 18:18] – created jajinaproject:tour_de_france_history [2014/05/24 11:23] (current) dergraf
Line 5: Line 5:
  
 Ideas we have: Ideas we have:
 +
   * very interesting would be to put together gps data from Tour and map all these races. There are a lot of services where people put there bike tracks (like bikemap.net, strava, mapmyride etc), for sure there are also stages of at least latest Tours. Plus we could probably get this from official website...   * very interesting would be to put together gps data from Tour and map all these races. There are a lot of services where people put there bike tracks (like bikemap.net, strava, mapmyride etc), for sure there are also stages of at least latest Tours. Plus we could probably get this from official website...
   * put the race data together with drugs or technique enhancements   * put the race data together with drugs or technique enhancements
Line 10: 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 =====
-[[http://www.letour.fr/HISTO/us/TDF/]] 
  
-[[http://bikeraceinfo.com/tdf/tdfindex.html]]+[[http://www.letour.fr/HISTO/us/TDF/|letour.fr]] > should be scraped and parsed 
 + 
 +[[http://bikeraceinfo.com/tdf/tdfindex.html|bikeraceinfo.com]] > used for stages extraction (difficult) 
 + 
 +[[https://cat6.trainingpeaks.com/races/tour-de-france.aspx|trainingpeaks.com]] > one rider's performance 
 + 
 +[[http://www.sport-histoire.fr/Sport/Cyclisme/Tour_de_France/Editions/1986.php|sport-histoire.fr]] 
 + 
 +[[http://ledicodutour.perso.sfr.fr/etapes/classements_etapes/classement_etapes_1987_1996/classement_etapes_1994.htm|ledicodutour.perso.sfr.fr]]
  
-[[https://cat6.trainingpeaks.com/races/tour-de-france.aspx]]+[[https://docs.google.com/spreadsheets/d/10tWLI0jpPBspbrBun_CEWtTdx-7LwiHN9yYBSdMpHc4/edit?usp=sharing|Own compiled dataset]]
  
 ===== Team ===== ===== Team =====
  
   * [[user:jajina]]   * [[user:jajina]]
 +  * [[user:dergraf]]
   * and others   * and others
  
Line 26: Line 42:
  
      
-{{tag>status:concept needs:dev needs:design needs:data needs:expert}}+{{tag>status:concept needs:dev needs:design needs:data needs:expert sport}}
  • project/tour_de_france_history.1400861930.txt.gz
  • Last modified: 2014/05/23 18:18
  • by jajina