Practical File-Informatics Practices(ClassXII)
#1Create a pandas series from a dictionary of values and an ndarray.
1|Page
#[Link] a Series, print all the elements that are above the 75 th
percentile.
2|Page
#[Link] a DataFrame quarterly sales where each row contains the item category, item name and
expenditure. Group the rows by the category.
3|Page
#4. Create a DataFrame based one commerce data and generate descriptive statistics (mean median,
mode, quartile, and variance).
4|Page
#5. Create a data frame for examination result and display row labels, column labels data types of each
column and the dimensions
5|Page
#[Link] out rows based on different criteria such as duplicate rows.
6|Page
#[Link] the sum of each column, or find the column with the lowest mean.
7|Page
#[Link] the 3 largest values in a data frame.
8|Page
#9. Subtract the mean of a row from each element of the row in a DataFrame.
9|Page
#[Link] all negative values in a DataFrame with a 0.
10|Page
#[Link] all missing values in a DataFrame with a 999.
11|Page
#[Link] and exporting data between pandas and CSV file.
12|Page
#[Link] and exporting data between pandas and MySQL database.
Importing Data from MySQL to DataFrame.
13|Page
Exporting data from DataFrame to MYSQL.
14|Page
#14. Given the school result data, analyse the performance of the students on different parameters,
e.g subject wise or class wise.
15|Page
#[Link] the DataFrames created above, analyze and plot appropriate charts with title and legend.
16|Page
#[Link] data of your interest from an open source ([Link]) aggregate and summarize it.
Then plot it using different plotting functions of the Matplotlib.
17|Page
18|Page
#17. Create a student table with the student id, name, and marks as attributes where the student id is
the primary key.
#[Link].
#[Link] the details of a particular student in the above table.
19|Page
#[Link] the select command to get the details of the students with marks more than 80.
#21. Create a new table (order ID, customer Name, and order Date) by joining
twotables(orderID,customerID,andorderDate)and(customerID,customer
20|Page
#[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 (customer ID, customer Name,
country) using group by.
21|Page
#[Link] a new table (name, date of birth) by joining two tables (student id, name) and (student id,
date of birth).
#[Link] a SQL query to order the (student_id, marks) table in descending order of the marks.
22|Page