Scribd
Upload
11 views8 pages

Informatics Practices Practical File 2024-25

This document is a practical file for the Informatics Practices course submitted by Ayan from Stanford International School for the academic session 2024-25. It includes a certificate of completion, a declaration of originality, acknowledgments, and an index of practicals covering Pandas, Matplotlib, and MySQL. Each section contains specific coding examples and SQL commands related to the respective topics.

Uploaded by

hjsjjsnjjjsjjsj
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
11 views8 pages

Informatics Practices Practical File 2024-25

This document is a practical file for the Informatics Practices course submitted by Ayan from Stanford International School for the academic session 2024-25. It includes a certificate of completion, a declaration of originality, acknowledgments, and an index of practicals covering Pandas, Matplotlib, and MySQL. Each section contains specific coding examples and SQL commands related to the respective topics.

Uploaded by

hjsjjsnjjjsjjsj
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

INFORMATICS PRACTICES (065)

PRACTICAL FILE
SESSION 2024-25
Submitted By:
Name: Ayan
Class: XII
Roll No: 4
School: Stanford International School

Submitted To:
Mr. Pankaj
CERTIFICATE
This is to certify that Ayan of Class XII, Roll No. 4, Stanford International School has
successfully completed the Informatics Practices Practical File for the academic session
2024-25 as prescribed by CBSE.

Teacher's Signature: ____________


Date: ____________
DECLARATION
I, Ayan, student of Class XII, Roll No. 4, Stanford International School hereby declare that
this practical file is my original work and has been completed under the guidance of my
subject teacher.

Signature: ____________
ACKNOWLEDGEMENT
I would like to express my sincere thanks to my teacher Mr. Pankaj and my school Stanford
International School for their guidance and support in completing this practical file.
INDEX
1. Pandas Practicals
2. Matplotlib Practicals
3. MySQL Practicals
SECTION A: PANDAS PRACTICALS
Practical 1: Create a Series with 5 elements.
Code:
import pandas as pd
s = [Link]([10,20,30,40,50])
print(s)

Practical 2: Create a DataFrame and display first and last rows.


Code:
import pandas as pd
d = {'A':[1,2,3,4],'B':[5,6,7,8]}
df = [Link](d)
print([Link]())
print([Link]())
SECTION B: MATPLOTLIB PRACTICALS
Practical 1: Draw a line chart.
Code:
import [Link] as plt
x=[1,2,3,4]
y=[10,20,30,40]
[Link](x,y)
[Link]()

Practical 2: Draw a bar chart.


Code:
import [Link] as plt
x=['A','B','C']
y=[10,20,15]
[Link](x,y)
[Link]()
SECTION C: MYSQL PRACTICALS
Practical 1: Create a table.
SQL:
CREATE TABLE student(id INT PRIMARY KEY, name VARCHAR(30), marks INT);

Practical 2: Insert records.


SQL:
INSERT INTO student VALUES(1,'Ayan',85);

Practical 3: Display students with marks > 80.


SQL:
SELECT * FROM student WHERE marks>80;

You might also like