These are chat archives for FreeCodeCamp/DataScience

20th
Dec 2015
Suzanne Atkinson
@AdventureBear
Dec 20 2015 00:33
What's a good way to visualize this data that would help show year, rider, doping and time?
Bruce Young
@mutantspore
Dec 20 2015 02:09
@AdventureBear PM’ed you some ideas
evaristoc
@evaristoc
Dec 20 2015 09:49
@AdventureBear I would advice to use a horizontal representation of a year time horizon in the first place. Bars are usual too.
Suzanne Atkinson
@AdventureBear
Dec 20 2015 21:24
@mutantspore & @evaristoc thansk for the suggestions! The original data came from wikipedia, and I basically did a copy/ paste adn created this spreadsheet:
I have two questions about the data. I want to extract this to a CSV or JSON so I can work with it, but the times are reperestented as text based fields like 35' 44" for example. I struggled with some regex and string search and replace in google docs to represent this in a time/date formate and was unsuccessful. I'm trying to use an automated solution to convert them all. Would you just do this in javascript before doing the data vis, or is there another idea?
My 2nd question is the HTML links. Is there a way to extract this as "description", "link" from the google sheet? When I export it to a csv, I lose the link/URL. although the final field where I experimented with time / duration looks al ittle better.
I think this will be fun to look at when it's done (please don't do it for me! or if you do don't tell me about it).
Bruce Young
@mutantspore
Dec 20 2015 21:42
@AdventureBear lol as it’s only 35 … just do it by hand as you’d be done by now . No, I have another one to do myself .. no interfering unless asked !!! :)
store the times as seconds @AdventureBear
Suzanne Atkinson
@AdventureBear
Dec 20 2015 21:47
I know...I do this ALL THE TIME. My brain says yeah, but what if it was thousands??
OK thanks!
in fact, this personality trait is the whole reason I'm here in freecodecamp...to learn how to program automated solutions I've been doing manually for 10 years
Bruce Young
@mutantspore
Dec 20 2015 21:49
hahahaha I’m sure you could solve it but it’s not the real task here and just slowing you down
Suzanne Atkinson
@AdventureBear
Dec 20 2015 21:51
true. Thanks @mutantspore
what? No gitterbot??
CamperBot
@camperbot
Dec 20 2015 21:52
adventurebear sends brownie points to @mutantspore :sparkles: :thumbsup: :sparkles:
Bruce Young
@mutantspore
Dec 20 2015 21:52
a thankless task :(
lol
CamperBot
@camperbot
Dec 20 2015 21:52
:star: 874 | @mutantspore | http://www.freecodecamp.com/mutantspore
Bruce Young
@mutantspore
Dec 20 2015 21:54
I’llbe hitting the heatmap idea hard tonight. hopefully it will behave..
lol delayed brownies
Suzanne Atkinson
@AdventureBear
Dec 20 2015 21:59
I did it...I was thinking too hard. I'm thought, OK, what's the easiest way to do this by hand? which led to this formula =left(B2,2)*60 + LEFT(right(B2,3),2)
on my way!
Bruce Young
@mutantspore
Dec 20 2015 21:59
woo hoo
lol
Suzanne Atkinson
@AdventureBear
Dec 20 2015 22:01
im such a nerd. TIme for a break...steelers vs broncos on TV
Bruce Young
@mutantspore
Dec 20 2015 22:01
nothing like a bit of pseudo code. I see campers often say they don’t know what to do but then go on to actually say what they should do ..
Suzanne Atkinson
@AdventureBear
Dec 20 2015 22:02
right! I've taught myself a lot by trying to write to a stack overflow question that won't get me downvoted , then solved it in the process