Preprocessing

Data import

Period       object
Event      category
User         object
Channel    category
Count         int64
dtype: object
Period Event User Channel Count
Period
2019-05-01 00:00 2019-05-01 00:00 msg u201905$vpHTqbOA #off-topic 2
2019-05-01 00:00 2019-05-01 00:00 msg u201905$lRuLLgvp #fantasy 1
2019-05-01 00:00 2019-05-01 00:00 msg u201905$mhRvITOu #worldbuilding 1
Period Event User Channel Count
Period
2019-06-30 23:00 2019-06-30 23:00 msg u201906$eujNOMc4 #off-topic 5
2019-06-30 23:00 2019-06-30 23:00 msg u201906$TVIMQBvr #worldbuilding 2
2019-06-30 23:00 2019-06-30 23:00 msg u201906$K3Ggn89g #fantasy 2

Date range

Months to process:

  • May 2019
  • June 2019

Membership

Summary

mean std min max
total (users) NaN NaN 5665.0 6355.0
active daily (users) 151.44 10.74 131.0 183.0
active total (users) NaN NaN NaN NaN
Δusers (with purges, users/day) 9.02 31.15 -171.0 47.0
Δusers (natural only, users/day) 14.46 7.43 0.0 47.0

May 2019

mean std min max
total (users) NaN NaN 5665.0 6075.0
active daily (users) 150.00 10.84 134.0 183.0
active total (users) 901.00 NaN NaN NaN
Δusers (with purges, users/day) 13.23 6.01 3.0 28.0
Δusers (natural only, users/day) 13.23 6.01 3.0 28.0

June 2019

mean std min max
total (users) NaN NaN 5890.0 6355.0
active daily (users) 152.93 10.62 131.0 172.0
active total (users) 947.00 NaN NaN NaN
Δusers (with purges, users/day) 4.67 43.96 -171.0 47.0
Δusers (natural only, users/day) 15.73 8.57 0.0 47.0

Purges

Δusers
Period
2019-06-01 00:00 -184.0
2019-06-30 04:00 -148.0

Server Activity

Value
Text (messages) 375934.0
Voice (user-hours) 185.8
mean std min max
Daily messages 6162.85 1333.48 3731.00 9635.00
Daily messages/user 40.86 8.09 23.61 59.48
Daily users 150.75 10.55 131.00 180.00
Daily voice hours/user 0.53 0.81 0.00 4.20
Voice hours/day 3.34 3.56 0.00 19.00

May 2019

Value
Text (messages) 174159.00
Text users 892.00
Voice (user-hours) 31.47
Voice users 44.00
mean std min max
Daily messages 5618.03 1009.97 3731.00 8726.00
Daily messages/user 37.74 6.94 23.61 57.79
Daily users 149.39 10.66 133.00 180.00
Daily voice hours/user 0.25 0.41 0.00 1.69
Voice hours/day 2.16 3.38 0.00 19.00

June 2019

Value
Text (messages) 201775.00
Text users 936.00
Voice (user-hours) 154.33
Voice users 67.00
mean std min max
Daily messages 6725.83 1406.62 4.46e+03 9635.00
Daily messages/user 44.09 8.02 2.89e+01 59.48
Daily users 152.17 10.42 1.31e+02 172.00
Daily voice hours/user 0.83 1.01 6.94e-04 4.20
Voice hours/day 4.57 3.37 1.00e+00 14.00

User text activity

messages/user active users
mean min 25% 50% 75% max total top 80%
May 2019 195.25 1.0 3.0 15.0 84.0 7578.0 892.0 97.0
June 2019 215.57 1.0 3.0 14.0 89.0 7448.0 936.0 92.0

Channel activity

Interpretation notes:

  • Total messages: Fairly obvious. Keep in mind that this doesn't consider length or depth of messages, only number.
  • Messages/user
    • Plot shows average (arithmetic mean) only.
    • We can get an idea of the spread by looking at the min, 25%, median, 75% and max values. In between each one (e.g. between min and 25%) is 1/4 of the total active users.
  • Active users
    • 'Total' counts the number of users who said at least one message in the channel.
    • Top 80% answers the question: how many of the top users for that channel account for 80% of the messages in that channel?" (The top 80%/total column gives the percentage.) The closer this is to 80% of the total active users, the more evenly different users contribute. The smaller this number is compared to the total, the more the channel is dominated by a specific group with few occasional users dropping in and out.

May 2019

messages messages/user users
total mean min 25% median 75% max total top 80% top 80%/total
Channel
#worldbuilding 63658 111.49 1 2 9.0 68.00 3946 571 76 13.31
#off-topic 49964 230.25 1 3 18.0 136.00 4599 217 26 11.98
#fantasy 12218 47.91 1 3 14.0 42.50 593 255 59 23.14
#detailbuilding 9420 48.56 1 4 18.5 48.00 553 194 53 27.32
#sci-fi 7779 54.40 1 4 14.0 34.00 1107 143 26 18.18
#geography 6246 35.09 1 3 8.0 32.75 814 178 38 21.35
#art 5568 27.98 1 2 6.0 22.50 1094 199 42 21.11
#community-programs 5032 49.82 1 3 15.0 53.00 901 101 22 21.78
#humanities 2896 34.48 1 3 7.0 27.75 631 84 17 20.24
#conlangs 2766 38.42 1 2 5.0 28.50 749 72 11 15.28
#alt-history 2600 32.91 1 2 7.0 28.00 450 79 15 18.99
#writing-and-music 2158 25.09 1 2 7.0 20.75 302 86 18 20.93
#science 2040 23.45 1 2 8.0 28.50 271 87 25 28.74
#tabletop 959 16.82 1 2 6.0 14.00 143 57 15 26.32
#meta 743 9.65 1 2 4.0 12.00 83 77 26 33.77
#resources 60 1.82 1 1 1.0 2.00 6 33 21 63.64