Not a DB but think this is the most relevant forum.
I have been interested in looking at how rider's stats develop for a while. As a start on this it occurred to me that I could use the PCM actual stats across time to look at how PCM viewed real riders developing.
There is noise in that because the game has changed and the individuals assigning stats have changed but it should still reflect a reasonable view of actual rider development.
Decided to use PCM's DB rather than Cyanide since PCM is generally more thoughtful and looks at more riders. I have all the PCM DB's back to 2011 and I consolidated the Cyclist data into one table.
Then I spent a bunch of time making the rider IDs, names and birth dates consistent so that a single rider has a single ID, name and birthdate through all 8 years. Think I got it pretty clean but there might still be issues. The link below is this file.
The file allows you to easily see how a riders stats developed or deteriorated over time. I plan to do some more analysis on development but since I spent a bunch of time cleaning it I thought I would post it now and post on my analysis whenever I do it.
A few comments:
1. The new ID reflects my clean ID, the IDCyclist should be what was in the original DB. However, I think I messed this up a little and the old ID may not always be good.
2. The "Type" field is a system I came up with to categorize riders with a little more specificity than "climber" or "rouler". There is a tab that explains this field more. I think this gives another way to look at how riders change over time. I have some ideas on how to use this to assess a DB overall and also to profile teams. Will maybe post on that at some point.
3. I think all the other fields are self-explanatory. There are excel comments in the headers as well for some of them.
4. To make the file more efficient I hard copied values for a number of columns. The formulas are in a row at the top and can be copied back down if you want to see what was done or modify them.
