Despite what has been an incredibly challenging year for so many, both personally and professionally, we are proud to have…
Continue Readingyear
Utilizing UN Session Data to Better Understand Global Trends
Utilizing UN Session Data to Better Understand Global TrendsSanjana RaoBlockedUnblockFollowFollowingMay 11IntroductionThe United Nations, formed in the aftermath of World War II,…
Continue ReadingVisualizing the 2017 wildfire season
Visualizing the 2017 wildfire seasonJared WhalenBlockedUnblockFollowFollowingApr 232017 was a devastating year for wildfires in the United States, especially in California that…
Continue ReadingPresto, Parquet & Airpal
EXPLAIN SELECT year, count(*) FROM track_metadata_csv GROUP BY year ORDER BY year; Query Plan ———————————————————————————————————————————————- – Output[year, _col1] => [year:bigint,…
Continue ReadingMost popular posts of 2018
Here are 10 of my most popular posts this year, arranged as pairs of posts in different areas.AstronomyPlanets evenly spaced…
Continue ReadingThe Review 1514764800 — 1546300800
The year was a wild ride full of many ups, downs, and lots of amazing people around me.It always amazes…
Continue ReadingSpotify ReWrapped
If we calculate the mean duration of songs listened to this year (4:05), there’s an error of 69 songs.Another hit…
Continue ReadingAre new movies longer than they were 10, 20, 50 year ago?
As stated before, we only need three columns:startYear — represents the release year of a titleruntimeMinutes — primary runtime of the title, in minutesnumVotes — number…
Continue ReadingAnalyzing Ratios
Note — as a rule:Numerators and denominator in any useful ratio must have meaningful logical connection, not just a history of correlation.If…
Continue ReadingAnimating regression models in R using broom and ggplot2
As with the animated Scottish rugby champions graph, this example doesn’t really benefit from adding the animation as another dimension…
Continue ReadingClean your data with unsupervised machine learning
From sample-checking some of the results we know there are issues ranging from bad links, unreadable PDFs to items which…
Continue Reading