sandvich.xyz/content/posts/twocans-posts.md

date	tags	title	draft
2023-11-04	misc	Two Cans & String Question Heatmap	true

Since March, I have collected thousands of questions on Two Cans & String. Most of these questions were activated questions, but some were randomly sampled by selecting every n post.

I used a Python script that uses the Two Cans & String API to archive questions and insert it into an SQLite DB.

The data was transformed into a CSV and imported into Google Sheets, which allowed me to create a heatmap by counting the frequency based on the day of the week.

Here was the heatmap of the questions posted on the website from 2nd of March to 2nd of April.

Now after 6 months, here is how the heatmap changed from 2nd of March to 2nd of September (also with a table of questions asked).