What is Data Scraping?
Data scraping is a technique where a computer program extracts data from human-readable output coming from another program. Normally, data transfer between programs is accomplished using data structur...
Number Non-Null Values in Order within the Group — From SQL to SPL #17
Problem description & analysis:
After sorting a table in the Oracle database according to the first and second columns, the third column has non-null values.
Task: Now we need to add a ca...
Working with Web3 Data: Challenges
Learning about and working with web3 data is challenging. This is true even if you already have experience working with data in other domains.I know this because I have been facing this problem for ye...
🚿 Data Cleaning in Python, 2025 Edition
Messy datasets? Missing values? Duplicates? Inconsistent categories?🧹 This guide shows you how to clean it all up using just pandas — and keep your analysis smooth and reliable.🔥 Learn how to:...
Stop Using CSVs in Big Data: Here's Why You Should Learn Apache Iceberg
Title: ETL vs ELT: Explained with Pizza Delivery Analogy 🍕
Meet the Two Delivery Styles
ETL = cook before delivering (Transform before Load)
ELT = deliver ingredients, cook at your place (Load t...
5 Beginner-Friendly Projects to Learn Data Engineering (Using Free Tools)
Title: 5 Beginner-Friendly Projects to Learn Data Engineering (Using Free Tools)
CSV to SQL Migration Pipeline with Python
Real-Time Twitter Hashtag Counter using Kafka & Spark
Data Lake Setup on ...
🚀Lakehouses Demystified: The Future of Data is Here!
🚀 Lakehouses Demystified: The Future of Data is Here!
From Data Lakes to Apache Iceberg & OLake — A Dev’s Guide to the Modern Data Stack
❓ Confused between Data Lakes, Warehouses...
What is Exploratory Data Analysis?
In statistics, exploratory data analysis (EDA) is an approach of analyzing data sets to summarize their main characteristics, often using statistical graphics and other data visualization methods. A s...
Git Branching and Merging: A Data Engineer's Guide to Efficient Code Management
Git Branching and Merging: A Step-By-Step Guide
As a data engineer, managing and collaborating on code for data pipelines, transformations, and infrastructure is crucial. Git branching and merging are...