Practical Programs
1 Python program – Fibonacci series
2 Python program – Mathematical functions
Menu driven program using user defined functions to perform
3
arithmetic operations
Menu driven program using user defined functions to find factorial
4
and sum of list of numbers
Text File Programs
To write a program to read a text file PARA.txt line by line and
5
display each word separated by a #.
Write a Python Program to Read a File STORY.TXT and Capitalize
6
the First Letter of Every Word in the File and write it in Cap.txt
Read a text file book.txt and display the number of digits/ vowels/
7
consonants/special char/uppercase/lowercase characters in the file.
Read a file story.txt , Remove all the lines that starts with letter 'a'
8
and write it to another file.
Write a Python Program that Reads a Text File “para.txt” and Counts
9
the Number of Times word “the” Appears in the Text File.
Write a Python function that extracts and displays all the words
1 containing a hyphen ("-") from a text file "HyphenatedWords.txt",
0 which has a three letter word before hypen and four letter word after
hypen. For example : “for-them” is such a word
Binary File
Create a binary file with name and roll number. Search for a given
11 roll number and display the name, if not found display appropriate
message
1 Create a binary file with roll number, name and marks. Input a roll
2 number and update the marks.
Create a binary file with book details using dictionary with the
1
following keys bno, bname, author, publisher, price. search and
3
display those books whose price are greater than 700
1 Create a Binary file in the form of Dictionary and read the data for
4 the given condition
Write a python code to create a binary file “book.dat” that has
1
structure [BookNo, Book_Name, Author, Price] and define a
5
function deleteRec(Author) to delete the given author books.
Write a python code to create a binary file “book.dat” that has
1 structure [BookNo, Book_Name, Author, Price] and define a
6 function CountRec(Author), RemoveRec() and a UpdateRec() using
a menu driven.
CSV File
1 Create a CSV file by entering user-id and password, read and search
5 the password for given userid.
Create a csv file for employee details with the following fields
1
[eno,ename, doj,desgn,basic,da,hra ] append and calculate the gross
6
pay
1 Create csv file for employee details with the following fields
7 [eno,ename, doj,desgn,basic,da,hra ] search and update a record.
1 Create a CSV file ‘record.csv’ and COUNTR() – To count the
8 number of records present in the CSV file named ‘record.csv’.
Data Structure
1
Stack – Menu driven program using List
9
2
Stack using Dictionary
0
SQL
2
Student Table with DDL and DML commands
1
2
Student Table with SQL Operators and order by
2
2
Staff Table with Group by command and aggregate functions
3
2
Two Table – Using Join
4
MY SQL – Connectivity
2
Create insert and Display
5
2
Update and Display
6
2
Delete and Display
7
2
DDL commands
8
2
Two Table
9
3
Search a record
0
