KEMBAR78
Assignment Pandas# | PDF
Scribd
Upload
4 views1 page

Assignment Pandas#

The document outlines an assignment focused on using Pandas for data analysis with an Online Shopping Dataset. It includes tasks such as loading data, displaying statistics, adding columns, filtering, sorting, visualizing data, and handling missing values. Each task is broken down into specific steps to guide the completion of the assignment.

Uploaded by

harithmsylhy3
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views1 page

Assignment Pandas#

The document outlines an assignment focused on using Pandas for data analysis with an Online Shopping Dataset. It includes tasks such as loading data, displaying statistics, adding columns, filtering, sorting, visualizing data, and handling missing values. Each task is broken down into specific steps to guide the completion of the assignment.

Uploaded by

harithmsylhy3
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Assignment Pandas (intro to programming):

➔ You will find Online Shopping Dataset on the drive use it to solve the
assignment.

Task 1:
1. Load a CSV file named "data.csv" into a Pandas DataFrame.
2. Display the first 5 rows of the DataFrame.
3. Display the column names and data types in the DataFrame.
4. Show the summary statistics (mean, median, min, max, etc.) for
numerical columns.

Task 2:
1. Add a new column 'Total' that contains the sum of two existing
numerical columns.
2. Filter the DataFrame to show rows where a specific column value
meets a certain condition (e.g., where Avg_Price > 120).
3. Sort the DataFrame based on a particular column in ascending order.

Task 3:
1. Calculate the average value of a specific column.
2. Find the most frequent value in a categorical column.
3. Group the data by a categorical column and calculate the mean for
each group.

Task 4:
1. Create a histogram to visualize the distribution of a numerical column.
2. Generate a bar chart to represent the frequency of categories in a
categorical column.

Task 5:
1. Perform data imputation to handle missing values in the DataFrame.

Artificial Intelligence

You might also like