Graphs of Weekly Post-Counts
Welcome back to "Fun with Graphs"!
Today we'll look at graphs made from a new data set: weekly post counts. Well,
almost weekly, because I made a mistake over the US Thanksgiving weekend, and didn't realize it until Monday 26 November.
First let's look at the data set.
Basically, I ran the automated script that collects the semi-annual post-count every Sunday, starting in early October. I was working on the production scripts at the time, so around the same time I made the
October 2018 interstitial statistics update, I started collecting weekly stats.
Each weekly file includes all the same data as the semi-annual stats, so any of the statistics-producing scripts can be run with weekly files.
Each weekly file has data on 395 users, so next we need to decide what we're going to look at. The obvious thing is post-count. But we also have to decide whose post-counts to look at. It could be the Top 50 members, or the Active Top 50, or maybe the Prolific Posters, which is my new (and much shorter) name for Members With the Highest Post Counts in the Last 6 Months.
I decided to look at the Prolific Posters, because they seemed more likely to have significant post numbers from week to week. Since the Top 50 includes a fair number of inactive members, those graphs just won't change much from week to week. Even in the Active Top 50 (Table 2), there's a fair number of low-rate posters.
I used the same list of Prolific 36 members as I used for the graphs of
<< post 0000, which is the top 36 in Table-2 sorted by 6-month post count. I also broke them down into 3 groups of 12 members each, and graphed each group separately.
Weekly Total Post Counts
Given the weekly data set, and the subset of whose data to graph, here's the 1st graph:
View attachment 814450
You can tell that
@Scepticalscribe has a decent post rate, because the line slopes upward.
@Apple fanboy also has a noticeable upward slope. And
@I7guy is creeping up on
@The Game 161, which are the pink and gray lines at the bottom of the graph.
If you look carefully, you can see a slight difference in the distance between 2018-11-12 and 2018-11-26, which is the one-day delay it took me to fix my mistake.
For the most part, though, this is a pretty flat graph.
The graph for group 2 is a bit more interesting:
View attachment 814451
The bottom parts of the graph show a bit of neck-and-neck in November, and
@Fishrrman has a marked up-slope over the whole period.
Let's see the last group:
View attachment 814452
This looks a lot more interesting. You can easily see variations from week to week, and the changes in post rate as each line flattens or steepens.
Posts per Week
Since I was mostly interested in the week-to-week changes in post counts, we can calculate and graph posts per week. To do this, we take one week's post-count and subtract the prior week's post-count, which gives the change in posts per week.
In these graphs, someone who posts about the same amount every week will have a fairly flat line at a location above 0. Someone who posts a lot in one week, followed by a little, will have an up-and-down jagged flat line.
To calculate the first change, we need 2 weeks of data. The first week's post-counts are from 2018-10-08, and the second week's are from 2018-10-14. Subtract the earlier post-count from the later one, and the result is how many posts were made in the week ending on 2018-10-14. Do the same thing for each subsequent week, and you get a series of number representing the post-counts made each week, ending on a date.
That's what these 3 graphs are: the post-count for the week ending on a date.
Note: These are different groups than the Weekly Total Posts graphs.
View attachment 814453
There are lots of jagged lines here, which means lots of variation in post-count from week to week.
Let's look at the graph for group 2:
View attachment 814454
Again, lots of jagged lines, but looking at the counts on the vertical axis, it's not really as big as for group 1.
There's a notable spike for several members around the weeks ending on Nov 4 (2018-11-04) and Nov 11 (2018-11-11), almost as if there were a highly anticipated product release of some kind
(iPad Pro).
The graph for group 3 is similar:
View attachment 814455
Here, the spike around the iPad Pro release shows a more rapid tapering off.
What Else?
Instead of showing the weekly post counts, I could graph the cumulative change in post count. This would show upward sloping lines for lots of posts in a week, and flatter lines for fewer posts. Such a graph would look more like the one titled "Weekly Total Posts: Group 3", instead of like a badly colored mountain range.
I could graph some other value collected in the stats, such as Like counts. Those tend to roughly follow post counts, though, so they may not be that interesting to see.
Those two counts, posts and Likes, are pretty much the only thing that changes weekly, and that I have data for. The Followers and Following counts are very stable, and change very little even over an entire year. Rank by post-count changes occasionally, and you can see it when one line crosses another in the Total Posts graphs.
If you have an idea for something else to graph from either the weekly or the semi-annual data sets, post it in a reply and I'll see what I can do for another episode of "Fun With Graphs".