Darlington EmeagiCracking the Code: A SQL ChallengeThere is a complex SQL challenge from a renowned YouTuber (Ankit Bansal) that focuses on solving different complexities of SQL interview…Aug 23Aug 23
Darlington EmeagiUnderstanding and Applying SQL Rank Window Functions for Data AnalysisThis mini-tutorial will focus on SQL rank window functions, such as ROW_NUMBER, RANK, DENSE_RANK, NTILE, CUME_DIST, and PERCENT_RANK. We…Jun 20Jun 20
Darlington EmeagiAggregation at Original Granularity in SQLSQL (Structured Query Language) is a widely used programming language for querying structured data in relational databases. Today…May 281May 281
Darlington EmeagiinPython in Plain EnglishCleaning Scorecard: Visualizing US Presidential RankingsThe essence of this article is to share some tips on how to clean data. Often, data in its raw form is messy. Most times is either the…Apr 5Apr 5
Darlington EmeagiinPython in Plain EnglishHistograms vs. Bar ChartsPeople often misunderstand the difference between histograms and bar charts. While both use vertical bars, there are key distinctions in…Mar 271Mar 271
Darlington EmeagiPractical Application of Confusion Matrix on Multiclass Classification SystemIn the previous article titled Confusion Matrix Simplified, I explained in simple terms how to calculate the four quadrants of a confusion…Apr 6, 2023Apr 6, 2023
Darlington EmeagiConfusion Matrix Concept SimplifiedOne of the ways of developing models in machine learning is by exposing both the train set and the labels to a neural network iteratively…Mar 29, 2023Mar 29, 2023
Darlington EmeagiRestoring Lost Commit on Git using Reflog CommandIn this article, I will share how you can restore a lost commit on Git using reflog command. Please note, this is only possible on changes…Apr 3, 2022Apr 3, 2022