Python practice: Exploratory Data Analysis (EDA) Workflow

Chapter 31 · 8 questions · included in full access

  1. Question 1 · easy

    The 5-step EDA framework

    In professional data science, what are the five foundational steps of the Exploratory Data Analysis (EDA) workflow?

    Solve it in your browser
  2. Question 2 · easy

    Step 1: Inspect dimensions and structure

    Load "orders_messy.csv". Inspect the table shape and print the number of rows (df.shape[0]):

    Solve it in your browser
  3. Question 3 · medium

    Step 2: Missing value frequency audit

    Load "orders_messy.csv". Count missing values per column with df.isnull().sum(). Print the count of missing values in the "Units" column (int(nulls["Units"])):

    Solve it in your browser
  4. Question 4 · medium

    Outlier detection with Interquartile Range (IQR)

    Load "sales.csv". Compute Q1 (sales["Revenue"].quantile(0.25)), Q3 (sales["Revenue"].quantile(0.75)), and IQR = Q3 - Q1. Filter outliers where (sales["Revenue"] < Q1 - 1.5 * IQR) | (sales["Revenue"] > Q3 + 1.5 * IQR). Print outlier count (len(outliers)):

    Solve it in your browser
  5. Question 5 · medium

    Numerical distribution skewness audit

    Load "sales.csv". Calculate the skewness of the "Revenue" column using sales["Revenue"].skew(). Print the skewness rounded to 2 decimal places (round(sales["Revenue"].skew(), 2)):

    Solve it in your browser
  6. Question 6 · easy

    Categorical frequency distribution share

    Load "sales.csv". Calculate the percentage share of orders from each region using sales["Region"].value_counts(normalize=True) * 100. Print the North region percentage rounded to 1 decimal place (round(shares["North"], 1)):

    Solve it in your browser
  7. Question 7 · medium

    Segmented KPI statistical benchmark

    Load "sales.csv". Compute the median Revenue by Region using sales.groupby("Region")["Revenue"].median(). Print the median revenue for "South" as an integer:

    Solve it in your browser
  8. Question 8 · hard

    Synthesize executive data scorecard

    Load "sales.csv". Construct a summary dictionary scorecard = {"total_rev": int(sales["Revenue"].sum()), "total_orders": len(sales), "avg_units": round(sales["Units"].mean(), 1)}. Print scorecard["total_rev"]:

    Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

See pricing