Python · SQL · Web Dev · Java · AI/ML tracks launching soon — your one platform for all of IT
Beginner

What is Data Science?

The definition that actually explains it, the DS lifecycle, and why Netflix, Spotify, Swiggy, and every subscription business on earth runs on this discipline

10–14 min July 2026

// Part 01

The Definition — And Why Every Other Explanation Fails

Search "what is data science" and you will find answers like "an interdisciplinary field that uses statistics, programming, and domain knowledge to extract insights from data." That sentence is technically true and completely useless — it tells you nothing about what a data scientist actually does on a Tuesday morning.

Here is the definition that actually explains it:

Data science is the practice of turning raw, messy records about the real world into decisions — by cleaning the data, understanding it statistically, and sometimes building a model that predicts what happens next.

Every word of that definition is doing work. Let us go through it.

"Raw, messy records" — real data is never clean. A streaming service's watch history has missing values, duplicate rows, typos in genre names, and timestamps in three different formats depending on which team's system logged them. Before any insight is possible, someone has to clean this. That someone is the data scientist, and it is usually 60–70% of the actual job.

"Understanding it statistically" — once the data is clean, you need to know whether a pattern is real or noise. If Premium subscribers watch 12% more content than Basic subscribers this month, is that a meaningful difference or something that would happen by chance 1 in 3 times anyway? Statistics is the discipline that answers this, and it is the difference between a confident business recommendation and an expensive mistake.

"Sometimes building a model that predicts what happens next" — not every data science project ends in a machine learning model. Many end in a dashboard, a report, or a single well-supported recommendation. But when prediction is the goal — will this subscriber cancel next month, will this customer click this recommendation — that is where regression, classification, and the rest of predictive modeling come in, covered later in this course.

Put together: data science is not one skill. It is cleaning (Modules 19–23), wrangling (Modules 24–29), statistics (Modules 39–44), visualization (Modules 35–38), and modeling (Modules 45–49) — all aimed at a single outcome: a decision someone can actually act on.

// Part 02

The Data Science Lifecycle — What Actually Happens Inside a Project

Every real data science project — whether it takes an afternoon or six months — moves through the same six stages. Skipping any of them is how projects produce numbers nobody trusts.

01Frame the question

"Reduce churn" is not a question. "Which subscriber segment cancels within 60 days, and why?" is. Most failed DS projects fail here, before a single line of code is written.

02Collect the data

Pull from a warehouse, an API, a CSV export, or a live event stream. Know where every column actually came from before you trust it.

03Clean and explore

Handle missing values, fix types, remove duplicates, then look at distributions and correlations before assuming anything about the data.

04Model or analyze

Sometimes this is a GROUP BY and a chart. Sometimes it is a trained classification model. The method should match the question, not the other way around.

05Validate

Would this hold up on next month's data? Is the sample size big enough? Statistics and a proper train/test split live here.

06Communicate and ship

A model nobody understands or trusts changes nothing. The final output is a decision, a dashboard, or a deployed prediction — not a notebook.

💡 Note
This course is structured around this exact lifecycle. Sections 2–4 (Python, NumPy, pandas) give you the tools. Section 5 is cleaning. Sections 6–8 are wrangling, EDA, and visualization. Section 9 is statistics and validation. Section 10 is modeling. Section 11 puts it all together in real case studies and interview prep — the "communicate and ship" stage.

// Part 03

Data Scientist vs Data Analyst vs ML Engineer vs Data Engineer

These four titles get confused constantly because the boundaries genuinely blur at most companies. Here is the honest breakdown — you will go deeper in Module 03.

RoleOwnsTypical output
Data EngineerBuilding the pipelines that move and store data reliablyA warehouse table that refreshes every night without breaking
Data AnalystAnswering business questions with existing, already-clean dataA dashboard or a SQL query answering "what happened?"
Data ScientistCleaning messy data, statistical analysis, and sometimes modelingA model, an experiment result, or a data-backed recommendation
ML EngineerTaking a working model and making it run reliably in productionAn API endpoint serving predictions at scale, 24/7

In practice, especially at smaller companies, one person often wears two or three of these hats. This course focuses on the data scientist column — cleaning, statistics, and the modeling fundamentals — while giving you enough pandas and SQL crossover to speak fluently with the other three roles.

// Part 04

Excel vs Python — The Honest, Complete Comparison

Excel and Google Sheets are genuinely good tools for small, static datasets and quick calculations. The problems start exactly where data science begins: messy data, statistical rigor, and repeatability.

The problemExcel / SheetsPython + pandas
ScaleStruggles well before 1 million rows. StreamPulse-sized companies generate that in watch events per day.pandas comfortably handles tens of millions of rows on a laptop; billions with Spark.
ReproducibilityA chain of manual clicks and formulas nobody can fully retrace six months later.A script. Run it again on new data and get the exact same result, every time.
Cleaning messy dataFind & Replace and manual scanning. Does not scale past a few hundred rows.One line handles a rule across the entire dataset: df["col"].fillna(0), df.dropna(), df.drop_duplicates().
StatisticsBasic functions (AVERAGE, STDEV). No real hypothesis testing, no proper distributions.scipy.stats gives you every distribution, test, and confidence interval used in real analysis.
AutomationA person must open the file and repeat the same steps every week.A script can be scheduled to run automatically — no human required after it is written.
Version controlFile_final_v3_ACTUAL.xlsx. No real history of what changed and why.Git tracks every change to the analysis code, line by line, with a reason attached.
Sharing the methodThe formulas are hidden inside cells — hard to audit, easy to break silently.Code is text. Anyone can read exactly what happened to the data, step by step.
🎯 Pro Tip
Excel is not the enemy. Analysts export a small, already-summarized result from pandas into Excel constantly for stakeholders who live in spreadsheets. The mistake is doing the cleaning and analysis itself by hand, in a spreadsheet, on a dataset too large or too messy for it to handle safely.

// Part 05

What Data Science Actually Looks Like at Real Companies

"Data science" sounds abstract until you see the specific decisions it drives. Every one of these is a real category of production data science work, running right now.

Netflix

Recommendation ranking

The "Because you watched…" row is a model predicting what you are most likely to finish, trained on billions of watch events like the ones in the watch_history table below.

Spotify

Discover Weekly

A recommendation model comparing your listening patterns against millions of other users with statistically similar taste profiles.

Swiggy / Zomato

Delivery time prediction

A regression model predicts exact delivery windows from historical order, traffic, and restaurant prep-time data — shown to you before you order.

Ola / Uber

Dynamic pricing

Surge pricing is a live model balancing rider demand against available driver supply in a specific zone, updated every few minutes.

Flipkart / Amazon

Demand forecasting

Statistical forecasting models decide how much inventory to stock at each warehouse before a sale event, based on historical demand curves.

Any subscription app

Churn prediction

A classification model flags subscribers likely to cancel next month — the exact analysis you will build yourself in Module 47 using StreamPulse.

🎯 Pro Tip
Notice the pattern: every example above is built on the same five ingredients — clean historical data, descriptive statistics, a model, validation, and a decision. That is the entire syllabus of this course, applied to one consistent dataset instead of jumping between unrelated toy examples.

// Part 06

The StreamPulse Dataset — Your Data for All 53 Modules

Every single module in this course — from Module 01 to Module 53 — uses the same dataset: StreamPulse. A fictional video streaming service with subscribers across 8 countries, a 20-title catalog spanning Movies and Series, and realistic engagement, billing, and churn behavior.

You will know these five tables so well by Module 53 that you could describe every column from memory. That depth of familiarity is intentional — every line of pandas you write will feel meaningful, not academic.

users25r · 10c

25 subscribers across 8 countries. Basic, Standard, Premium plans. Signup dates from 2021–2025.

titles20r · 9c

20 titles — Movies and Series across Drama, Sci-Fi, Comedy, Documentary and more. IMDb-style ratings and runtimes.

subscriptions25r · 8c

25 billing records. Active and cancelled subscriptions, monthly price by plan, and a cancel_reason for churned users.

watch_history100r · 7c

100 watch events — which user watched which title, on what device, for how many minutes, and whether they finished it.

ratings40r · 6c

40 star ratings (1–5) with optional review text — some reviews are missing, on purpose, for you to clean later.

The tables connect exactly like a real product's data: a user has subscriptions, a user watches titles (recorded in watch_history), and a user rates titles they have watched. One subscriber, three coordinated tables. You will join, group, and aggregate across all of them starting in Section 6.

// Part 07

The Live Python Playground — Run Real Code Right Now

Every module in this course has a live Python playground. The five StreamPulse tables are loaded as pandas DataFrames the moment the page opens — no install, no account, no cloud. It runs entirely in your browser using Pyodide, a full Python distribution compiled to WebAssembly.

Do not worry about understanding the syntax below yet. That starts properly in Section 2. For now, click Run and watch real StreamPulse data appear.

Loading Python engine…
Ctrl + Enter to run
Loading Python engine… (first run on a page takes a few seconds)

Try changing head() to head(10) and click Run again. That is your first pandas experiment — you just inspected a live DataFrame.

Loading Python engine…
Ctrl + Enter to run
Loading Python engine… (first run on a page takes a few seconds)

That query grouped 100 watch events by device and averaged the minutes watched for each — a question that would take several VLOOKUPs and a pivot table in a spreadsheet. You will write aggregations like this yourself by Section 6.

Loading Python engine…
Ctrl + Enter to run
Loading Python engine… (first run on a page takes a few seconds)

That is a real matplotlib figure, rendered by Python running in your browser tab, not a static image. Section 8 teaches you to build charts like this from scratch.

// Part 08

What This Looks Like at Work — A Full Day

You join a mid-size streaming startup as a Data Scientist, three months after completing this course. Here is what a real working day looks like.

9:00 AM
Standup — a question comes in
The retention team lead asks: "We think Premium subscribers who signed up through Paid Ads churn faster than everyone else. Can you check?" Before this course, this would mean waiting on a data analyst. Now, you say: "Give me until lunch."
9:15 — 10:30 AM
Pull, clean, and explore
You pull the subscriptions and users tables, join them on user_id, and immediately notice 4 rows with a missing cancel_reason even though status is "cancelled" — a data quality issue you flag to the data engineering team while working around it for now (Module 19 covers exactly this).
10:30 — 11:30 AM
Test the actual hypothesis
You group by referral_source and plan, calculate the cancellation rate for each combination, and run a quick statistical test (Module 42) to check whether the difference for Paid Ad + Premium is larger than you would expect from random noise alone. It is — but only barely significant, given the small sample size.
11:45 AM
Communicate the honest result
You do not report "Paid Ads causes churn" — correlation is not causation, and you say so. You report the actual pattern, the sample size caveat, and one concrete recommendation: run a controlled A/B test (Module 44) on the Paid Ad onboarding flow before spending budget assuming the effect is real.
2:00 PM
Back to the longer-term project
You return to the churn prediction model (Module 47) you have been building over the past two weeks — this morning's finding becomes one candidate feature to test in it.

🎯 Pro Tip

The single biggest differentiator between a junior and senior data scientist is not knowing more algorithms — it is knowing when NOT to trust a pattern, and saying so honestly instead of overselling a result. Statistics (Section 9) is what gives you that judgment.

// Part 09

Interview Prep — 5 Questions With Complete Answers

Q: What is data science, and how is it different from data analytics?

Data science is the practice of turning raw, often messy data into decisions through a combination of programming, statistics, and — when the question calls for it — predictive modeling. Data analytics typically focuses on answering "what happened?" using already-clean, structured data, usually through SQL queries, dashboards, and descriptive statistics.

The practical distinction is in scope. A data analyst usually works with data that is already collected, cleaned, and modeled in a warehouse — their job is answering business questions against it quickly. A data scientist frequently works further upstream: cleaning genuinely messy raw data, applying statistical rigor to validate whether a pattern is real, and building predictive models when the business question is "what will happen next" rather than "what happened."

In practice these roles blend heavily, especially at smaller companies. The clearest signal of a data science task versus an analytics task: if the deliverable is a trained model or a statistically validated experiment result, it is data science. If it is a report or dashboard on existing clean data, it is analytics.

Q: Walk me through the data science lifecycle for a real project.

Six stages. First, frame the question precisely — "reduce churn" is not answerable, but "which subscriber segment cancels within 60 days, and why" is. Second, collect the data from wherever it actually lives — a warehouse, an API, a stream of events. Third, clean and explore it: handle missing values, fix data types, remove duplicates, then look at distributions and correlations before assuming anything.

Fourth, analyze or model — sometimes this is a groupby and a chart, sometimes a trained classification model; the method should match the question's complexity, not the analyst's preference. Fifth, validate: would this hold up on next month's data, is the sample size large enough, does a statistical test support the conclusion. Sixth, communicate and ship — a model or insight nobody understands or acts on has changed nothing.

The most common project failure is skipping stage one — jumping straight to modeling before the actual business question is nailed down — or skipping stage five, presenting a pattern as fact without checking whether it is statistically meaningful.

Q: Why do data scientists spend so much time on data cleaning instead of modeling?

Because a model — or any statistical conclusion — is only as trustworthy as the data it is built on. Real-world data arrives with missing values (a delivery_date that never got filled in because an order is still in transit), duplicate records (the same event logged twice by a retrying system), inconsistent formats (dates as strings in three different layouts), and outliers that may be real edge cases or simple data entry errors.

If these issues are not addressed first, every downstream step inherits the error. A churn model trained on data where 15% of cancellation dates are wrong will confidently learn the wrong pattern — and the model's high accuracy on that broken data gives false confidence rather than a warning sign.

Industry estimates commonly put data cleaning and preparation at 60–80% of a data scientist's actual time. This is not an inefficiency to be optimized away — it is the actual foundation the rest of the discipline depends on, which is why this course dedicates an entire section (Section 5) and the wrangling section that follows it (Section 6) to exactly this.

Q: Give an example of a data science project that does not involve machine learning.

A cohort retention analysis. Suppose StreamPulse wants to know how subscriber retention differs between users who signed up in January versus March. This requires no machine learning model at all: it requires grouping subscribers by signup month (a cohort), calculating what percentage of each cohort is still active at 30, 60, and 90 days, and visualizing the resulting retention curves.

The output — a clear chart showing that the March cohort retains 15% better than January, likely correlated with a pricing change that took effect in February — is a fully legitimate, high-value data science deliverable built entirely from pandas, groupby aggregation, and a well-chosen chart. This exact analysis is covered as a full case study in Module 51.

Machine learning is one tool in the data science toolbox, appropriate when the goal is genuinely predictive — "will this specific user churn" rather than "how did this group behave historically." Reaching for a model when a groupby and a chart would answer the question just as well is a common junior mistake, not a sign of rigor.

Q: What tools does a real data science workflow use, end to end?

Python is the dominant language, with pandas for data manipulation, NumPy for numerical computation, matplotlib and seaborn for visualization, scipy for statistical tests, and scikit-learn for classical machine learning models — all covered progressively through this course. SQL remains essential for pulling data out of a warehouse before any of the Python tooling gets involved.

Beyond the core libraries, a typical workflow also touches Jupyter notebooks or an IDE for exploration, Git for version-controlling analysis code, and increasingly cloud notebook environments (Google Colab, Databricks, SageMaker) when the data or compute needs exceed a laptop. This course's live in-browser Python playground gives you the pandas, NumPy, matplotlib, and general Python experience directly — the same code you write here runs unchanged in a real Jupyter notebook or production script.

For deep learning specifically — image, text, and generative model work — PyTorch and TensorFlow dominate, but that is a distinct specialization covered in this platform's separate AI/ML track, not the classical, statistics-grounded data science covered here.

// Part 10

Errors You Will Hit — And Exactly Why They Happen

NameError: name 'user' is not defined

Cause: A typo in a variable name — 'user' was typed instead of 'users' (the DataFrame preloaded in this playground). Python is case- and spelling-exact: a variable must match exactly how it was created, with no fuzzy matching. This is the single most common error beginners hit in their first week of Python.

Fix: Check the exact name of the variable you are trying to use — in this playground, the five preloaded DataFrames are users, titles, subscriptions, watch_history, and ratings (all lowercase, exact spelling). Click 'Tables' in any playground to see the full list with their column names.

KeyError: 'First_Name'

Cause: You tried to access a column that does not exist under that exact name — here 'First_Name' was typed instead of 'first_name'. Unlike SQL, pandas column names are case-sensitive and must match exactly, including underscores versus spaces.

Fix: Run users.columns to see the exact column names available, or users.head() to see them as a table header. Copy the exact spelling and case from there — do not guess or assume a column is named the way you would expect.

TypeError: can only concatenate str (not "int") to str

Cause: You tried to combine a text value and a number directly, for example 'Age: ' + 25. Python will not silently convert the number to text the way a spreadsheet formula might — it requires you to be explicit about the conversion.

Fix: Wrap the number in str() to convert it first: 'Age: ' + str(25) — or better, use an f-string which handles the conversion automatically: f'Age: {25}'. F-strings (prefixing a string with f) are the standard, more readable way to combine text and values in modern Python.

AttributeError: 'DataFrame' object has no attribute 'shpae'

Cause: A typo in a method or attribute name — 'shpae' instead of 'shape'. Python raises an AttributeError (not a syntax error) because 'shpae' is a perfectly valid variable name as far as the parser is concerned — it simply does not exist as something you can call on a DataFrame.

Fix: Check the spelling carefully — the error message shows you exactly what was typed, so compare it letter by letter against what you meant. Common correct DataFrame attributes: .shape (no parentheses, it's a property), .columns, .dtypes, .head(), .describe(). A code editor with autocomplete catches most of these before you even run the code.

IndentationError: unexpected indent

Cause: Python uses indentation (whitespace at the start of a line) to define code blocks — there is no equivalent of curly braces {} like in JavaScript or Java. This error means a line has more or less leading whitespace than Python expects at that point, often from mixing tabs and spaces, or accidentally indenting a line that should be at the top level.

Fix: Make sure every line inside the same block (like inside an if statement or a for loop) uses exactly the same indentation — the convention is 4 spaces per level, never tabs. Most code editors can be configured to insert spaces when you press Tab, which prevents this error entirely.

Try It Yourself

Using the preloaded StreamPulse DataFrames, write one line of pandas that returns the average imdb_rating for each genre in the titles table, so you can see which genre StreamPulse's catalog rates highest.

🎯 Key Takeaways

  • Data science is turning raw, messy data into decisions: cleaning it, understanding it statistically, and sometimes building a model that predicts what happens next.
  • Every real project follows the same lifecycle: frame the question, collect data, clean and explore, model or analyze, validate, communicate and ship. Skipping any stage produces numbers nobody should trust.
  • Data Scientist, Data Analyst, ML Engineer, and Data Engineer are four distinct roles that blend heavily in practice — this course focuses on the cleaning, statistics, and modeling fundamentals at the core of the data scientist role.
  • Excel breaks down at the scale, reproducibility, and statistical rigor that real data science requires. Python and pandas solve all three without giving up the ability to export a clean summary back to a spreadsheet when needed.
  • Real companies run on this discipline daily: Netflix and Spotify recommendations, Swiggy and Ola dynamic predictions, Flipkart demand forecasting, and churn prediction at every subscription business — all built from the same ingredients taught in this course.
  • StreamPulse — 5 tables, 210 total rows, realistic subscriber and engagement data — is the dataset for all 53 modules. Learn it once and use it for every exercise in the course.
  • A live Python playground powered by Pyodide runs on every module page. Zero install, zero account, zero server — pandas, NumPy, and matplotlib are ready the moment the page opens, with real charts rendered live in your browser.
  • Not every project needs machine learning — a well-built cohort retention chart is just as legitimate a data science deliverable as a trained model, when it answers the actual question asked.
  • Data cleaning routinely takes 60–80% of real project time. This is not wasted effort — every downstream statistic and model depends entirely on it, which is why an entire section of this course is dedicated to it.
  • Data science is the highest-leverage skill you can pair with any existing technical background — product, engineering, analytics — because every subscription, marketplace, and consumer app now runs core decisions through it.

What comes next

Module 02 walks through the data science workflow in full depth — how a vague business question becomes a precise, answerable one, and exactly what happens at each of the six lifecycle stages on a real project. More modules are being added to this track regularly.

Module 02 → The Data Science Workflow
Share

Discussion

0

Have a better approach? Found something outdated? Share it — your knowledge helps everyone learning here.

Continue with GitHub
Loading...