Written by students who passed Immediately available after payment Read online or as PDF Wrong document? Swap it for free 4.6 TrustPilot
logo-home
Exam (elaborations)

Informatics Practices Practical File | Pandas & SQL | HAVO |

Rating
-
Sold
-
Pages
18
Grade
9-10
Uploaded on
15-06-2026
Written in
2025/2026

This is a complete practical file for Informatics Practices (Class XII) covering essential Python and SQL programming concepts. The document includes worked solutions for Pandas Series creation, data filtering with percentiles, and SQL database operations like INSERT and GROUP BY queries. Ideal for HAVO Computer Science students preparing for practicals and exams, with clear code examples and expected outputs for each exercise.

Show more Read less
Level
Course

Content preview

ST. MARKS PUBLIC SCHOOL
CLASS: XII
INFORMATICS PRACTICES (065)


Complete Practical File
Session: 2026-2027



Submitted By: ________________
Roll No: __________
Teacher: __________________




Page 1 of 18

, CERTIFICATE



This is to certify that the practical
file submitted by ……………………… who is the
student of Class XII, St. Marks Public
School, Kuberpur, Agra is a bonafide
record of work done during the
academic session 2026-2027.



Teacher Signature: __________
Examiner Signature: __________




Page 2 of 18

, Q1: Create a Pandas Series from dictionary and
ndarray.

Aim: To create Pandas Series using dictionary and
ndarray.

Solution:

import pandas as pd
import numpy as np
data = {'A':10,'B':20,'C':30}
s1 = pd.Series(data)
arr = np.array([100,200,300])
s2 = pd.Series(arr)
print(s1)
print(s2)

Output:

A 10
B 20
C 30


0 100
1 200
2 300


Q2: Print elements above 75th percentile from a
Series.

Aim: To filter values above 75th percentile.

Solution:

import pandas as pd

import numpy as np

# Creating a sample Series

data = pd.Series([10, 20, 30, 40, 50, 60, 70, 80, 90,
100])

print("Original Series:")

Page 3 of 18

Written for

Institution
Secondary school
Level
Course
School year
2

Document information

Uploaded on
June 15, 2026
Number of pages
18
Written in
2025/2026
Type
Exam (elaborations)
Contains
Questions & answers

Subjects

€9,94
Get access to the full document:

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Get to know the seller
Seller avatar
radhesikarwar

Get to know the seller

Seller avatar
radhesikarwar
Follow You need to be logged in order to follow users or courses
Sold
-
Member since
1 week
Number of followers
0
Documents
2
Last sold
-

0,0

0 reviews

5
0
4
0
3
0
2
0
1
0

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions