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 |