Posts

Showing posts with the label Data ceaning

Master Jobs, Stages, and Tasks for Data Engineering Interviews

Image
Mastering Spark execution internals is a "must-have" skill for Data Engineers. Whether you are prepping for an interview or debugging a slow production pipeline, understanding how Spark breaks down your code is the key to performance tuning. Spark applications follow a strict hierarchy: Jobs > Stages > Tasks . Let’s break down exactly how this works. 1. High-Level Architecture Before we dive into the code, let’s look at the components that manage the execution: Driver: The brain. It converts your code into a Directed Acyclic Graph (DAG) and schedules tasks. DAG Scheduler: Splits the graph into Stages based on "shuffles." Task Scheduler: Sends the individual Tasks to the executors. Executors: The workers that actually run the tasks in parallel. 2. Real-World Code Walkthrough: The "Wide" Transformation Let’s analyze a common scenario: reading data, filtering, grouping, and saving. # 1. Read Data (Narrow) df = sp...

Data Cleaning in SQL

                                                                              1. Import Data: First, import the Excel data into a SQL database table using a tool like SQL Server Management Studio.  2. Identify Missing Values: Use SQL queries to identify any missing or null values in the dataset. This helps in understanding the extent of missing data and planning for imputation or removal. 3. Remove Duplicates: Utilize SQL's 'DISTINCT' keyword or 'GROUP BY' clause to identify and remove duplicate rows from the dataset. This ensures that each observation is unique. 4. Standardize Data Formats: Use SQL functions like UPPER, LOWER, TRIM, etc., to standardize text formats and remove leading or trailing spaces. This ensures consistency in the data. 5. C...