Page 1 : www.python4csip.com, , Practical File- Informatics Practices (Class XII), #1 Create a pandas series from a dictionary of values and an ndarray., , 1|Page

Page 2 : www.python4csip.com, , #2. Given a Series, print all the elements that are above the 75th percentile., , 2|Page

Page 3 : www.python4csip.com, , #3 Create a Data Frame 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., , 3|Page

Page 4 : www.python4csip.com, , #4. Create a data frame based on ecommerce data and generate descriptive, statistics (mean, median, mode, quartile, and variance)., , 4|Page

Page 5 : www.python4csip.com, , #5. Create a data frame for examination result and display row labels, column, labels data types of each column and the dimensions, , 5|Page

Page 6 : www.python4csip.com, , #6. Filter out rows based on different criteria such as duplicate rows., , 6|Page

Page 7 : www.python4csip.com, , #7. Find the sum of each column, or find the column with the lowest mean., , 7|Page

Page 8 : www.python4csip.com, , #8. Locate the 3 largest values in a data frame., , 8|Page

Page 9 : www.python4csip.com, , #9. Subtract the mean of a row from each element of the row in a Data Frame., , 9|Page

Page 10 : www.python4csip.com, , #10. Replace all negative values in a data frame with a 0., , 10 | P a g e

Page 11 : www.python4csip.com, , #11. Replace all missing values in a data frame with a 999., , 11 | P a g e

Page 12 : www.python4csip.com, , #12. Importing and exporting data between pandas and CSV file, , 12 | P a g e

Page 13 : www.python4csip.com, , #13. Importing and exporting data between pandas and MySQL database., , Importing Data from MySQL to Data Frame., , 13 | P a g e

Page 14 : www.python4csip.com, , Exporting data from Data Frame to MYSQL., , 14 | P a g e

Page 15 : www.python4csip.com, , #14. Given the school result data, analyse the performance of the students on, different parameters, e.g subject wise or class wise., , 15 | P a g e

Page 16 : www.python4csip.com, , #15. For the Data frames created above, analyze and plot appropriate charts, with title and legend., , 16 | P a g e

Page 17 : www.python4csip.com, , #16. Take data of your interest from an open source (e.g. data.gov.in), aggregate, and summarize it. Then plot it using different plotting functions of the Matplotlib, library., , 17 | P a g e

Page 19 : www.python4csip.com, , #17. Create a student table with the student id, name, and marks as attributes, where the student id is the primary key., , #18. Insert the details of a new student in the above table., , #19. Delete the details of a particular student in the above table., , 19 | P a g e

Page 20 : www.python4csip.com, , #20. Use 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, two tables (order ID, customer ID, and order Date) and (customer ID, customer, Name, contact Name, country)., , 20 | P a g e

Page 21 : www.python4csip.com, , #22. Create a foreign key in one of the two tables mentioned above, , #23. Find the min, max, sum, and average of the marks in a student marks table., , #24. Find the total number of customers from each country in the table, (customer ID, customer Name, country) using group by., , 21 | P a g e

Page 22 : www.python4csip.com, , #25. Create a new table (name, date of birth) by joining two tables (student id,, name) and (student id, date of birth)., , #26. Write a SQL query to order the (student ID, marks) table in descending order, of the marks., , 22 | P a g e