Scribd
Upload
39 views22 pages

Pandas

The document outlines practical exercises for Class XII Informatics Practices, focusing on data manipulation using Pandas and SQL. It includes tasks such as creating series and data frames, filtering data, performing statistical analysis, and importing/exporting data between formats. Additionally, it covers database operations like creating tables, inserting, deleting records, and executing SQL queries.

Uploaded by

Shiva Saiketh Kanukanti
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
39 views22 pages

Pandas

The document outlines practical exercises for Class XII Informatics Practices, focusing on data manipulation using Pandas and SQL. It includes tasks such as creating series and data frames, filtering data, performing statistical analysis, and importing/exporting data between formats. Additionally, it covers database operations like creating tables, inserting, deleting records, and executing SQL queries.

Uploaded by

Shiva Saiketh Kanukanti
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
You are on page 1/ 22

Practical File- Informatics Practices (Class XII)

#1Createapandasseriesfromadictionaryofvaluesandanndarray.

1|Page
#2.GivenaSeries,printalltheelementsthatareabovethe75thpercentile.

2|Page
#3C r e a t e a D a t a F r a m e q u a r t e r l y s a l e s w h e r e e a c h r o w c o n t a i n s t h e i t e m
c a t e g o r y , i t e m n a m e , a n d expenditure. Group the rows by the category, and

3|Page
#4.C r e a t e a d a t a f r a m e b a s e d o n e c o m m e r c e d a t a a n d g e n e r a t e d e s c r i p t i v e
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
#6.Filteroutrowsbasedondifferentcriteriasuchasduplicaterows.

6|Page
#7.Findthesumofeachcolumn,orfindthecolumnwiththelowestmean.

7|Page
#8.Locatethe3largestvaluesinadataframe.

8|Page
#9.SubtractthemeanofarowfromeachelementoftherowinaDataFrame.

9|Page
#10.Replaceallnegativevaluesinadataframewitha0.

10|Page
#11.Replaceallmissingvaluesinadataframewitha999.

11|Page
#12.ImportingandexportingdatabetweenpandasandCSVfile

12|Page
#13.ImportingandexportingdatabetweenpandasandMySQLdatabase.

Importing Data from MySQL to Data Frame.

13|Page
Exporting data from Data Frame 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
#15.FortheDataframescreatedabove,analyzeandplotappropriatecharts with title and legend.

16|Page
#16.Takedataofyourinterestfromanopensource(e.g.data.gov.in),aggregate
andsummarizeit.Thenplotitusingdifferentplottingfunctions oftheMatplotlib

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.

#18.Insertthedetailsofanewstudentintheabovetable.

#19.Deletethedetailsofaparticularstudentintheabovetable.

19|Page
#20.Usetheselectcommandtogetthedetailsofthestudentswithmarks 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
#22.Createaforeignkeyinoneofthetwotablesmentionedabove

#23.Findthemin,max,sum,andaverageofthemarksinastudentmarkstable.

#24.F i n d t h e t o t a l n u m b e r o f c u s t o m e r s f r o m e a c h c o u n t r y i n t h e
table (customer ID, customer Name, country) using group
by.

21|Page
#25.Createanewtable(name,dateofbirth)byjoiningtwotables(studentid, name) and (student id, date of
birth).

#26.WriteaSQLquerytoorderthe(studentID,marks)tableindescendingorder of the marks.

22|Page

You might also like