12th class Python Program list 2020-21

                  As per CBSE Practical List 2020-21: Click Here
File Handling:

1. Read a text file line by line and display each word separated by a '#'. Click Here    date : 26.06.20
2.  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   date : 03.07.20
3. 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  date : 07.07.20
4. Remove all the lines that contain the character `a’ in a file and write it to another file. Click Here date : 14.07.20
5. Read a text file and display the number of vowels/ consonants/ uppercase/ lowercase characters in the file.  Click Here  date : 21.07.20
6. 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   date : 31.07.20
7. Create a binary file with roll number, name and marks. Input a roll number and update the marks. Click Here  date : 07.08.20
    8. Text Files Menu Driven Program: Click Here  date : 14.08.20
       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.
9. Text Files Menu Driven Program: Click Here  date: 18.08.20
       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. 

               DATA STRUCTURE

10. Write a python program to implement a stack using a list data-structure. 

      Click Here (Reference Video: Click Here)   date: 21.08.20

11. Write a Python program to implement a queue using a list data-structure.  

      Click Here     date: 25.08.20

  GENERAL

12.  Write a random number generator that generates random numbers               between 1 and 6 (simulates a dice). Click Here       date: 02.09.20

13. Take a sample of 10 phishing e-mails and find the most common                  words. Click Here   (Reference Video: Click Here)    date: 09.09.20

14. 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   

date: 12/09/20

 Python libraries:

15. Write a program for user defined import modules. Click Here 

date: 15.09.20

16. Write a program for user defined import Packages/Libraries.Click Here   date: 29.09.20

 Data Management And MYSQL ( Interface with MYSQL )

1. fetchall(), fetchone(), fetchmany() and rowcount( python interface through MYSQL) Click Here (Reference video: Click Here)  date: 06.10.20
2. Insert, Update and Delete in a Student Table(Python Interface through MYSQL) Program Click Here   (Reference video: Click Here)   date: 09.10.20
3. Find the min, max, sum, and average of the marks in a student marks table( python interface through MYSQL). Click here  date: 16.10.20
4. 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   date: 03.11.20

############################END######################################

12th class Python Program list 2019-20

1. Recursively find the factorial of a natural number. Click Here
2. Read a file line by line and print it. Click Here
3. Remove all the lines that contain the character `a’ in a file and write it to another file. Click Here
4. Write a Python function sin(x, n) to calculate the value of sin(x) using its Taylor series expansion up to n terms. Compare the values of sin(x) for different values of n with the correct value: Click Here
5. Write a random number generator that generates random numbers between 1 and 6 (simulates a dice).Click Here
6. Write a recursive code to find the sum of all elements of a list. Click Here
7. Write a recursive code to compute the nth Fibonacci number. Click Here
8. Write a Python program to implement a stack using a list data-structure. Click Here
9. Write a recursive Python program to test if a string is a palindrome or not. Click Here
10. Write a Python program to plot the function y = x2 using the pyplot or matplotlib libraries. Click Here
11. Create a graphical application that accepts user inputs, performs some operation on them, and then writes the output on the screen. For example, write a small calculator. Use the tkinter library. Click Here
12. Open a webpage using the urllib library Click Here
13. Compute EMIs for a loan using the numpy or scipy libraries. click Here
14. Take a sample of 10 phishing e-mails and find the most common words. Click Here
15. Write a Python program to implement a queue using a list data-structure.                  Click Here

1. 
   

5.2. Data Management: SQL and web-server

1. Integrate SQL with Python by importing the MySQL module : Click Here
2. Find the min, max, sum, and average of the marks in a student marks table. Click Here
3. Find the total number of customers from each country in the table (customer ID, customer name, country) using group by. Click Here
4. Write a SQL query to order the (student ID, marks) table in descending order of the marks.Click Here
5. Write a Django based web server to parse a user request (POST), and write it to a CSV file: Click Here

5.3. Additional Programs

    1. 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’. Click here

     2. 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

    3. Write a Recursive Python program with function BinarySearch(Arr,l,R,X) to search the given   element X to be searched from the List Arr having R elements where L represents lower bound and R represents upper bound. Click Here

   4. Mysql and data base programs: Click Here
         Click Here

1. Write a SQL query to order the (student ID, marks) table in descending order of the marks.