[go: up one dir, main page]
Scribd
Upload
12 views2 pages

Index

The document lists various programming tasks and exercises focused on Python, including creating menu-driven programs, file handling, and database connectivity with MySQL. It covers a wide range of topics such as arithmetic operations, Fibonacci series, text file manipulation, and CSV file processing. Additionally, it includes tasks related to implementing data structures like stacks and performing SQL queries.

Uploaded by

gdggdfhu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views2 pages

Index

The document lists various programming tasks and exercises focused on Python, including creating menu-driven programs, file handling, and database connectivity with MySQL. It covers a wide range of topics such as arithmetic operations, Fibonacci series, text file manipulation, and CSV file processing. Additionally, it includes tasks related to implementing data structures like stacks and performing SQL queries.

Uploaded by

gdggdfhu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Index

Serial Program Signature


No.
1. Creating a menu driven program to perform arithmetic
operations.
2. Creating a python program to display Fibonacci series.
3. Creating a menu driven program to find factorial and sum of list
of numbers using function.
4. Creating a python program to implement returning value(s)
from function.
5. Creating a python program to implement mathematical
functions.
6. Creating a python program to generate random
number between 1 to 6.
7. Write a function in python which accept a list of
marks of students and return the minimum mark, maximum
mark and the average marks. Use the same function to test.
8. WAP to read a text file “myfile.txt” line by line and display each
word separated by a #.
9. WAP to read a text file “myfile.txt” and display the number of
vowels/ consonants/ uppercase/ lowercase characters in the
file.
10. Remove all the lines that contain the character `a' in a file and
write it to another file.
11. Write a program to create a text file and print the lines starting
with ‘T’ or ‘P’. (Both uppercase and lowercase).
12. Read a text file to print the frequency of the word ‘He’ and ‘She’
found in the file.
13. 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.
14. Create a binary file with roll number, name and marks. Input a
roll number and update the marks.
15. Read a CSV file from hard disc and print all the details on the
screen.
16. Read a CSV file (containing item no, name, rate, QOH)
from hard disc and print all the items whose rate is
between Rs 500 and Rs 1000.
17. Create a CSV file by entering user-id and password, read and
search the password for given userid.
18. Write a Python program to implement a stack using a list data-
structure.
19. WAP to pass an integer list as stack to a function and push
only those elements in the stack which are divisible by 5.
20. Creating a python program to implement stack operations.
21. Queries using Create database, Show databases, Use, Create
table, Show Tables, Describe, Rename, Alter, Select, From,
Where, Insert, Update commands.
22. Queries using DISTINCT, BETWEEN, IN, LIKE, IS NULL, ORDER BY,
GROUP BY, HAVING.
23. Queries for Aggregate functions- SUM( ), AVG( ),
MIN( ), MAX( ), COUNT( )
24. WAP to connect Python with MySQL using database
connectivity and perform the following operation on
data in database: Create a table in database.
25. WAP to connect Python with MySQL using database
connectivity and perform the following operation on data in
database: Insert record in the table.
26. WAP to connect Python with MySQL using database
connectivity and perform the following operation on data in
database: Fetch records from the table using fetchone( ),
fetchall() and fetchmany( ).
27. WAP to connect Python with MySQL using database
connectivity and perform the following operation on
data in database: Update record in the table.
28. WAP to connect Python with MySQL using database
connectivity and perform the following operation on
data in database: Delete record from the table.

You might also like