CBSE Class 12 Python Practical File G Krishna Chauhan

 

Practical List Class XII

• Write a program in python to check a number whether it is prime or not.
  
  
• Write a program to check a number whether it is palindrome or not.
  
  
• Write a program to calculate compound interest.
  
  
• Write a program to display ASCII code of a character and vice versa.
  
  
• Write a program to input a character and to print whether a given character is an alphabet, digit or any other character.
  
  
• Write a program to calculate the factorial of an integer using recursion.
  
  
• Write a program to print fibonacci series using recursion.
  
  
• Write a python function sin(x,n) to calculate the value of sin(x) using its taylor series expansion up to n terms.
  
  
• Write a recursive python program to test if a string is palindrome or not.
  
  
• Write a program to generate random numbers between 1 to 6 and check whether a user won a lottery or not.
  
  
• Write a program to create a library in python and import it in a program.
  
  
• Write a program to import predefined module (Math) and use it in a program.
  
  
• Write a program to import predefined module (String) and use it in a program.
  
  
• Write a program in python to display a predefined function example.
  
  
• Write a python function to find the maximum of three number using function.
  
  
• Write a python program to display the concept of default argument, Keyword Arguments.
  
  
• Write a python program for passing the ARRAYS /LISTS to Function.
  
  
• Write a python function to multiply all the numbers in a list.Sample List : ( 9,18,27,8 )
  
  
• Write a python program to display the concept of user-defined Functions with argument and with return value.
  
  
• Write a program to count number of words in a file.
  
  
• Write a program to count the number of vowels present in a text file.
  
  
• Read a text file line by line and display each word separated by a #. 
  
  
• Read a text file and display the number of consonants/ uppercase/ lowercase characters in the 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.
  
  
• Remove all the lines that contain the character `a' in a file and write it to another file.
  
  
• Write a program to find the most common words in a file.
  
  
• Write a program to perform write operation with .csv file.
  
  
• Write a program to perform read operation with .csv file.
  
  
• Write a menu based program to perform the operation on stack in python.
  

 

SQL Queries

• Create a student table and insert data.
  
  
• Implement the following SQL commands on the student table.
  
  
• ALTER table to add new attributes / modify data type / drop attribute 
• UPDATE table to modify data ORDER By to display data in ascending / descending order DELETE to remove tuple(s) GROUP BY 
  
  
• Write the queries using, 

• DISTINCT, 
• BETWEEN, 
• IN, 
• LIKE, 
• IS NULL, 
• ORDER BY, 
• GROUP BY,
•  HAVING. 
  
  
• Queries for Aggregate functions- SUM( ), AVG( ), MIN( ), MAX( ), COUNT( ) 
  
  
•  Integrate SQL with Python by importing the MySQL module. 
  
  
• Write a program to connect Python with MySQL using database connectivity and perform the following operations on data in database: 
• Fetch, 
• Update, 
• delete the data