Hololive Superchat Exploration
Important Links
Data Gathering & Preparation
I scraped Hololyzer’s superchat data (https://hololyzer.net/youtube/). The dataset can be accessed from Google Drive at superchats/2024.csv.
I first substituted non-Latin channel names with their Latin counterparts. Then I parsed the superchats themselves, separating the currency and amount.
I encountered a problem when trying to convert the currency to USD; I found out that there are no easy ways to obtain exchange rates for a certain date. I have to either pay for an API service or manually download from sites like https://investing.com/. Here are some interesting services I found:
In the end, I gave up and just used the latest exchange rates.