As per CBSE Practical List 2024-25
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.
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.
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
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 Here 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
SUiiiiiiiiiiiiiiiiiiiiiii
ReplyDelete