In $[31]$:

$$

import pandas as pd

# Create a DataFrame with balance.txt

df $=$ pd$.$read$\_$csv$("$balance$.$txt$",$ sep $="\frac{\frac{?}{?}}{s}+)$

Compare the average income based on ethnicity

print$("$Average income by ethnicity:"$)$

average$\_$income$\_$by$\_$ethnicity $=$ df$.$groupby$("$Ethnicity$")["$Income$"].$mean$().$round$(2)$

print$($average$\_$income$\_$by$\_$ethnicity$)$

# On average, do married or single people have a higher balance?

# Calculate the average balance of married people

average$\_$balance$\_$married $=$ df$[$df$["$Married$"]==$ "Yes"$]["$Balance$"].$mean$().$ round$(2)$

print$("$

Average balance of married person:", average$\_$balance$\_$married$)$

# Calculate the average balance of single people

average$\_$balance$\_$single "Married"$]=="$No$"]["$Balance$"].$mean$().$round$(2)$

print$("$Average balance of single person:", average$\_$balance$\_$single$)$

# Check if balance of married person $>$ balance of unmarried person

if average$\_$balance$\_$married $>$ average$\_$balance$\_$single:

print$(\text{'}$

Married people have a higher balance than single people.$\text{'})$

elif average$\_$balance$\_$single $>$ average$\_$balance$\_$married:

print$(\text{'}$

single people have a higher balance than married people.$\text{'})$

else: print$(\text{'}$

Balances are equal for married and single people.$\text{'})$

# What is the highest income in our dataset?

highest$\_$income "Income"$]*max().$round$(2)$

print$("$

Highest income:", highest$\_$income$)$

# What is the lowest income in our dataset?

lowest$\_$income "Income"$].$min$().$round$(2)$

print$("$Lowest income:", lowest$\_$income$)$

# How many cards do we have recorded in our dataset?

total$\_$cards "Cards" $\{$:${?}^{?}].$sum$()$

print$("$

Total number of cards:", total$\_$cards$)$

How many females and males do we have information for?

gender$\_$counts "Gender"$].$value$\_$counts $()$

print$("$

Number of females and males:"$)$

print$($gender$\_$counts$)$

Average income by ethnicity:

Ethnicity

African American $47\mathrm{.}68$

Asian $44\mathrm{.}19$

Caucasian $44\mathrm{.}52$

Name: Income, dtype: float$64$

Average balance of married person: $13\mathrm{.}39$

Average balance of single person: $13\mathrm{.}49$

single people have a higher balance than married people.

AttributeError

Traceback $($most recent call last$)$

Cell In$[31],$ line $29$

$26$ else: print$(\text{'}$

Balances are equal for married and single people.$\text{'})$

$28$ # What is the highest income in our dataset?

$--->29$ highest$\_$income "Income"$].$ max$()*$ round$(2)$

$30$ print$("$

Highest income:", highest$\_$income$)$

$32$ # What is the lowest income in our dataset?

AttributeError: 'float' object has no attribute 'round'