Twenty Shades of Leetcode
Twenty different visualizations of the problems data in Leetcode and the insights to be taken from them
June 2023 — July 2023
Summary
The project I did as a part of database laboratory assistant selection. Twenty distinct insights from the data of Leetcode problems with graph included for each of them.
Developer Diaries
There is not much that is complicated from a technical standpoint in the making of this. I only had to learn and do a setup DatoCMS, and I also didn't put much time into implementing best practices since the focus of the assignment is not on the site's implementation but in the data visualization and insight (I used a website as a medium because I'm more familiar with it and believe it can gives me the best interactive visualization, but I could've used anything really).
The hardest part of this project is actually figuring out the insight worth exploring. Initially, I thought that with the complicated structure of the data, I would be able to eek out at least 50 insights. And I was able to, but many of those insights wouldn't be interesting so I cut it down to twenty. Though there's probably a lot of interesting insight that I didn't thought of because I didn't have enough time to explore. This is demonstrated by the fact that I didn't find any use for the SQL window function, even though it's an ubiquitous feature in data analysis.
Although I didn't get accepted as a lab assistant, this project had a lot of impact on me by introducing me to the joy of data analysis. It really was cool to see the various facts hidden in the data and the colorful interactive visualizations thereof.