In python: In this exercise, you will use a hypothetical dataset income.csv to analyze the relationship between education level and income. You will use conditional statements to categorize individuals into different income groups based on their education level.

Instructions:

$1.$Load the income.csv dataset into a pandas DataFrame. The dataset contains two columns: $$Education$$ and 'Income$.$

$2.$Create a new column in the DataFrame called $$Income Group$$ that categorizes individuals into 'Low$,$ 'Medium$,$ and $$High$$ income groups based on their education level.

Assume that individuals with education level $$High School$$ or lower are in the $$Low$$ income group.

Individuals with education level $$Bachelor$$s$$ are in the $$Medium$$ income group.

Individuals with education level $$Master$$s$$ or higher are in the $$High$$ income group.

$3.$Use conditional statements to assign each individual to the appropriate income group.

$4.$Print the first few rows of the updated DataFrame to verify the income group assignments.

Starter Code:

import pandas as pd

# Load the data

data $=$ pd$.$read$\_$csv$(\text{'}/$home$/$codio$/$workspace$/$csv$/$income$.$csv$\text{'})$

# Add your code below

Place the following code in order

# Sample data for demonstration

print$($data$.$head$())$

def categorize$\_$income$\_$group$($row$)$:

$\})$

'Education': $[\text{'}$High School', 'Bachelor$\backslash \text{'}$s$\text{'},$ 'Master$\backslash \text{'}$s$\text{'},\text{'}$PhD$\text{'},$ 'High School', 'Bachelor$\backslash \text{'}$s$\text{'}],$ 'Income': $[30000,50000,70000,90000,35000,55000]$

data$[\text{'}$Income Group'$]=$ data.apply$($categorize$\_$income$\_$group, axis$=1)$

# Categorize individuals into income groups based on their education level

print$("$Updated DataFrame with Income Group:"$)$

# Print the first few rows of the updated DataFrame

import pandas as pd

data $=$ pd$.$DataFrame$(\{$

if row$[\text{'}$Education$\text{'}]$ in $[\text{'}$High School', 'Some College'$]$:

return 'Low'

elif row$[\text{'}$Education$\text{'}]==$ 'Bachelor$\backslash \text{'}$s$\text{'}$:

return 'Medium'

else:

return 'High'