Data Science Foundations

Ab Python se apni pehli line of code likho.

Write and run a basic Python script

Use variables and identify Python data types — number, string, list

Apply arithmetic and comparison operators

Take user input and print formatted output

Explain and fix a simple Python error

Code ko sochna sikhao — decisions aur repetition ke saath.

Use if-else statements to make decisions in code

Use for and while loops to repeat an action

Write a simple function with parameters and a return value

Use lists and loops together to process multiple values

Debug a small script using print statements

Ab real data ke liye Python ki special libraries use karo.

Explain what NumPy and Pandas are used for

Create and inspect a NumPy array

Load a CSV file into a Pandas DataFrame

View, select and slice rows and columns in a DataFrame

Calculate basic statistics (mean, max, min) on a column

Real data gandi hoti hai — usse saaf karna seekho.

Identify missing, duplicate and inconsistent data in a dataset

Remove or fill missing values in a Pandas DataFrame

Remove duplicate rows from a dataset

Rename and reorder columns for clarity

Convert a column's data type correctly

Ab bade dataset se sirf kaam ki cheez nikalna seekho.

Filter rows in a DataFrame based on a condition

Sort data by one or more columns

Merge two DataFrames on a common column

Group data and calculate aggregated values (sum, count, average)

Explain when to filter versus when to group data

Excel me bhi ye sab kaam fast ho sakta hai — dekho kaise.

Build a Pivot Table to summarise a sample dataset in Excel

Use Excel formulas to identify and handle missing data

Use VLOOKUP/XLOOKUP to combine data from two sheets

Create a simple dashboard-style summary using Pivot Tables

Compare the Excel and Pandas approach for the same task

Data companies me database me store hota hai — usse nikalna seekho.

Explain what a database and a table are

Write a SELECT query to retrieve specific columns

Use WHERE to filter rows based on a condition

Use ORDER BY and LIMIT to sort and restrict results

Explain primary keys and why they matter

Ab do tables ko jod kar bada insight nikalo.

Explain the concept of a JOIN between two tables

Write an INNER JOIN query combining two sample tables

Use GROUP BY with COUNT, SUM and AVG functions

Use HAVING to filter grouped results

Write a multi-step query to answer a real business question

Ab data ko story ki tarah dikhana seekho aur sab kuch jod do.

Explain how to choose the right chart type for a dataset

Create bar, line and pie charts using Excel or Python (Matplotlib)

Combine Python, Pandas and SQL skills on one guided dataset

Build 2-3 visual summaries answering a business question

Present the mini project findings in a short summary