Scribd
Upload
8 views1 page

Data Handling and Visualization with Pandas

The document outlines a project work index focused on data handling, visualization, and data management using pandas and SQL. It includes tasks such as creating pandas series and DataFrames, filtering data, visualizing results with charts, and managing student data in SQL. Each section provides specific activities to enhance skills in data analysis and database management.

Uploaded by

mbb91424
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
8 views1 page

Data Handling and Visualization with Pandas

The document outlines a project work index focused on data handling, visualization, and data management using pandas and SQL. It includes tasks such as creating pandas series and DataFrames, filtering data, visualizing results with charts, and managing student data in SQL. Each section provides specific activities to enhance skills in data analysis and database management.

Uploaded by

mbb91424
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

PROJECT WORK – INDEX

5.1 Data Handling


5.1.1 Create a pandas series from a dictionary of values and an ndarray.

5.1.2 Given a Series, print all the elements that are above the 75th percentile.

5.1.3 Create a DataFrame for quarterly sales where each row contains the item category, item name, and
expenditure. Group the rows by the category and print the total expenditure per category.

5.1.4 Create a DataFrame for examination result and display row labels, column labels, data types of each
column, and the dimensions.

5.1.5 Filter out rows based on different criteria such as duplicate rows.

5.1.6 Importing and exporting data between pandas and CSV files.

5.2 Visualization
5.2.1 Given the school result data, analyze the performance of the students on different parameters such
as subject-wise or class-wise.

5.2.2 For the DataFrames created above, analyze and plot appropriate charts with title and legend.

5.2.3 Take data from an open source (e.g., [Link]), aggregate and summarize it, then plot using
different plotting functions of Matplotlib.

5.3 Data Management (SQL)


5.3.1 Create a student table with student id, name, and marks as attributes where the student id is the
primary key.

5.3.2 Insert the details of a new student in the above table.

5.3.3 Delete the details of a student in the above table.


5.3.4 Use the SELECT command to get the details of students with marks more than 80.

5.3.5 Find the minimum, maximum, sum, and average of the marks in a student marks table.

5.3.6 Find the total number of customers from each country in the table (customer ID, customer name,
country) using GROUP BY.

5.3.7 Write an SQL query to order the (student ID, marks) table in descending order of marks.

You might also like