Question: Create a program that reads data from a CSV file. You need to open the csv file in the dataset that you selected and see

Create a program that reads data from a CSV file. You need to open the csv file in
the dataset that you selected and see the attributes to read them into your
program. The program should perform various manipulations and analyses on the
data, such as calculating averages, finding maximum/minimum values, and
generating summary statistics.
Tasks To Do:
1. Read CSV File: Implement a function to read data from the CSV file in your
dataset into a data structure (for example, list or dictionaries).
2. Clean Data: Replace empty fields with either a 0 or the best possible value
(for example, average of all other values in the column), convert strings to
integers or floats, ignore irrelevant data, etc.
3. Calculate Averages: Compute the average values for specific columns in your
dataset (for example, average prices, average sales, etc.).
4. Find Maximum/Minimum: Identify the maximum and minimum values in
specific columns (for example, minimum year, maximum price, etc.).
5. Generate Statistics: Provide statistics for the dataset, such as the total
number of entries, sales per year, number of categories.
6. Filter Data: Allow customers to filter the data based on specific criteria (for
example, price range, minimum year, most viewed videos etc.).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!