CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21INDEXSr.Name of the Experiment/ActivityNo.Date ofData ofExperiment SubmissionDatabase query using SQL1.Mathematical, String, Date and time functions in 08/07/202015/07/2020SQL2.Aggregate functions ,Group by ,order by query in 15/07/202022/07/2020SQLData Structure in Pandas- Series3.Menu driven program to create a pandas series 22/07/202029/07/2020from a dictionary, ndarray and list.4.Menu driven program to print all the elements 29/07/202005/08/2020that are at, above & below 25th, 50th and 75thpercentile.5.Program to calculate maximum sales and total 05/08/202010/08/2020sales using Series.6.Write a program to perform various operations on 10/08/202017/08/2020Pandas Series.7.Program to perform selection, indexing and 17/08/202024/08/2020slicing operation on Series8.Program to create dataframe using 2D dictionary, 24/08/202028/08/20202D array , Series and another dataframe9.Program to add and delete of column and row in 28/08/202002/09/2020Dataframe.09/09/2020iteritems( ) and iterrows( ).Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel1Program to iterate over a Dataframe using 02/09/2020Page10.

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-2111.Programtoperformselectsubsetsfrom 09/09/202016/09/2020Program to perform Arithmetic binary operations 16/09/202021/09/2020Dataframe.12.on dataframe.13.Program to access and modify the values in 21/09/202028/09/2020Dataframe14.Program forcreatingSeriesobjectsfrom 28/09/202007/10/2020Write a program to create a Dataframe for student 07/10/202012/10/2020Dataframe columns and Dataframe rows.15.details and create a CSV file from it.16.Write a program to read a CSV file and display 12/10/202016/10/2020contents in different format. Copy the CSV fileinto other CSV file with different separator.17.Write a program to draw line chart depicting the 16/10/202019/10/2020prices of the apps and download of the apps.18Given the school result data, Plot bar graph using 19/10/202022/10/2020function of Dataframe for subject wise analysis ofperformance of the students.19Write a program to create a bar chart plotting 22/10/202029/10/2020from the columns of Dataframe.Write a program to create different histograms for 29/10/202002/11/2020the weight measurements for 16 small orders of2French fries (in grams).Page20Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Practical 1-Aim: Database query using SQL (Mathematical, string,Date and time functions in SQL)Consider table SALESMAN with following data:SNO SNAMESALARYBONUSA01Beena Mehta3000045.23A02K. L. Sahay5000025.34B03Nisha Thakkar3000035.00B04Leela Yadav80000NULLC05Gautam Gola20000NULLC06Trapti Garg7000012.37D07Neena -03-182018-12-311989-01-231987-06-151999-03-181) Display Salesman name , bonus after rounding off to zero decimal places.Select SNAME, round(BONUS,0) from SALESMAN;2) Display name, total salary of all salesman after addition of salary andbonus and truncate it to 1 decimal places.Page3Select sname, truncate((SALARY BONUS),1) from SALESMAN;Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-213) Display remainder of salary and bonus of Salesman whose SNO startingwith ‘A’Select MOD(SALARY,BONUS) from SALESMAN where SNO like ’A%’;4) Display position of occurrence of string “ta” in salesmen name.Select sname, instr(Sname,”ta”) from SALESMAN;5) Display four characters from salesman name starting from secondcharacter.Page4Select sname, substr(Sname,2,4) from SALESMAN;Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-216) Display last 5 characters of name of SALESMAN.Select sname, right(Sname,5) from SALESMAN;7) Display details of salesman whose name containing 10 characters.Select * from salesman where length(sname) 10;8) Display month name for the date of join of salesmanSelect DATEOFJOIN, monthname(DATEOFJOIN) from SALESMAN;Display currentdate and day of the year of current date.5Select date (now()),dayofyear(date(now())) from dual;Page9)Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-2110)Display name of the weekday for the DATEOFJOIN of SALESMAN;Select DATEOFJOIN,dayname(DATEOFJOIN) from SALESMAN;11) Display SNO, name of the youngest SALESMAN.Select sno, sname, dateofjoin from salesman where dateofjoin (selectmax(DATEOFJOIN) from SALESMAN);12)Display name and salary of the oldest SALESMAN.Select sname, salary, dateofjoin from salesman where dateofjoin (selectPage6min(dateofjoin) from salesman);Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Practical 2-Aim: Database query using SQL (Aggregate functions ,Groupby ,order by query in SQL)Consider the following table Vehicle:V 3JeepMahindra400000015S9090M0892SUVMini i250000018R2409Mini VanMahindra350000151. Display the average price of each type of vehicle having quantity more than20.Select Type, avg(price) from vehicle where qty 20 group by Type;2. Count the type of vehicles manufactured by each company.Page7Select Company, count(distinct Type) from Vehicle group by Company;Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-213. Display total price of all types of vehicle.Select Type, sum(Price* Qty) from Vehicle group by Type;4. Display the details of the vehichle having maximum price.Select * from vehicle where price (select max(price) from vehicle);5. Display total vehicles of Maruti company.Select company,sum(qty) from vehiclegroup by companyPage8having company 'Maruti';Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-216. Display average price of all type of vehicles.Select type,avg(price) from vehicle group by type;7. Display type and minimum price of each vehicle company.Select type,company,min(price) from vehicle group by company;8. Display minimum, maximum, total and average price of Mahindracompany vehicles.Select company, min(price),max(price),sum(price),avg(price) from vehicle wherePage9company 'Mahindra';Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-219. Display details of all vehicles in ascending order of their price.Select * from vehicle order by price asc;10.Display details of all vehicles in ascending order of type and descendingorder of vehicle number.Page10Select * from vehicle order by type asc,v no desc;Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Practical 3-Write a menu driven program to create a pandas seriesfrom a dictionary, ndarray and list.Page11Solution:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page12Output:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Practical 4-Write a menu driven program to print all the elementsthat are at, above & below 25th , 50th and 75th percentile.Page13Solution:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page14Output:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page15Practical 5:Write a program that stores the sales of 5 cars for each month in 12Series objects. The program should display:1) Item wise total yearly Sales2) Maximum Sales of item made in a year3) Maximum Sales for individual items4) Maximum Sales of item made in a months.Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page16Output:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page17Practical 6-Write a program to change index of existing series,perform vector, arithmetic operation on series and use of head (),tail (), drop () functionSolution:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page18Output:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

Page19CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page20Practical 7- Write a program to perform selection, indexing andslicing operation on Series.Solution:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page21Output:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

Page22CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page23Practical 8- A menu driven program to create a dataframe using 2Ddictionary, 2D array, Series and another dataframe.Solution:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page24Output:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Practical 9- Create a data frame for examination result and1. Display row labels, column labels, data typesof each columnand the dimensions.2. Add and delete of column and row in DataframePage25Solution:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page26Output:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page27Practical 10- Write a program to iterate over a DataFramecontaining names and marks, then calculates grades as per marks(as per guideline below) and adds them to the grade column.Marks 90 Grade A Marks 70 – 90 Grade AMarks 60 – 70 Grade BMarks 50 – 60 Grade CMarks 40 – 50 Grade DMarks 40 Grade FSolution:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page28Output:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page29Practical 11- Write a program to perform select subsetsfrom DataFrame using loc, iloc, head( ),tail( ) functions.Find maximum, minimum values and transpose ofdataframe.Solution:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page30Output:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

Page31CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page32Practical 12-Write a program perform Arithmetic binary operations(Addition, Subtraction, Multiplication, Division) on dataframe.Solution:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page33Output:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel

CLASS XII INFORMATICS PRACTICES PRACTICAL FILE FOR SESSION 2020-21Page34Practical 13-Write a program to access and modify thevalues in Dataframe.Solution:Prepared by: Mrs. Shruti Srivastava, PGT (CS), KV ONGC Panvel