INFORMATICS
PRACTICES
PRACTICAL
PRACTICAL 1
Bhargavi Kaul XII-H
Date: 17/4/2025
Q1 Create a series using scalar values.
Code:
Output:
PRACTICAL 2
Bhargavi Kaul XII-H
Date: 28/4/2025
Q2 Assign user-defined labels to the index and use them to access elements of a series.
Code:
Output:
PRACTICAL 3
Bhargavi Kaul XII-H
Date: 30/4/2025
Q3 Create a series using letters or strings as indices.
Code:
Output:
PRACTICAL 4
Bhargavi Kaul XII-H
Date: 2/5/2025
Q4 Create a series from a one-dimensional (1D) NumPy array.
Code:
Output:
PRACTICAL 5
Bhargavi Kaul XII-H
Date: 5/5/2025
Q5 Create a series using letters or strings as indices.
Code:
Output:
PRACTICAL 6
Bhargavi Kaul XII-H
Date: 7/5/2025
Q6 Create a series where keys of the dictionary (dict1) become indices in the series.
Code:
Output:
PRACTICAL 7
Bhargavi Kaul XII-H
Date: 7/5/2025
Q7 Use slicing to modify the values of series elements.
Code:
Output:
PRACTICAL 8
Bhargavi Kaul XII-H
Date: 9/5/2025
Q8 Use the different attributes of Dataframes to get information about the data from the code as
output.
Code:
Output:
PRACTICAL 9
Bhargavi Kaul XII-H
Date: 12/5/2025
Q9 WAP to create a series using pandas with label index as capitals of any four
countries.
Code:
Output:
PRACTICAL 10
Bhargavi Kaul XII-H
Date: 14/5/2025
Q10 WAP to join two dataframes.
Code:
Output:
PRACTICAL 11
Bhargavi Kaul XII-H
Date: 16/5/2025
Q11 WAP to create a dataframe from a dictionary of lists.
Code:
Output:
PRACTICAL 12
Bhargavi Kaul XII-H
Date: 19/5/2025
Q12 WAP to add a new column to a dataframe.
Code:
Output:
PRACTICAL 13
Bhargavi Kaul XII-H
Date: 10/7/2025
Q13 WAP to import data from a CSV file and convert it to a Data Frame.
Code:
Output:
PRACTICAL 14
Bhargavi Kaul XII-H
Date: 14/7/2025
Bhargavi Kaul XII-H
Q14 WAP to convert a DataFrame to a CSV file.
Plot a graph in matplotlib to display the temperature of a place for 4 weeks.
Code:
Output:
PRACTICAL 15
Bhargavi Kaul XII-H
Date: 16/7/2025
Q15 Plot a graph in matplotlib to display the date wise temperature for 3 days.
Code:
Output:
PRACTICAL 16
Bhargavi Kaul XII-H
Date: 16/7/2025
Q16 Plot a bar chart to compare the increase in sales of 2 companies in a week.
Code:
Output:
PRACTICAL 17
Bhargavi Kaul XII-H
Date: 10/7/2025
Q17 Plot a histogram to show the frequency of height and weight of 6 children in matplotlib.
Code:
Output:
PRACTICAL 18
Bhargavi Kaul XII-H
Date: 19/7/2025 Date: 4/8/25
Q18 Use all attributes of the alter command.
PRACTICAL 19
Bhargavi Kaul XII-H
Date: 18/8/25
Q19 Use the three main numeric functions and display the output.
PRACTICAL 20
Bhargavi Kaul XII-H
Date: 6/10/25
Q20 Use the three main numeric functions and display the output.
PRACTICAL 21
Bhargavi Kaul XII-H
Date: 8/10/25
Q21 WAP and use aliases to get output from two tables consecutively in SQL.
PRACTICAL 22
Bhargavi Kaul XII-H
Date: 11/10/25
Q22 WAP to find the name starting from the letter ‘S’ in the table.
PRACTICAL 23
Bhargavi Kaul XII-H
Date: 14/10/25
Q23 WAP to drop a primary key and a column from the table.
PRACTICAL 24
Bhargavi Kaul XII-H
Date: 16/10/25
Q24 WAP to convert 2 strings into uppercase and lowercase respectively.
\
PRACTICAL 25
Bhargavi Kaul XII-H
Date: 16/10/25
Q25 WAP to perform the following aggregate functions on the data.
1)MAX()
2)MIN()
3)AVG()
4)SUM()