@Ritaokonkwo

String Similarity Algorithms and Record Linkage

Dec 28, 2023 · 5 min read · I've been diving into data cleaning, and exploring the connection between clean textual data in DataFrames and the effective use of string-based algorithms for this task. There are many string similarity algorithms in existence today, such as Hamming...

Dimensional Modelling: Facts & Dimensions

Oct 30, 2023 · 3 min read · Lately, I've been diving deep into topics like Data Warehouses, Data Lakes, Data Modeling, Wide Tables, and the list goes on and on. I've been curious about the history of dimensional modeling and why it still finds relevance in certain contexts. Whi...

Streamline Your Jupyter Notebooks: Simplify and Organise with the %run Magic Command

Oct 8, 2023 · 2 min read · In a previous article, I wrote about using the timeit magic command to measure the time efficiency of different operations. In this article, I will write about the run magic command and explain how it has helped me to organise my notebooks. While w...

DataVerse Organisation: Where Lakes and Warehouses Team Up—Because Even Data Needs a Buddy System!

Sep 27, 2023 · 3 min read · 💡 To get the most out of this article, you should have a basic understanding of OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) systems. While conducting a data engineering task, I loaded data from a columnar database,...

Mastering Efficient Iteration Techniques for Pandas DataFrames

Sep 17, 2023 · 4 min read · 💡 To fully benefit from this article, it's important to have a basic understanding of Python, Numpy arrays, and Pandas DataFrames. Recently, I undertook a data manipulation task that involved using DataFrames for Data Engineering purposes. Whether...