Scribd
Upload
4 views21 pages

Pandas DataFrame and SQL Operations Guide

The document outlines various tasks related to data manipulation and analysis using Pandas and SQL. It includes creating Series and DataFrames, filtering data, handling missing values, and performing statistical analysis. Additionally, it covers importing/exporting data and performing operations on databases.

Uploaded by

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

Pandas DataFrame and SQL Operations Guide

The document outlines various tasks related to data manipulation and analysis using Pandas and SQL. It includes creating Series and DataFrames, filtering data, handling missing values, and performing statistical analysis. Additionally, it covers importing/exporting data and performing operations on databases.

Uploaded by

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

Questions :

[Link] a Pandas Series from a Dictionary of Values as ndarray.

Output:

[Link] a Series print all the elements that are above the 75th percentile.

Output:

[Link] a dataframe quarterly sales where each rows contain the item category, item
name, and expenditure. Group the row by Category.
Output:

[Link] a data frame based on ecommerce data and create descriptive statistics.
Output:

[Link] a data frame for examination results and display row labels, Column labels
datatype of each column and the dimension.

Output:
[Link] out rows based on different criteria such as duplicate rows.

Output:
[Link] the Sum of each column, or find the column with the lowest mean.

Output:

[Link] the 3 largest Values in a dataframe.

Output:
[Link] the mean of a row from each element of the row in the dataframe.

Output:

[Link] all negative values in a data frame with 0.


Output:

[Link] all missing values in a dataframe with 999.

Output:
[Link] and exporting data between pandas and csv file.

Output:
[Link] and exporting data between pandas and mysql databases. Given the
School result date, Analyse the performance of the students on differential
parameters e.g.- subjectwise.
Output:
[Link] the data frames created above, analyse and plot appropriate charts with tittle
and legends.
Output:
[Link] data is your interest from an open source, aggregate and summarise it. Then
plot it using different ploting functions the matplotlib.
Output:
[Link] a student table with the student Id, name and marks as attributes where
the student id is the primary Key.
17. Delete the details of a particular student in the above table insert the detail of a
new Student in the above table.

[Link] the Select Command to get the details. of the students with marks more than
80.

[Link] a new label by joining 2 tables (product and Customer).


[Link] a foreign key in one of the two tables mentioned above.

[Link] the min, max, Sum, and average of the marks in a Student marks table.

[Link] the total number of Customers from each country in the table using group by
create a new table (name, dob) by joining two tables.
[Link] a SOL query to order the table in descending order of the marks.

You might also like