INFORMATICSPRACTICES(065)

PRACTICALPROGRAMS

GRADE–XII
[2025-2026]

Preparedby:

Mr.Aashif Khan
1
PGT:IP/CS
 TABLEOFCONTENTS
S.No Name of the Exercises Page.No
Programs using Pandas
SERIES
1. Creating a Python program to create a series using a dictionary. 3
2. Creating a Python program to create a series using scalar value. 4
3. Creating a Python program to create a series using numpy array. 5
4. Creating a python program for modifying or updating existing values of series 6
object.
5. Creating a Python program for performing mathematical operations on two 7
Series objects.
6. Creating a Python program for calculating per capita income of four zones 8
Using Series.
7. Creating a Python program to display attribute sofa Series. 9
8. Creating a Python program using head() and tail() in Series. 10
DATAFRAME
9. Creating a Python program for creating a Data Frame using a nested list. 11
10. Creating a Python program for creating a Data Frame using a dictionary of 12
lists.
11. Creating a Python program for accessing values of rows and column sofa 14
Data Frame.
12. Creating a python program to perform operations on a DataFrame(rename, 16
Count ,update ,replace)
13. Creating a Python program to filter the data of a Data Frame. 18
14. Creating a Python program to display the attributes of the DataFrame. 19
15. Creating a Python program to display the data of a DataFrame row-wise and 20
column-wise using iterrows() and iteritems()
16. Creating a Python program to perform writing and reading operations in a 22
CSV file.
ProgramsusingMatplotlib–DataVisualization
17. Creating a python program for plotting a line chart. 23
18. Creating a python program for plotting a bar chart from a CSV file. 24
19. Creating a python program for plotting a multiple bar chart from a CSV file. 25
20. Creating a python program for plotting Histogram. 26
SQLQueries
21. SQL COMMANDS EXERCISE–1(Basic Queries–I) 27
22. SQL COMMANDS EXERCISE–2(Basic Queries–II) 29
23. SQL COMMANDS EXERCISE–3(Aggregate functions, Order by Group by, 31
Having Clause)
24. SQL COMMANDS EXERCISE–4(Math Functions) 33
25. SQL COMMANDS EXERCISE–5(Text Functions) 35
26. SQL COMMANDS EXERCISE–6(Date Functions) 37

2
EX.NO:1

CREATING A PYTHON PROGRAM TO CREATE A

SERIES USING A DICTIONARY.

To write a Python program to create a Series to store 5 students Percentage Using dictionary
and print all the elements that are above 75 percentage.

SOURCE CODE:

SAMPLE OUTPUT:

************************************************************************************************

3
EX.NO:2
CREATING A PYTHON PROGRAM TO CREATE
ASERIES USING SCALAR VALUE

To write a Python program to create a Series object that stores the Initial budget allocated
(50000/-each) for the four quarters of the year: Qtr1, Qtr2, Qtr3 and Qtr4.

SOURCE CODE:

SAMPLE OUPUT:

4
EX.NO:3
CREATING A PYTHON PROGRAM TO CREATE
ASERIES USING NUMPY ARRAY

To write a Python program to create a Series object that stores the Employee names as
index and their Salary as values

SOURCECODE:

SAMPLEOUTPUT:

*************************************************************************************************

5
EX.NO:4

CREATING A PYTHON PROGRAM FOR MODIFYING OR UPDATING EXISTING VALUES

OF SERIES OBJECT.

To Write a Python program to create a Series object with Employee names as the index and
their salaries as values. Accept the name of the employee whose salary needs to be changed,
along with the new salary, and update it in the Series.

SourceCode:

SampleOutput:

****************************************************************************************

6
EX.NO:5
PERFORMING MATHEMATICAL OPERATIONS ON SERIES OBJECTS

To create a program in python to perform following mathematical Operations on Two

Series objects: (i) Addition(ii) Subtraction(iii) Multiplication (iv) Division.

SOURCECODE:

SAMPLEOUTPUT:

**************************************************************************************************

7
EX.NO:6

CREATING A PYTHON PROGRAM FOR CALCULATING PER CAPITA INCOME OF

FOUR ZONES USING SERIES.

To write a Python program to create two series i.e. population and average
income of Four Zones, and then calculate per capita income storing in third
pandas series print it.

SourceCode:

SampleOutput:

***************************************************************************************

8
EX.NO:7

CREATING A PYTHON PROGRAM TO DISPLAY ATTRIBUTES OF A SERIES.

To write a Python program to create a Series using list and display the following attributes of the
Series: (i) index(ii) dtype(iii) size(iv) shape (v) hasnans

SOURCECODE:

SAMPLEOUTPUT:

*************************************************************************************************

9
EX.NO:8

CREATING A PYTHON PROGRAM USING head() AND tail() IN SERIES.

To write a Python program to create a Series using list of Marks of 10 students and
Display first 5 Students’ marks and Last2 Students’ marks from Series object.

SOURCECODE:

SAMPLEOUTPUT:

**************************************************************************************************

10
EX.NO:9

CREATING A PYTHON PROGRAM FOR CREATING A DATAFRAME USING A

NESTED LIST.

To write a Python program to create a panda’s DataFrame for the following table Using
Nested list:

SOURCECODE:

SAMPLEOUTPUT:

**************************************************************************************************

11
EX.NO:10
DATAFRAME

CREATING A PYTHON PROGRAM FOR ACCESSING VALUES OF ROWS AND

COLUMNS OF A DATAFRAME.

To write a Python program to create a panda’s DataFrame called DF for the following
Table Using Dictionary of List and perform the following operations:

(i) To Display only column 'Toys' from DataFrame DF.

(ii) To Display the row details of 'AP' and 'OD' from DataFrame DF.
(iii) To Display the column 'Books' and 'Uniform' for 'M.P' and 'U.P' from DataFrame DF.
(iv) To Display consecutive 3 rows and 3 columns from DataFrame DF.

SOURCECODE:

12
SAMPLEOUTPUT:

*************************************************************************************************

13
EX.NO:11

CREATING A PYTHON PROGRAM FOR ACCESSING VALUES OF ROWS AND

COLUMNSOF A DATAFRAME.

To write a Python program to create a panda’s DataFrame called DF for the following
Table Using Dictionary of List and perform the following operations:

(i) Insert a new column “Bags” with values as [5891,8628,9785,4475].

(ii) Delete the row details of M.P from DataFrame DF.

SOURCECODE:

14
SAMPLEOUTPUT:

**************************************************************************************************

15
EX.NO:12

CREATING A PYTHON PROGRAM TO PERFORM OPERATIONS ON A

DATAFRAME(RENAME, COUNT, UPDATE, REPLACE)

To write a Python program to create a pandas DataFrame to analyze number of

Government and Private medical college and their Total seats,Fees statewise details
using the data set available at www.data.gov.in. Also, perform the following
operations.
(i) To Change the name of the state AP to Andhra.
(ii) To Count and Display Non-NaN values of each column.
(iii) To Count and Display Non-NaN values of each row.
(iv) To Increase the fees of all colleges by 5%.
(v) To Replace all NaN values with 0.
SourceCode:

16
SampleOutput:

*************************************************************************************

17
EX.NO:13

CREATINGAPYTHONPROGRAMTOFILTERTHEDATAOFADATAFRAME

To write a Python program to create a panda’s DataFrame called DF for the following table
using Dictionary of List and display the details of students whose Percentage is more than 85.

SOURCECODE:

SAMPLEOUTPUT:

*******************************************************************************************

18
EX.NO:14

CREATING A PYTHON PROGRAM TO DISPLAY THE ATTRIBUTES OF

ADATAFRAME

To write a Python program to create a DataFrame using Dictionary of list and display the
following attributes of the DataFrame: (i)index (ii)columns (iii)axes (iv)dtypes
(v)shape (vi)dimension (vii)T

SOURCECODE:

SAMPLEOUTPUT:

*******************************************************************************************

19
EX.NO:15

CREATING A PYTHON PROGRAM TO DISPLAY THE DATA OF A DATAFRAME ROW-

WISE AND COLUMN-WISE USING ITERROWS() AND ITERITEMS()

To write a Python program to create a panda’s DataFrame called Students for the
Following table and demonstrate iterrows and iteritems.

SOURCECODE:

20
SAMPLEOUTPUT:

#OutputforIterrows() #OutputforIteritems()

**********************************************************************************************

21
EX.NO:16

CREATING A PYTHON PROGRAM TO PERFORM WRITING AND READING

OPERATIONSIN A CSV FILE

To Write a Python program to store the details of Employess’ such as Empno, Name,
Salary into a Employee.csv file. Also, write a code to read employee details from csv
file.

SOURCECODE:

SAMPLEOUTPUT:

**********************************************************************************************

22
EX.NO:17

CREATINGAPYTHONPROGRAMFORPLOTTINGALINECHART

To write a Python program to plot a Linechart to depict the changing weekly Onion
And Brinjal prices for four weeks. Also, give appropriate axes labels, title and keep marker style
as Diamond and marker edgecolor as ‘red’ for Onion.

SOURCE CODE:

SAMPLEOUTPUT:

*********************************************************************************************

23
EX.NO:18

CREATING A PYTHON PROGRAM FOR PLOTTING A BAR

CHARTFROM A CSV FILE.

To write a Python program to create a DataFrame for subject-wise average, save it to

a CSV file, and then draw a bar chart using Matplotlib with a width of each bar as 0.25,
specifying different colors for each bar. Additionally, provide a proper title and axes labels
for the bar chart.

SourceCode:

SampleOutput:

***********************************************************************************************

24
EX.NO:19

CREATING A PYTHON PROGRAM FOR PLOTTING A

MULTIPLEBAR CHART FROM A CSV FILE.

To write a Python program to plot a multiple bar chart From CSV file using Matplotlib
for subject wise Scores ofClass A, ClassB, and Class C. Different colors represent each
class, and subjects include English, Accountancy, Economics, BST and IP. Proper
labels, a title and a legend are displayed on the chart.

SourceCode:

SampleOutput:

*****************************************************************************************************

25
EX.NO:20

CREATING A PYTHON PROGRAM FOR

PLOTTINGPLOTTING HISTOGRAM

To write a Python program to plot a Histogram for the following class interval or range. Also,
give appropriate axes name, title and edege color as ‘red’.

SOURCECODE:

SAMPLEOUTPUT:

******************************************************************************************

26
Ex.No:21

SQL bCOMMANDS EXERCISE–1

(Basic Queries–I)

To write Queries for the following Questions based on the given table:

EmpID Name Gender Age Dept DOJ Salary City

1 Praveen M 25 Sales 1989-06-08 20000 Chennai
2 Arun M 29 Marketing 1989-09-26 22000 Chennai
3 Usha F 27 Finance 1994-08-09 25000 Bangalore
4 Bala M 31 Sales 1990-03-23 27000 NULL
5 Rani F 28 Marketing 1990-04-23 27000 Mumbai
6 Nisha F 26 NULL 1991-02-24 18000 Bangalore
7 Manoj M 32 Finance 1982-05-06 30000 Goa

(a)Write a Query to Create a new database in the name of "EMPS".

CREATEDATA BASE EMPS;

(b)Write a Query to Open the database EMPS.

USE EMPS;

(c)Write a Query to create the above table called: Info

CREATE TABLE INFO (EmpID int primary key, Name varchar(15),

Gender varchar(3), Age int ,Dept varchar(15),DOJ date, Salary int,City varchar(10));

(d)Write a Query to list all the existing database names.

SHOW DATABASES;

27
 (e) Write a Query to List all the tables that exists in the current database.
SHOW TABLES;
Output:

(f) Write a Query to insert all the rows of above table into Info table.

INSERT INTO INFO VALUES (1,'Praveen','M', 25,'Sales','1989-06-08','20000','Chennai');

INSERT INTO INFO VALUES(2,'Arun','M',29,'Marketing','1989-09-26',22000,'Chennai');
INSERT INTO INFO VALUES(3,'Usha','F',27,'Finance','1994-08-09',25000,'Bangalore');
INSERT INTO INFO VALUES(4,'Bala','M',31,'Sales','1990-03-23',27000,NULL);
INSERT INTO INFO VALUES(5,'Rani','F',28,'Marketing','1990-04-23',27000,'Mumbai');
INSERT INTO INFO VALUES(6,'Nisha','F',26,NULL,'1991-02-24',18000,'Bangalore');
INSERT INTO INFO VALUES (7,'Manoj','M', 32,'Finance','1982-05-06', 30000,'Goa');

(g) Write a Query to display all the details of the Employees from the above table 'INFO'.

SELECT * FROM INFO;

Output:

****************************************************************************************************

28
Ex.No:22

SQLCOMMANDSEXERCISE–2
(BasicQueries–II)

To write Queries for the following Questions based on the given table:

EmpID Name Gender Age Dept DOJ Salary City

1 Praveen M 25 Sales 1989-06-08 20000 Chennai
2 Arun M 29 Marketing 1989-09-26 22000 Chennai
3 Usha F 27 Finance 1994-08-09 25000 Bangalore
4 Bala M 31 Sales 1990-03-23 27000 NULL
5 Rani F 28 Marketing 1990-04-23 27000 Mumbai
6 Nisha F 26 NULL 1991-02-24 18000 Bangalore
7 Manoj M 32 Finance 1982-05-06 30000 Goa

(a) Write a Query to Display Employees’ name and City from the above table.

SELECT NAME,CITY FROM INFO;

Output:

(b) Write a Query to Display all details of Employees who are living in Chennai.

SELECT * FROM INFO WHERE CITY='CHENNAI';

Output:

29
(c) Write a Query to get the name and salary of the employee whose salary is above
15000 and gender is not male.

SELECT NAME,SALARY FROM INFO

WHERE SALARY>15000
AND GENDER<>'M';
Output:

(d) Write a query to update increase 10% Salary of an employee whose City is'CHENNAI'
and Gender is 'MALE'.

UPDATE INFO SET SALARY=SALARY+(SALARY*0.10)

WHERE CITY='CHENNAI' AND GENDER='MALE';

Output(AfterUpdating):

(e) Write a Query to delete the details of EmployeeId of 6.

DELETE FROM INFO WHERE EMPID=6;

Output(After Deletion):

30
*************************************************************************

31
Ex.No:23
SQL COMMANDS EXERCISE–3

(Aggregate Functions, OrderBy GroupBy,Having Clause)

To write Queries for the following Questions based on the given table:

EmpID Name Gender Age Dept DOJ Salary City

1 Praveen M 25 Sales 1989-06-08 20000 Chennai
2 Arun M 29 Marketing 1989-09-26 22000 Chennai
3 Usha F 27 Finance 1994-08-09 25000 Bangalore
4 Bala M 31 Sales 1990-03-23 27000 NULL
5 Rani F 28 Marketing 1990-04-23 27000 Mumbai
6 Nisha F 26 NULL 1991-02-24 18000 Bangalore
7 Manoj M 32 Finance 1982-05-06 30000 Goa
(a)Write a Query to listnames of Employees in Descending order.

SELECT NAME FROM INFO ORDER BY NAME DESC;

Output:

(b)Write a Query to find a total salary of all employees.

SELECT SUM(SALARY) FROM INFO;

Output:

(c)Write a Query to display maximum salary and minimum salary Of employees.

SELECT MAX(SALARY), MIN(SALARY) FROM INFO;

Output:

31
 (d) Write a Query to count the number of employees earning more than 25000.

SELECT COUNT(SALARY) FROM INFO

WHERE SALARY>25000;

Output:

(e) Write a query to display sum of salary of the employees grouped by department wise.

SELECT DEPT, SUM(SALARY) FROM INFO GROUPBY DEPT;

Output:

(f) Write a query to display the department names where number of employees are
greater than or equal to 2.

SELECT DEPT FROM INFO GROUP BY DEPT HAVINGCOUNT(*)>=2;

Output:

****************************************************************************************

32
Ex.No:

SQL COMMANDS EXERCISE–4

(Mathematical Functions)

To write Queries for the following Questions based on the given table-"STU":

(a) Write a Query to Display square of age that got admission in the month of August.

SELECT POWER(AGE,2) FROM STU WHERE DO ALIKE '%-08-%';

Output:

(b) Write a Query to display Remainder of column Percentage divide by 3.

SELECT MOD(MARKS,3) FROM STU;

Output:

33
(c) Write a Query to display Student names and their Percentage in round figure.

SELECT NAME, ROUND(PERCENTAGE,0) FROM STU;

Output:

(d) Display Name, Percentage and round up the remainder marks up to 2 decimal
places.

SELECT NAME, ROUND (MOD(PERCENTAGE,3),2) FROM STU;

Output:

**************************************************************************************

34
Ex.No:25

SQLCOMMANDSEXERCISE–5
(TextFunctions)

To write Queries for the following Questions based on the given table-"STU":

(a) Write a Query to display Department name in lower case letters.

SELECT LCASE(DEPT) FROM STU;

Output:

(b) Write a Query to display department name and its respective number of characters in
Dept column.

SELECT DEPT, LENGTH(DEPT) FROM STU;

Output:

35
 (c) Write a Query to display first 2characters of the column Name.

SELECT LEFT(NAME,2) FROM STU;

Output:

(d) Write a Query to display first 2 characters of the column Name.

SELECT RIGHT (NAME,2) FROM STU;
Output:

(e) Write a query to display the names of all students and extract five characters from
the third position of the 'Name' field.

SELECT SUBSTR(NAME,3,5) FROM STU;

Output:

**********************************************************************************************

36
Ex.No:26

SQL COMMANDS EXERCISE–6(DateFunctions)

To write Queries for the following Questions based on the given table:

(a) Write a Query to display student name and month of date of admission of all
students.

SELECT NAME, MONTH(DOA) FROM STU;

Output:

(b) Write a Query to display Student name and day name of the students’ DOA of the
Table STU.

SELECT NAME, DAY NAME(DOA) FROM STU;

Output:

37
 (c) Write a query to display the joining year of IP students.

SELECT YEAR(DOA) FROM STU WHERE DEPT='IP';

Output:

(d) Write a Query to Display the month for the date_of_birth of all students.

SELECT NAME,MONTH NAME(DOA) FROM STU;

Output:

(e) Write a query to display the names of the students who joined in the month of June.

SELECT NAME FROM STU WHERE MONTH NAME(DOA)='June';

Output:

*********************************************************************************************

38