Activate Now

Python question

I do not have access to the data set, it is built in to the zybooks website

Write a program that will do the following tasks:

Load the file internetusage.csv into a data frame called df$.$

Create a new data frame, internet, by subsetting the internet$\_$usage column.

Print the five number summary for the internet data frame.

The output should be:

internet$\_$usage

count $51\mathrm{.}000000$

mean $73\mathrm{.}747059$

std $6\mathrm{.}304422$

min $56\mathrm{.}600000$

$25\%69\mathrm{.}500000$

$50\%75\mathrm{.}000000$

$75\%77\mathrm{.}600000$

max $84\mathrm{.}700000$

Code given:

import pandas as pd

df $=$ pd$.$read$\_$csv$("$internetusage$.$csv$")$

internet $=$ # subset the column internet$\_$usage

five$\_$num $=$ # find the five number summary

print$($five$\_$num$)$

There are $4$ steps to solve this one.

Expert$-$verified

$1$st step

All steps

Answer only

Part $1$: Loading the CSV File

import pandas as pd

# Load the CSV file into a data frame called df

df $=$ pd$.$read$\_$csv$("$internetusage$.$csv$")$

In this part, we start by importing the pandas library as pd$.$ Pandas is a popular data manipulation and analysis library in Python. We then use the pd$.$read$\_$csv$()$ function to read the data from the "internetusage.csv$"$ file and store it in a DataFrame named df$.$ A DataFrame is a two$-$dimensional tabular data structure commonly used for data analysis in pandas.

Explanation:

Import the pandas library using import pandas as pd$.$

Use pd$.$read$\_$csv$()$ to read the data from the "internetusage.csv$"$ file.

Store the data in a pandas DataFrame called df$.$

The DataFrame df now contains the entire dataset from the CSV file.

This part ensures that the data is loaded and ready for further analysis.

Part $2$: Creating the 'internet' DataFrame

# Create a new data frame, internet, by subsetting the 'internet$\_$usage' column

internet $=$ df$[\text{'}$internet$\_$usage'$]$

Here, we create a new DataFrame named internet by extracting the 'internet$\_$usage' column from the original DataFrame df$.$ The square brackets df$[\text{'}$internet$\_$usage'$]$ are used to select a specific column by its name. So$,$ internet now contains only the data from the 'internet$\_$usage' column.

Explanation:

Extract a specific column from a DataFrame using square brackets $($e$.$g$.,$ df$[\text{'}$internet$\_$usage'$]).$

Create a new DataFrame named internet containing only the 'internet$\_$usage' column.

This step isolates the data of interest, simplifying subsequent analysis.

The internet DataFrame is now a one$-$column DataFrame containing internet usage data.

This is a crucial step for subsetting and analyzing specific data from the original dataset.

Part $3$: Calculating and Printing the Five$-$Number Summary

# Calculate the five$-$number summary for the internet data frame

five$\_$num $=$ internet.describe$()$

# Print the five$-$number summary

print$($five$\_$num$)$

In this final part, we use the describe$()$ method on the internet DataFrame. The describe$()$ method computes various summary statistics, including count, mean, standard deviation, minimum, $25$th percentile $(1$st quartile$),$ median $(2$nd quartile$),75$th percentile $(3$rd quartile$),$ and maximum. These statistics together make up the five$-$number summary.

Explanation:

Use the describe$()$ method on a DataFrame to calculate summary statistics.

The describe$()$ method provides statistics such as count, mean, min, max, and quartiles.

Store the summary statistics in a new DataFrame called five$\_$num.

The five$\_$num DataFrame now holds the five$-$number summary for the 'internet$\_$usage' data.

Finally, print the five$\_$num DataFrame to display the summary statistics to the user.

Part $4$: Complete code

You can achieve the tasks described by using the pandas library in Python. Here's the code to load the CSV file, subset the 'internet$\_$usage' column, and print the five$-$number summary:

import pandas as pd

# Load the CSV file into a data frame called df

df $=$ pd$.$read$\_$csv$("$internetusage$.$csv$")$

# Create a new data frame, internet, by subsetting the 'internet$\_$usage' column

internet $=$ df$[\text{'}$internet$\_$usage'$]$

# Calculate the five$-$number summary for the internet data frame

five$\_$num $=$ internet.describe$()$

# Print the five$-$number summary

print$($five$\_$num$)$