Practical file with python and MYSQL programming querries

School Name
School Logo



PRACTICAL FILE
Informatics Practices /
Computer Science
(Python)


Name :
Class:
School:
Roll No.

, INDEX

Sign of the
S.No. Name of Practical Date Page No.
Teacher

1 Python program to create a series

2 Python program to

3 Python program to

4 Python program to

5 Python program to

6 Python program to

7 Python program to

8 Python program to

9 Python program to

10 Python program to

11 Python program to

12 Python program to

13 Python program to

14 Python program to

15 Python program to

16 Python program to create graph

17 Python program to create graph

18 Python program to create graph

19 Python program to create graph

20 Python program to create graph

21 Python program to Connect MySQL

22 Python program to Connect MySQL

23 MySQL Queries

, 1. Write a program to create a series using List with defined index
values.


import pandas as pd
list1 = [10,20,30,40,50]
series1 = pd.Series(list1, index = ['a','b','c','d','e'])
print(series1)


Output

, 2. Write a program to create a series using List with defined index
values and slicing data from a series.


import pandas as pd
list1 = [10,20,30,40,50]
s = pd.Series(list1, index = ['a','b','c','d','e'])
print(s[0]) #for 0 index position
print(s[:3]) #for first 3 index values
print(s[-3:]) #for last 3 index values




Output