https://files.catbox.moe/vixza0.png
https://files.catbox.moe/yeruvz.png
https://files.catbox.moe/o623jj.png

Vtubers: 67

Highest Average Messages per Minute: Filian at 268 MPM

Highest Average CCV: ironmouse(*) at 9686
Highest Average Unique Chatters: Filian at 4808

Highest Messages per Minute Adjusted for CCV: Lyra 0.0977 MPM per CCV
Lowest Messages per Minute Adjusted for CCV: Fefe 0.0054 MPM per CCV
Full list below

Highest Average Words per Message: honey_goblin at 8.67 words per message
Lowest Average Words per Message: nacho_dayo at 1.64 words per message


(*) though I included her here, ironmouse is not included in the graphed data
_______________________________________________________________________________________________________________________________________




Goal:
Analyze the chat logs of several vtubers to determine trends, if any, and to highlight the data of Olivia Monroe


Method:
Grab the chat logs for the last 40 streams using the twitch downloader CLI https://github.com/lay295/TwitchDownloader and get the average ccv for the last month through twitchtracker.com

Once chat logs are downloaded, calculate the following
unique chatters: anyone who sends a message in stream at least once
messages per minute (MPM): calculate the total number of messages divided by length of the stream.
	does not account for chatbots such as Nightbot, though the only chatbots with significant spam that might impact these numbers is Tobs
	does not account for short streams that crash and restart, assuming chat activity is much greater at start of streams this might 				skew data
words per message: number of words in a message, does not account for if the message was just emotes or not
then..
average all the data across all streams for that streamer

Streams crashing becomes a big issue especially if it's near the start of the stream. e.g. a 50 minute stream where everyone is spamming hellos is equally weighted to a 30 hour stream



Ranking chat speed accounting for the size of the streamer

Streamer,Average Messages per Minute,Messages per Minute per CCV
lyra,28.62,0.0976
crayonvt,30.41,0.09243
inislein,19.25,0.0729
eros,39.41,0.0633
NyanaBanyanaVT,10.56,0.0613
lucypyre,99.6,0.0610
meat,44.49,0.0563
fallenshadow,123.92,0.0543
nihmune,173.38,0.0533
calliecalico,15.9,0.0517
kitanya_is_here,11.94,0.0508
nekrolina,38.43,0.0480
cerberVT,40.27,0.0475
shirahiko,22.53,0.0461
overezeggs,14.8,0.0430
bajiru_EN,12.74,0.0426
mysticlight,11.3,0.0421
deme,71.14,0.0403
tobs,31.15,0.0395
coqui,30.05,0.0392
rosedoodle,21.75,0.0375
JeanFaymas,18.21,0.0365
ebiko,8.87,0.0362
sinuuki,13.46,0.0361
JuniperActias,46.99,0.0359
filian,268.31,0.0354
PorcelainMaid,29.18,0.0345
vividlyvivi,12.12,0.0326
kirsche,44.57,0.0321
hinabobina,17.95,0.0320
mintcastella,16.16,0.0310
vesper,11.17,0.0298
yuzu,56.1,0.0278
rubee,20.56,0.0273
froggyhoppins,17.92,0.0273
meicha,13.18,0.0272
cottontailva,70.57,0.0255
kanekolumi,31.22,0.0250
chibidoki,59.4,0.0248
Ellie_Minibot,21.79,0.0245
squchan,41.72,0.0243
onigiri,50.11,0.0226
clauvio,13.26,0.0223
FroggyLoch,22.43,0.0218
heavenlyfather,11.6,0.0216
laynalazar,46.86,0.0213
MakoFukasame,15.51,0.0211
leeandlie,25.07,0.0211
limes,45.5,0.0206
henyathegenius,100.93,0.0204
nyanners,47.09,0.0203
saruei,40.42,0.01926
buffpup,48.56,0.0192
sinder,66.97,0.01827
fuxelbau,9.87,0.0162
imakuni,8.29,0.0161
bao,39.63,0.0162
honey_goblin,9.38,0.0145
snuffy,27.42,0.0145
dokibird,52.12,0.0144
ecto,10.42,0.0137
shylily,41.34,0.0119
rainhoe,17.79,0.0117
oliviamonroe,34.14,0.0117
obkatiekat,12.89,0.0108
silvervale,23.01,0.0078
nacho_dayo,19.84,0.0072
halo_sweety,13.49,0.0056
fefe,9.58,0.0054


R2 values for graphs

Relationship,Linear R²,Quadratic R²,Logarithmic R²
Average CCV vs Average Messages per Minute,0.6015,0.6784,0.3756
Average CCV vs Average Unique Chatters,0.7966,0.8508,0.5529
Average CCV vs MPM per CCV Ratio,0.1288,0.2553,0.2701


Data:

bajiru_EN
average ccv: 299
Average unique users: 146.88
Average stream duration: 193.56 minutes
Average words per message: 4.85
Super-average MPM across all files: 12.74
bao
average ccv: 2450
Average unique users: 1029.85
Average stream duration: 230.96 minutes
Average words per message: 4.38
Super-average MPM across all files: 39.63
buffpup
average ccv: 2523
Average unique users: 1201.00
Average stream duration: 254.49 minutes
Average words per message: 4.16
Super-average MPM across all files: 48.56
calliecalico
average ccv: 307
Average unique users: 299.29
Average stream duration: 399.85 minutes
Average words per message: 5.43
Super-average MPM across all files: 15.90
cerberVT
average ccv: 847
Average unique users: 623.94
Average stream duration: 296.71 minutes
Average words per message: 5.20
Super-average MPM across all files: 40.27
chibidoki
average ccv: 2386
Average unique users: 1670.08
Average stream duration: 321.64 minutes
Average words per message: 3.70
Super-average MPM across all files: 59.40
clauvio
average ccv: 594
Average unique users: 271.06
Average stream duration: 195.21 minutes
Average words per message: 5.22
Super-average MPM across all files: 13.26
coqui
average ccv: 766
Average unique users: 518.81
Average stream duration: 349.02 minutes
Average words per message: 4.82
Super-average MPM across all files: 30.05
cottontailva
average ccv: 2766
Average unique users: 1578.24
Average stream duration: 206.56 minutes
Average words per message: 4.40
Super-average MPM across all files: 70.57
crayonvt
average ccv: 329
Average unique users: 258.36
Average stream duration: 187.65 minutes
Average words per message: 3.88
Super-average MPM across all files: 30.41
deme
average ccv: 1765
Average unique users: 1358.40
Average stream duration: 360.64 minutes
Average words per message: 3.24
Super-average MPM across all files: 71.14
dokibird
average ccv: 3618
Average unique users: 1016.50
Average stream duration: 212.54 minutes
Average words per message: 3.59
Super-average MPM across all files: 52.12
ebiko
average ccv: 245
Average unique users: 194.68
Average stream duration: 295.58 minutes
Average words per message: 5.01
Super-average MPM across all files: 8.87
ecto
average ccv: 757
Average unique users: 335.83
Average stream duration: 410.56 minutes
Average words per message: 5.89
Super-average MPM across all files: 10.42
Ellie_Minibot
average ccv: 889
Average unique users: 584.18
Average stream duration: 335.50 minutes
Average words per message: 6.45
Super-average MPM across all files: 21.79
eros
average ccv: 622
Average unique users: 486.77
Average stream duration: 296.44 minutes
Average words per message: 4.03
Super-average MPM across all files: 39.41
fallenshadow
average ccv: 2280
Average unique users: 1175.37
Average stream duration: 302.33 minutes
Average words per message: 3.34
Super-average MPM across all files: 123.92
fefe
average ccv: 1762
Average unique users: 254.21
Average stream duration: 230.45 minutes
Average words per message: 5.08
Super-average MPM across all files: 9.58
filian
average ccv: 7577
Average unique users: 4808.14
Average stream duration: 252.59 minutes
Average words per message: 2.82
Super-average MPM across all files: 268.31
froggyhoppins
average ccv: 656
Average unique users: 589.52
Average stream duration: 329.49 minutes
Average words per message: 6.48
Super-average MPM across all files: 17.92
FroggyLoch
average ccv: 1026
Average unique users: 773.48
Average stream duration: 362.92 minutes
Average words per message: 4.74
Super-average MPM across all files: 22.43
fuxelbau
average ccv: 607
Average unique users: 418.55
Average stream duration: 462.99 minutes
Average words per message: 4.88
Super-average MPM across all files: 9.87
halo_sweety
average ccv: 2377
Average unique users: 268.52
Average stream duration: 130.26 minutes
Average words per message: 4.58
Super-average MPM across all files: 13.49
heavenlyfather
average ccv: 537
Average unique users: 343.52
Average stream duration: 262.12 minutes
Average words per message: 5.58
Super-average MPM across all files: 11.60
henyathegenius
average ccv: 4943
Average unique users: 2130.72
Average stream duration: 334.97 minutes
Average words per message: 3.84
Super-average MPM across all files: 100.93
hinabobina
average ccv: 560
Average unique users: 335.44
Average stream duration: 334.96 minutes
Average words per message: 5.97
Super-average MPM across all files: 17.95
honey_goblin
average ccv: 645
Average unique users: 374.78
Average stream duration: 244.54 minutes
Average words per message: 8.67
Super-average MPM across all files: 9.38
imakuni
average ccv: 512
Average unique users: 285.79
Average stream duration: 505.39 minutes
Average words per message: 6.66
Super-average MPM across all files: 8.29
inislein
average ccv: 264
Average unique users: 219.80
Average stream duration: 183.34 minutes
Average words per message: 4.85
Super-average MPM across all files: 19.25
JeanFaymas
average ccv: 498
Average unique users: 394.94
Average stream duration: 448.30 minutes
Average words per message: 5.15
Super-average MPM across all files: 18.21
JuniperActias
average ccv: 1307
Average unique users: 592.19
Average stream duration: 225.23 minutes
Average words per message: 3.93
Super-average MPM across all files: 46.99
kanekolumi
average ccv: 1244
Average unique users: 552.09
Average stream duration: 267.25 minutes
Average words per message: 5.36
Super-average MPM across all files: 31.22
kirsche
average ccv: 1386
Average unique users: 984.52
Average stream duration: 299.88 minutes
Average words per message: 6.38
Super-average MPM across all files: 44.57
kitanya_is_here
average ccv: 235
Average unique users: 224.09
Average stream duration: 330.06 minutes
Average words per message: 4.81
Super-average MPM across all files: 11.94
laynalazar
average ccv: 2195
Average unique users: 1250.48
Average stream duration: 289.09 minutes
Average words per message: 4.28
Super-average MPM across all files: 46.86
leeandlie
average ccv: 1188
Average unique users: 586.94
Average stream duration: 271.40 minutes
Average words per message: 4.57
Super-average MPM across all files: 25.07
limes
average ccv: 2202
Average unique users: 1241.15
Average stream duration: 339.11 minutes
Average words per message: 4.74
Super-average MPM across all files: 45.50
lucypyre
average ccv: 1632
Average unique users: 959.53
Average stream duration: 245.04 minutes
Average words per message: 3.51
Super-average MPM across all files: 99.60
lyra
average ccv: 293
Average unique users: 211.94
Average stream duration: 231.72 minutes
Average words per message: 3.69
Super-average MPM across all files: 28.62
MakoFukasame
average ccv: 733
Average unique users: 412.68
Average stream duration: 398.87 minutes
Average words per message: 5.50
Super-average MPM across all files: 15.51
meat
average ccv: 790
Average unique users: 717.00
Average stream duration: 442.59 minutes
Average words per message: 4.22
Super-average MPM across all files: 44.49
meicha
average ccv: 484
Average unique users: 286.67
Average stream duration: 361.39 minutes
Average words per message: 4.53
Super-average MPM across all files: 13.18
mintcastella
average ccv: 520
Average unique users: 455.48
Average stream duration: 417.75 minutes
Average words per message: 5.28
Super-average MPM across all files: 16.16
mysticlight
average ccv: 268
Average unique users: 289.35
Average stream duration: 266.54 minutes
Average words per message: 6.54
Super-average MPM across all files: 11.30
nacho_dayo
average ccv: 2758
Average unique users: 532.38
Average stream duration: 305.75 minutes
Average words per message: 1.64
Super-average MPM across all files: 19.84
nekrolina
average ccv: 799
Average unique users: 465.24
Average stream duration: 209.89 minutes
Average words per message: 6.02
Super-average MPM across all files: 38.43
nihmune
average ccv: 3251
Average unique users: 1269.60
Average stream duration: 188.92 minutes
Average words per message: 2.39
Super-average MPM across all files: 173.38
NyanaBanyanaVT
average ccv: 172
Average unique users: 121.35
Average stream duration: 133.72 minutes
Average words per message: 4.06
Super-average MPM across all files: 10.56
nyanners
average ccv: 2317
Average unique users: 1316.60
Average stream duration: 308.93 minutes
Average words per message: 4.06
Super-average MPM across all files: 47.09
obkatiekat
average ccv: 1187
Average unique users: 657.14
Average stream duration: 462.59 minutes
Average words per message: 6.37
Super-average MPM across all files: 12.89
oliviamonroe
average ccv: 2900
Average unique users: 695.22
Average stream duration: 337.88 minutes
Average words per message: 5.19
Super-average MPM across all files: 34.14
onigiri
average ccv: 2211
Average unique users: 1017.83
Average stream duration: 310.01 minutes
Average words per message: 4.13
Super-average MPM across all files: 50.11
overezeggs
average ccv: 344
Average unique users: 287.85
Average stream duration: 390.69 minutes
Average words per message: 6.21
Super-average MPM across all files: 14.80
PorcelainMaid
average ccv: 845
Average unique users: 717.46
Average stream duration: 414.09 minutes
Average words per message: 4.63
Super-average MPM across all files: 29.18
rainhoe
average ccv: 1511
Average unique users: 462.03
Average stream duration: 289.02 minutes
Average words per message: 3.91
Super-average MPM across all files: 17.79
rosedoodle
average ccv: 579
Average unique users: 436.50
Average stream duration: 337.82 minutes
Average words per message: 5.94
Super-average MPM across all files: 21.75
rubee
average ccv: 751
Average unique users: 412.58
Average stream duration: 409.47 minutes
Average words per message: 4.10
Super-average MPM across all files: 20.56
saruei
average ccv: 2098
Average unique users: 1179.55
Average stream duration: 333.94 minutes
Average words per message: 4.75
Super-average MPM across all files: 40.42
shirahiko
average ccv: 488
Average unique users: 279.60
Average stream duration: 281.93 minutes
Average words per message: 3.65
Super-average MPM across all files: 22.53
shylily
average ccv: 3459
Average unique users: 1414.95
Average stream duration: 301.84 minutes
Average words per message: 4.93
Super-average MPM across all files: 41.34
silvervale
average ccv: 2920
Average unique users: 953.80
Average stream duration: 429.51 minutes
Average words per message: 5.61
Super-average MPM across all files: 23.01
sinder
average ccv: 3665
Average unique users: 1874.94
Average stream duration: 305.38 minutes
Average words per message: 5.23
Super-average MPM across all files: 66.97
sinuuki
average ccv: 372
Average unique users: 255.07
Average stream duration: 293.96 minutes
Average words per message: 5.48
Super-average MPM across all files: 13.46
snuffy
average ccv: 1892
Average unique users: 912.56
Average stream duration: 356.81 minutes
Average words per message: 4.17
Super-average MPM across all files: 27.42
squchan
average ccv: 1715
Average unique users: 1255.38
Average stream duration: 488.13 minutes
Average words per message: 4.27
Super-average MPM across all files: 41.72
tobs
average ccv: 789
Average unique users: 559.35
Average stream duration: 508.18 minutes
Average words per message: 5.75
Super-average MPM across all files: 31.15
vesper
average ccv: 375
Average unique users: 300.78
Average stream duration: 434.30 minutes
Average words per message: 5.20
Super-average MPM across all files: 11.17
vividlyvivi
average ccv: 371
Average unique users: 219.92
Average stream duration: 251.04 minutes
Average words per message: 6.58
Super-average MPM across all files: 12.12
yuzu
average ccv: 2017
Average unique users: 941.11
Average stream duration: 305.78 minutes
Average words per message: 3.53
Super-average MPM across all files: 56.10

ironmouse
average ccv: 9686
Average unique users: 4124.33
Average stream duration: 589.41 minutes
Average words per message: 3.84
Super-average MPM across all files: 84.85

Removed for subathon

megalodonvt
average ccv: 1740
Average unique users: 926.38
Average stream duration: 440.42 minutes
Average words per message: 4.20
Super-average MPM across all files: 42.19