12th CS Python Program list 2025-26

   As per CBSE Practical List 

Suggested Practical List:

Python Programming
● Read a text file line by line and display each word separated by a #.
● Read a text file and display the number of vowels/consonants/uppercase/lowercase characters in the file.

● Remove all the lines that contain the character 'a' in a file and write it to another file.

● Create a binary file with name and roll number. Search for a given roll number and display the name, if not found display appropriate message.

● Create a binary file with roll number, name and marks. Input a roll number and update the marks.

● Write a random number generator that generatesrandom numbers between 1 and 6 (simulatesa dice).

● Write a Python program to implement a stack using list.

● Create a CSV file by entering user-id and password, read and search the password for given user-id.

Database Management

● Create a student table and insert data. Implement the following SQL commands on the student table:

o ALTER table to add new attributes / modify data type / drop attribute

o UPDATE table to modify data

o ORDER By to display data in ascending / descending order

o DELETE to remove tuple(s)

o GROUP BY and find the min, max, sum, count and average

● Similar exercise may be framed for other cases.

● Integrate SQL with Python by importing suitable module.

1. file line by line and display each word separated by a #. click here  

2. Read a text file and display the number of                                                                   vowels/consonants/uppercase/lowercase characters in the file.                                           Click here

3. Remove all the lines that contain the character 'a' in a file and write it to another file. Click here 

4. Create a binary file with name and roll number. Search for a given roll number and display the name, if not found display appropriate message.                                                    Click here  

5. Create a binary file with roll number, name and marks. Input a roll number and update the marks. Click here 

 6. Write a random number generator that generates random numbers between 1 and 6 (simulates a dice). Click here 

7. Write a Python program with function to count the number of lines in a text file ‘ 'STORY.TXT’ which is starting with an alphabet ‘A’ or 'a'. Click here 

8. Write a Python program with method/function DISPLAYWORDS() to read lines from a text file STORY.TXT, and display those words, which are less than 4 characters.   Click Here 

9. Text Files Menu Driven Program: Click Here  

Choice = 1. Read a text file line by line and display each word             

 separated by a '#'. 
 Choice = 2.Python program with function to count the number of lines 
  in a text file ‘ 'STORY.TXT’ which is starting with an alphabet ‘A’ or 'a'.
  Choice= 3. Python program with method/function DISPLAYWORDS() 
  to read lines from a text file STORY.TXT, and display those words, 
   which are less than 4 characters.
10. Text Files Menu Driven Program: Click Here    Choice= 1. Remove all the lines that contain the character `a’ in a file and write it to another file. 
Choice= 2. Read a text file and display the number of vowels/                        consonants/ uppercase/ lowercase characters in the file.                                  


11. Create a CSV file by entering user-id and Password, read and search the password for given user-id. Click Here  Source code: Click Here (courtesy Reference video: Click here date: 


12. Write a program to input the value of x and n and print the sum of the
series: x + x^2/2! - x^3/3! + x^4/4! + ............ x^n/n! click here  


13. Determine whether a number is a perfect number, an armstrong number or a  palindrome.  Click here  
14. Input a number and check if the number is a prime or composite number.        click here 
15. Display the terms of a Fibonacci series.  click here


Data Structure
01 Stack Program 1 Write a python program to implement a stack using a list data-structure. Click Here (Reference Video: Click Here)
02. Stack Program 2 Write a menu based python program to implement the the operations insert, delete, peek and display on stack(Member number, Member Name and Age).Click Here 

03. Stack based program 3 Write a Python Program to implement a Stack for the book details (bookno,bookname). That is, each item node of the stack contains two types of information- a book number and its name. Implement all the operations of Stack.Click Here

MySQL/SQL programmes

04. SQL Queries:-1 .ONE TABLE Click Here 

05. SQL Queries:-2 – TWO TABLES. Click Here  

06. SQL Queries:-3- Create the following student table and answer the following queries. Click Here

Connectivity Programmes (Mysql with Python)

07. Find the total number of customers from each country in the table (customer ID, customer name, country) using group by( python interface through MYSQL). Click Here

08. INSERT, UPDATE, AND DELETE (PYTHON INTERFACE THROUGH MYSQL)ppt slides(RKS):Click Her​e and Reference: INSERT, UPDATE, AND DELETE (PYTHON INTERFACE THROUGH  MYSQL)video: Click Here

09.fetchall(), fetchone(), fetchmany() and rowcount( python interface through MYSQL) ppt slides (RKS): Click Here

Reference: fetchall(), fetchone(), fetchmany() and rowcount( python interface through MYSQL video: Click Here

10. Find the min, max, sum, and average of the marks in a student marks table( python interface through MYSQL). Click here  




Click here 


Project

Websites link(subject)

1.Pythontrends

https://pythontrends.wordpress.com/

​

2.pythonmykvs

http://python.mykvs.in/index.php

Create the following student table and answer the following queries.

 

Table: Student

No	Name	Age	Dept	DateofAdm	Fee	Gender
1	Pankaj	24	Computer	10/01/99	12000	M
2	Shalini	21	History	24/03/20	20000	F
3	Sanjay	22	Hindi	12/12/21	30000	M
4	Sudha	24	History	01/07/21	25000	F
5	Rakesh	22	Computer	27/12/21	30000	M
6	Shakeel	20	Hindi	31/07/99	21000	M

a)     a)  List the names of female students who are in Hindi Department

b)   b) List the names of all the students with their date of admission in ascending order.

c)   c)  Display student’s name,fee and age for male students only.

d)   d) Count the number of students with age <23.

e)   e) Change the fee of students whose fee is <15000.

Source code and Output:

Stack Program 2 Write a menu based python program to implement the the operations insert, delete, peek and display on stack.

 Member details: 

MemberNo                     integer

MemberName                String

Age                                integer

def isEmpty(stk):

   if stk==[]:

       return True

   else:

       return False

def push(stk,item):

    stk.append(item)

    top=len(stk)-1

def pop(item):

    if isEmpty(stk):

        return "underflow"

    else:

        item=stk.pop()

        if len(stk)==0:

            top=None

        else:

            top=len(stk)-1

        return item

def peek(stk):

    if isEmpty(stk):

        return "underflow"

    else:

        top=len(stk)-1

        return stk[top]

def Display(stk):

    if isEmpty(stk):

        print("stack empty")

    else:

        top=len(stk)-1

        print(stk[top],"<-top")

        for a in range(top-1,-1,-1):

            print(stk[a])

#main

stk=[]

top=None

while True:

    print("STACK OPERATIONS")

    print("1.push")

    print("2.pop")

    print("3.peek")

    print("4.display")

    ch=int(input("enter your choice(1-4)"))

    if ch==1:

        mno=int(input("enter the member number"))

        mname=input("enter the member name")

        age=int(input("enter the age of member"))

        item=[mno,mname,age]

        push(stk,item)

    elif ch==2:

        item=pop(stk)

        if item=="underflow":

            print("underflow")

        else:

            print("popped item is",item)

    elif ch==3:

        item=peek(stk)

        if item=="underflow":

            print("underflow")

        else:

            print("topmost item is",item)

    elif ch==4 :

        Display(stk)

    else:

       print("invalid")

Output

enter the member number2

enter the member namesathish

enter the age of member35

STACK OPERATIONS

1.push

2.pop

3.peek

4.display

enter your choice(1-4)1

enter the member number3

enter the member namesuresh

enter the age of member36

STACK OPERATIONS

1.push

2.pop

3.peek

4.display

enter your choice(1-4)3

topmost item is [3, 'suresh', 36]

STACK OPERATIONS

1.push

2.pop

3.peek

4.display

enter your choice(1-4)4

[3, 'suresh', 36] <-top

[2, 'sathish', 35]

[1, 'umesh', 34]

STACK OPERATIONS

1.push

2.pop

3.peek

4.display

enter your choice(1-4)2

popped item is [3, 'suresh', 36]

STACK OPERATIONS

1.push

2.pop

3.peek

4.display

enter your choice(1-4)4

[2, 'sathish', 35] <-top

[1, 'umesh', 34]

STACK OPERATIONS

1.push

2.pop

3.peek

4.display

enter your choice(1-4)2

popped item is [2, 'sathish', 35]

STACK OPERATIONS

1.push

2.pop

3.peek

4.display

enter your choice(1-4)4

[1, 'umesh', 34] <-top

STACK OPERATIONS

1.push

2.pop

3.peek

4.display

enter your choice(1-4)2

popped item is [1, 'umesh', 34]

STACK OPERATIONS

1.push

2.pop

3.peek

4.display

enter your choice(1-4)2

underflow

STACK OPERATIONS

1.push

2.pop

3.peek

4.display

Stack based program 3 Write a Python Program to implement a Stack for the book details (bookno,bookname). That is, each item node of the stack contains two types of information- a book number and its name. Implement all the operations of Stack.

 

#source code:

def isEmpty(stk):

    if stk==[]:

        return True

    else:

        return False

def push(stk,item):

    stk.append(item)

    top=len(stk)-1

def pop(stk):

    if isEmpty(stk):

        print("underflow")

    else:

        item=stk.pop()

        if len(stk)==0:

            top=None

        else:

            top=len(stk)-1

        return item

def peek(stk):

    if isEmpty(stk):

        return "underflow"

    else:

        top=len(stk)-1

        return stk[top]

def display(stk):

    if isEmpty(stk):

        print("underflow")

    else:

        top=len(stk)-1

        print(stk[top],"<-top")

        for a in range(top-1,-1,-1):

            print(stk[a])

#main

stk=[]

top=None

while True:

    print("STACK OPERATIONS")

    print("1. Push")

    print("2. pop")

    print("3. peek")

    print("4. display")

    ch=int(input("enter choice"))

    if ch==1:

        bno=int(input("enter bookno to be inserted:"))

        bname=input("enter book name to be inserted:")

        item=[bno,bname]

        push(stk,item)

    elif ch==2:

        item=pop(stk)

        if item=="underflow":

            print("underflow")

        else:

            print("popped item is",item)

    elif ch==3:

        item=peek(stk)

        if item=="underflow":

            print("underflow")

        else:

            print("topmost item is:",item)

    elif ch==4:

        display(stk)

    else:

        print("invalid choice")

Output:

Create a dictionary of students to store names and marks obtained in 5 subjects

students=dict()

n=int(input("How many Students are there :"))

for i in range (n):

                sname = input (" Enter the name of the student :")

                marks =[]

                for j in range (5):

                                mark = float (input("enter marks : "))

                                marks.append(mark)

                students[sname] = marks

print ( "created dictionary of students is ", students )                                

name=input("enter name of the student ")

if name in students.keys():

                print (students [name])

else:

                print (" no student found with this name")

Output:

How many Students are there :3

 Enter the name of the student :sh

enter marks : 45

enter marks : 46

enter marks : 48

enter marks : 40

enter marks : 49

 Enter the name of the student :h

enter marks : 45

enter marks : 34

enter marks : 37

enter marks : 29

enter marks : 45

 Enter the name of the student :m

enter marks : 48

enter marks : 40

enter marks : 34

enter marks : 50

enter marks : 38

created dictionary of students is  {'sh': [45.0, 46.0, 48.0, 40.0, 49.0], 'h': [45.0, 34.0, 37.0, 29.0, 45.0], 'm': [48.0, 40.0, 34.0, 50.0, 38.0]}

enter name of the student s

 no student found with this name

======= RESTART: C:/Users/acer/AppData/Local/Programs/Python/Python310/SHAMBHAVEE MISHRA 11 TH D 16TH PROGRAMME.py =======

How many Students are there :3

 Enter the name of the student :sh

enter marks : 45

enter marks : 46

enter marks : 48

enter marks : 40

enter marks : 49

 Enter the name of the student :h

enter marks : 45

enter marks : 34

enter marks : 37

enter marks : 29

enter marks : 45

 Enter the name of the student :m

enter marks : 48

enter marks : 40

enter marks : 34

enter marks : 50

enter marks : 38

created dictionary of students is  {'sh': [45.0, 46.0, 48.0, 40.0, 49.0], 'h': [45.0, 34.0, 37.0, 29.0, 45.0], 'm': [48.0, 40.0, 34.0, 50.0, 38.0]}

enter name of the student sh

[45.0, 46.0, 48.0, 40.0, 49.0]

To print the highest and lowest values in the dictionary

 

Write a Python program to get the maximum and minimum value in a dictionary.

Sample Solution:-

Python Code:

my_dict = {'x':500, 'y':5874, 'z': 560}

key_max = max(my_dict.keys(), key=(lambda k: my_dict[k]))
key_min = min(my_dict.keys(), key=(lambda k: my_dict[k]))

print('Maximum Value: ',my_dict[key_max])
print('Minimum Value: ',my_dict[key_min])

Sample Output:

Maximum Value:  5874                                                                                          
Minimum Value:  500

Python Program to create a dictionary having state names and their capitals