Why engineered features improve analysis in Data Analysis Python - Performance Analysis

Time Complexity: Why engineered features improve analysis

O(n)

Understanding Time Complexity

We want to see how adding engineered features affects the time it takes to analyze data.

How does the work grow when we add more features to our data?

Scenario Under Consideration

Analyze the time complexity of the following code snippet.

import pandas as pd

def add_features(df):
    df['feature_sum'] = df['A'] + df['B']
    df['feature_ratio'] = df['A'] / (df['B'] + 1)
    return df

# Example usage:
# df = pd.DataFrame({'A': range(n), 'B': range(n)})
# df = add_features(df)

This code adds two new features by combining existing columns in the data.

Identify Repeating Operations

• Primary operation: Adding and dividing values for each row in the data.
• How many times: Once for every row in the dataset.

How Execution Grows With Input

As the number of rows grows, the work grows in a similar way.

Input Size (n)	Approx. Operations
10	About 20 operations (2 per row)
100	About 200 operations
1000	About 2000 operations

Pattern observation: The work grows directly with the number of rows, doubling rows doubles work.

Final Time Complexity

Time Complexity: O(n)

This means the time to add features grows in a straight line with the number of rows.

Common Mistake

[X] Wrong: "Adding more features always makes analysis much slower in a complex way."

[OK] Correct: Adding simple features usually means doing a fixed number of operations per row, so time grows steadily, not wildly.

Interview Connect

Understanding how feature creation affects time helps you explain your data preparation steps clearly and confidently.

Self-Check

"What if we added features that compare every row to every other row? How would the time complexity change?"

Practice

1. Why do engineered features often improve data analysis results?

easy

A. They highlight important patterns not obvious in raw data

B. They reduce the size of the dataset by removing rows

C. They always increase the number of features without filtering

D. They replace the need for any data cleaning

Solution

1. Step 1: Understand the role of engineered features

   Engineered features transform raw data into forms that better reveal patterns.

2. Step 2: Compare with other options

   Options B, C, and D describe unrelated or incorrect effects of engineered features.

3. Final Answer:

   They highlight important patterns not obvious in raw data -> Option A

4. Quick Check:

   Engineered features = highlight patterns [OK]

Hint: Engineered features reveal hidden patterns in data [OK]

Common Mistakes:

• Thinking engineered features reduce dataset size
• Assuming engineered features always add more features
• Believing engineered features replace data cleaning

2. Which of the following is the correct way to create a new feature age_group from age in pandas using a condition?

easy

A. df['age_group'] = df['age'].filter(lambda x: 'adult' if x >= 18 else 'child')

B. df['age_group'] = df['age'].map('adult' if df['age'] >= 18 else 'child')

C. df['age_group'] = df['age'].apply(lambda x: 'adult' if x >= 18 else 'child')

D. df['age_group'] = df['age'].groupby(lambda x: 'adult' if x >= 18 else 'child')

Solution

1. Step 1: Identify correct pandas method for conditional feature creation

   The apply method with a lambda function correctly applies a condition to each value.

2. Step 2: Check other options for errors

   map expects a mapping dict or function, filter is for filtering rows, groupby is for grouping data, so they are incorrect here.

3. Final Answer:

   df['age_group'] = df['age'].apply(lambda x: 'adult' if x >= 18 else 'child') -> Option C

4. Quick Check:

   Use apply with lambda for conditional feature [OK]

Hint: Use apply with lambda for conditional new features [OK]

Common Mistakes:

• Using map with a conditional expression incorrectly
• Confusing filter with apply for feature creation
• Using groupby instead of apply for new column

3. Given the code below, what will be the output of print(df)?

import pandas as pd
df = pd.DataFrame({'height_cm': [170, 160, 180], 'weight_kg': [70, 60, 80]})
df['bmi'] = df['weight_kg'] / (df['height_cm'] / 100) ** 2
print(df)

medium

A. SyntaxError due to incorrect operator precedence

B. {'height_cm': [170, 160, 180], 'weight_kg': [70, 60, 80], 'bmi': [24.22, 23.44, 24.69]}

C. DataFrame with bmi column calculated as weight_kg multiplied by height_cm

D. DataFrame with bmi column calculated as weight_kg divided by height_cm squared in meters

Solution

1. Step 1: Understand the BMI calculation in code

   BMI is weight in kg divided by height in meters squared. The code correctly converts height_cm to meters and squares it.

2. Step 2: Check output format

   The print shows a DataFrame with a new 'bmi' column calculated as described, not a dictionary or error.

3. Final Answer:

   DataFrame with bmi column calculated as weight_kg divided by height_cm squared in meters -> Option D

4. Quick Check:

   BMI = weight / (height/100)^2 [OK]

Hint: Check formula carefully for correct calculation [OK]

Common Mistakes:

• Confusing multiplication with division in BMI formula
• Expecting dictionary output instead of DataFrame
• Thinking code causes syntax error

4. The following code tries to create a new feature income_level but raises an error. What is the error and how to fix it?

df['income_level'] = df['income'].apply(lambda x: 'high' if x > 50000 else 'low' if x <= 50000)

medium

A. No error; code runs fine

B. SyntaxError due to missing else clause; fix by adding final else

C. KeyError because 'income' column does not exist

D. TypeError because apply cannot use lambda functions

Solution

1. Step 1: Identify the lambda function structure

   The lambda uses nested if-else but misses a final else clause, causing SyntaxError.

2. Step 2: Fix the lambda expression

   Add a final else clause to cover all cases, e.g., lambda x: 'high' if x > 50000 else 'low'.

3. Final Answer:

   SyntaxError due to missing else clause; fix by adding final else -> Option B

4. Quick Check:

   Lambda if-else must cover all cases [OK]

Hint: Ensure lambda if-else has final else clause [OK]

Common Mistakes:

• Assuming apply cannot use lambda
• Ignoring missing else causing syntax error
• Thinking income column is missing without checking

5. You have a dataset with columns temperature_c and humidity. You want to create a new feature heat_index that combines both to better predict discomfort. Which approach best explains why engineered features like heat_index improve analysis?

hard

A. Combining temperature and humidity into heat_index captures interaction effects raw features miss

B. Using only temperature or humidity separately is always better for simplicity

C. Heat_index replaces raw data so original features are no longer needed

D. Engineered features like heat_index reduce dataset size by removing columns

Solution

1. Step 1: Understand interaction effects in features

   Heat index combines temperature and humidity to capture how they jointly affect discomfort, which single features miss.

2. Step 2: Evaluate other options

   Options A, C, and D misunderstand feature engineering benefits or effects on data.

3. Final Answer:

   Combining temperature and humidity into heat_index captures interaction effects raw features miss -> Option A

4. Quick Check:

   Engineered features = capture interactions [OK]

Hint: Engineered features capture combined effects of raw data [OK]

Common Mistakes:

• Thinking single features are always better
• Believing engineered features replace raw data completely
• Assuming engineered features reduce dataset size