Thursday 25 June 2020

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.     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 videoClick 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 notClick 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

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.