Nav bharti sr sec school
Name - lakshit demla
Class - XII –A
Subject - informatics practices
Submitted to - Ms. Ritu Aswal(PGT)
Informatics practices practical file
(065)
Signature of teacher signature of examiner
_________________ __________________
1
index
Create a pandas series from a dictionary of values and
ndarray
Write a python program to create a pandas using scalar
values
Create a pandas series using range function
Create a pandas series using NaN values
Create a pandas series to acess data from it with
position
Create a pandas series and use loc[] and iloc[]
Create a pandas series and retrieve the data using some
conditions
create a dataframe from dictionary , dictionary of series
and 2darray and also create a empty dataframe
2
create a dataframe for accessing data using loc[] and
iloc[]
Create a dataframe to perform concatenation, merge
and join indexing
create a program for importing and exporting data
between pandas and csv
write a python program to plot the line chart for salary
hike of and employee
. Write a python program to plot the pass percentage of
the year 2019 2020,classes 6th to 12th using line chart
Write a program to plot a chart using some random
value
Write a python program to display a bar graph for the
blood group based on number of patients
Given the school result data ,analyse and the
performance of students on different parametres
Take data of your interest from an open
source,aggregate and summarise it then plot it
using different plotting functions of matplotlib library
3
Take data of your interest from an
opensource,aggregate and summarise it then plot it
using different plotting functions of matplotlib library
Create a student table with student id ,name ,marks as
attribute where student id is primary key
Write a sql command to order the
(student id, marks) marks in descending order
Write a query to find “ROUND” of percentage in table
Write a sql query to display names into capital letters,
display first 3 letters of name, display last 3 letters of
name, display the position the
to remove the extra spaces from left , right and both
sides of “ informaticspractises 12 “
to display todays date in “year/month/date” format
Display dayname, monthname, dayname, day of
month,day of year for today's date
4
Create a pandas series from a dictionary of
values and ndarray
Write a python program to create a pandas
using scalar values
Create a pandas series using range function
5
Create a pandas series using NaN values
Create a pandas series to acess data from it with
position
Series
6
7
Create a pandas series and use loc[] and iloc[]
series
8
Create a pandas series and retrieve the data
using some conditions
Series
9
create a dataframe from dictionary ,
dictionary of series and 2darray and also
create a empty dataframe
dataframe from dictionary
dictionary of series
dataframe from 2d array
10
empty dataframe
11
create a dataframe for accessing data using
loc[] and iloc[]
dataframe
loc[]
iloc[]
12
Create a dataframe to perform
concatenation, merge and join indexing
Concatenation
13
merging
14
create a program for importing and
exporting data between pandas and csv
15
[DATA VISUALISATION]
write a python program to plot the line chart
for salary hike of and employee
16
. Write a python program to plot the pass
percentage of the year 2019 2020,classes 6th
to 12th using line chart
17
Write a program to plot a chart using some
random value
18
Write a python program to display a bar
graph for the blood group based on number
of patients
19
Given the school result data ,analyse and
the performance of students on different
parametres
20
Take data of your interest from an open
source,aggregate and summarise it then plot it
using different plotting functions of matplotlib
library
21
22
[database management ]
Create a student table with student id ,name
,marks as attribute where student id is
primary key
Creating table
Inserting data
Table
Insert the data of new student in the above table
Delete the data of new student in the above table
23
Use select command to get the detail of the students
where marks is greater than 80
Use select command to get the detail of the students
where marks is greater than 80
To find the average,sum,max,min of marks
24
Write a sql command to order the
(student id, marks) marks in descending order
Write a query to find “ROUND” of percentage in
table
Table
Round
25
Write a sql query to display names into capital
letters, display first 3 letters of name, display
last 3 letters of name, display the position the
letter A in name
Table
Uppercase
Lowercase
26
First three letters
Last three letters
Position of letter ‘a’
27
to remove the extra spaces from left , right and both sides
of “ informaticspractises 12 “
removing spaces from left
removing spaces from right
to remove spaces from both sides
28
to display todays date in “year/month/date”
format
Display dayname, monthname, dayname, day
of month,day of year for today's date
29
