I have a site called Sudomemo. I record when I first see a user in the database; and I've exported it in JSON format, located here.
I've done this:
dates = Import["http://www.sudomemo.net/statistics/firstSeenDump.php", "JSON"]
I want to plot, since February, how the user-join rate increases/decreases, over the course of the year.
Thinking about it mathematically: Since the derivative of a function shows the slope of a function, and the second derivative shows the concavity/how quickly the slope is changing, I should graph the second derivative of the timestamps over the year. I think I have the right idea... I'm still learning about derivatives in Calculus :P
The only issue is, I have no idea how to go about doing that!
I'm pretty new to Mathematica, and thought this would make a fantastic chart. Not only that, but I've installed Mathematica 10 on my server, and I'd love to be able to present
cool graphs :D some interesting statistics to interested users.
Right now, I've simply used the
json_encode() PHP function to produce the timestamps like this:
["2014-01-29 16:49:00","2014-01-29 16:49:00","2014-01-29 16:49:00"...
I can change the array format to something different if that'd be better suited for this.
Would anyone be able to point me in the right direction?
Note: The first hundred values or so are all 2014-01-29 16:49:00 because that's when I first started recording the "first seen" timestamps.
http://www.sudomemo.net/statistics/firstSeenDump.php?nospike doesn't show the ones from January 29th 16:49:00.