[go: up one dir, main page]
Scribd
Upload
119 views7 pages

Sample - Index, Certificate & Acknowledgement

This document contains an index of 18 practical programming assignments to be completed. The assignments include tasks such as writing programs to check if a number is prime or a palindrome, calculate compound interest, perform ASCII character encoding/decoding, and import/export data between CSV files and Pandas dataframes. Additional assignments involve SQL queries to manipulate database tables, connecting Python to MySQL for CRUD operations, and reading/writing text and CSV files line by line or row by row.

Uploaded by

ZACK & CYRUS
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
119 views7 pages

Sample - Index, Certificate & Acknowledgement

This document contains an index of 18 practical programming assignments to be completed. The assignments include tasks such as writing programs to check if a number is prime or a palindrome, calculate compound interest, perform ASCII character encoding/decoding, and import/export data between CSV files and Pandas dataframes. Additional assignments involve SQL queries to manipulate database tables, connecting Python to MySQL for CRUD operations, and reading/writing text and CSV files line by line or row by row.

Uploaded by

ZACK & CYRUS
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/ 7

Index(handwritten)

Sl no. Practical Date Signature


1 Write a program in python to check a
number whether it is prime or not.
2 Write a program to check a number
whether it is palindrome or not.
3. Write a program to calculate
compound interest.
4. . Write a program to display ASCII
code of a character and vice versa.
5. Write a program to input a character
and to print whether a given character
is analphabet, digit or any other
character.
6. .write a python program to create a
binary file with roll no, name, marks.
Display the binary file.
7. Write a program to generate random
numbers between 1 to 6 and check
whether a user won a lottery or not.
8. Write a program to import data
between csv file and pandas with
practical example.
9. Write a program to export data
between dataframe and csv with
practical example.
10. Write a python program to remove all
the lines that contain the character a
in a file and write it into another file
11. Write a python program to Read a text
file and display the number of
vowels/consonants/uppercase/
lowercase characters in the text file.
12. Write a menu based program to
perform the operation on stack in
python.
13. .write a python program for linear
search.
14. write a python program to create a csv
file by entering user-id and
password,read and search the
password for given user-id.
15. . Read a text file line by line and
display each word separated by a #
16. Write a python program to perform
write and read operation of a csv file.
17. .Create the following table persons
and write the SQL query command
based on the same table.
Insert the details of a new details of
persons in the above table.

Find the min,max,sum and average of


the BasicSalary in a persons table.

Write a SQL QUERY to order the


persons table in descending order of
the BasicSalary

Write a sql query using aggregate


functions

Add new column ‘Increment’ in


persons table

Fill the Increment column in persons

Using the Persons table Querying and


manipulating Groupby,Having
Orderby.

18. Write a program to connect Python


with MySQL using database
connectivity and perform the
followingoperations on data in
database :Insert,Fetch, Update and
Delete

CERTIFICATE(should be handwritten)
Instructions:
 Write your name in place of Name of the student.

 Write Explorer International School in place of name of


the school.
 Write 2022-23 in place of SESSION.
ACKNOWLEDGEMENT(should be handwritten)
Instructions:
 Write SPACE in place of Name of the Teacher.

 Write Explorer International School in place of name of


the school.
 Write SPACE in place of Name of the Principal.
 Write your name in place of Name of the student.

You might also like