UCSKM PUBLIC SCHOOL

1
2
This is to certify that Shubham Sharma, students
of class XII PCM has successfully completed CS
project under the guidance of Mrs. Hema Sharma.

__________
Signature
Mrs. Hema Sharma

3
PYTHON .................................................................................................................................................................. 5
1. Function to find the simple and compound interest .......................................................................................... 6
2. write a code to generate the odd numbers between two numbers a and b ..................................................... 7
3. Write a function to count the number of words in a string................................................................................ 8
4.To read a word line by line and display each word separated by a # .................................................................. 9
5. Read a text file and the number of vowels/consonants/uppercase/lowercase characters ............................. 10
6. Remove all lines that contain the character a and write it to another file ....................................................... 11
7.Create a binary file with roll no.,name and marks. Input a rollno. & update the marks ................................... 12
8. : Create a binary file with name and roll no. Search for a given roll no. & display the name, if not found
display appropriate message. ............................................................................................................................... 14
9. : Create a CSV file by entering user-id & password, read & search the password for given user-id ................ 16
10.Take a simple of ten phishing e-mails (or any text file) and find most commonly occurring words ............... 18
11. Write a program to calculate square root of a number if it is even, otherwise calculate its cube root… ...... 19
Command to create a database ........................................................................................................................... 21
Command to use the database ............................................................................................................................. 21
Command to create a table .................................................................................................................................. 21
Command to describe the table’s structure ......................................................................................................... 22
Command to show tables in the database ........................................................................................................... 22
Command to show the data in the table .............................................................................................................. 22
(i) Command to add a column at specified position ............................................................................................. 23
(ii) Command to modify a column ........................................................................................................................ 23
To create column aliasis ....................................................................................................................................... 24
Command to use where clause in select statement ............................................................................................. 24
Command to perform simple calculations ........................................................................................................... 24
Command for grouping of same type of records ................................................................................................. 24
Command to update a record in the table ........................................................................................................... 25
Deleting records from the table ........................................................................................................................... 25
Establishing an restricted join............................................................................................................................... 25
Connection of MySQL with Python....................................................................................................................... 26

4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27