Python Programming Experiments List
Python Programming Experiments List
Page
S. No. Program Date
No.
Python program to implement the following using recursion:
Python program to read a text file named “[Link]” and display the following:
a) The words start with t and a (or) T and A.
b) Even length words in a given file.
c) Python program to read a binary file named “[Link]” has structure
3 [ bookname, book no., author, price ]
Write a user defined function createfile() to input data for a record and
add to “[Link]”
Write a user defined function countRec(author) which accepts author
name as parameter and count the [Link] books by the given author are
stored in binary file “[Link]” and return result.
Aim: Write a python programme to find the factorial of a given number using recursion ?
Source code:
"""
@author: it203
"""
def fact(n):
if n < 0:
return None
elif n == 0:
return 1
else:
return n * fact(n - 1)
while True:
try:
result = fact(n)
except ValueError:
if [Link]() == 'n':
break
1
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
Output:
Aim: Write a python programme to find the fibanocci series upto n terms using recursion ?
Source code:
"""
@author: it203
"""
def fib(n):
if n<=1:
return 1
else:
return fib(n-1)+fib(n-2)
while True:
n=int(input("Enter n value"))
print(0,end=" ")
for i in range(100):
if fib(i)<=n:
print(fib(i),end=" ")
else:
2
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
break
if c=='n' or c=='N':
break
Output:
Aim: Write a python programme to find the given number is palindrome or not using
recursion ?
Source code:
"""
@author: it203
"""
if n == 0:
return rev
else:
rem = n % 10
while True:
3
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
if num == pal(num):
else:
if [Link]() == 'n':
break
Output:
Aim:
4
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
Source code:
"""
@author: it203
"""
while True:
import random
import string
password=string.ascii_letters+[Link]+[Link]
print(password)
password=[Link](string.ascii_letters,6)
password+=[Link](string.ascii_letters.upper(),2)
password+=[Link]([Link])
password+=[Link]([Link])
print("password is:",password)
pwd="".join(password)
if c=='n' or c=='N':
break
5
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
Output:
Aim: Write a python programme to generate the random days between the two days ?
Source code:
"""
@author: it203
"""
while True:
sd1=[Link](sd,"%d-%m-%y")
ed1=[Link](ed,"%d-%m-%y")
sd1+=timedelta(days=1)
print(sd1)
6
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
if [Link]() == 'n':
break
Output:
Aim: Write a python programme to Print 12 fixed dates from a specified date,where
difference between two days is 20.
Source code:
"""
@author: it203
"""
while True:
d1=[Link](d,"%d-%m-%Y")
for i in range(12):
7
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
d1+=timedelta(days=20)
print(d1)
if [Link]() == 'n':
break
Output:
Source code:
"""
@author: it203
"""
while True:
8
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
d1=input("enter date(dd-mm-yyyy):")
d1=[Link](d1,"%d-%m-%Y")
d=[Link]()
d2=(d-d1).days
y=d2//365
m=(d2-(y)*365)//30
d3=(d2-(y*365))-(m*30)
if c=="n" or c=="N":
break
Output:
Aim: Write a python programme to Find all integers and floating point numbers in the given
paragraph & print their sum.
Source code:
"""
@author: it203
9
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
"""
while True:
import re
l = [Link](r"\d+", str1)
total_sum = sum(floats)
if [Link]() == 'n':
break
Output:
Aim: Write a python programme Count the [Link] words ends with small “s” or capitals
“S” and Display their words in given format a given string occurrence ?
Source code:
"""
@author: it203
10
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
"""
import re
while True:
words = [Link]()
matched_words = []
if [Link]('s') or [Link]('S'):
matched_words.append(word)
if [Link]() == 'n':
break
Output:
Aim: Write a python programme to create filename “[Link]” write some content and display
their content from the file ?
Source code:
"""
11
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
@author: it203
"""
f1=open("[Link]","w")
[Link](str1)
f1=open("[Link]","r")
r=[Link]()
print(r)
[Link]()
Output:
Aim: Write a python programme to read a text file named “[Link]” and displays the
following?
Source code:
"""
"""
f=open("[Link]","r")
s=[Link]()
print(s)
s1=[Link](" ")
print(s1)
12
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
for i in s1:
print(i)
else:
continue
Output:
Aim: Write a python programme to read a text file named “[Link]” and displays the
following and Even length words are in the file ?
Source code:
"""
@author: it203
"""
import re
f=open("[Link]","w")
f=open("[Link]","r")
str=[Link]()
str1=[Link]()
13
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
for i in str1:
if len(i) % 2==0:
print(i)
Output:
Aim: Write a python programme to read a binary file named “[Link]” has
structure[bookname,bookno,author,price]
(i)Write a user defined function createfile() to input data for a record on add to
“[Link]”?
as parameter and count the no of books by the author in a binary file “[Link]” ?
Source code:
"""
@author: it203
"""
import pickle
def createfile():
f=open("[Link]", "ab")
14
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
[Link](record, f)
def record_count():
count = 0
try:
f=open("[Link]", "rb")
while True:
try:
record = [Link](f)
if record[2].strip().lower() == [Link]().lower():
count += 1
except EOFError:
break
except Exception as e:
return
if count == 0:
else:
while True:
createfile()
15
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
if [Link]() == 'n':
break
record_count()
Output:
(i)create account
(ii)deposit amount
(iii)withdraw amount
(iv)mini statement
(v)check balance
16
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
(A)Source code:
"""
@author: it203
"""
import random
class BANK:
def __init__(self):
[Link] = "BEC"
[Link] = {}
[Link] = []
def create(self):
while True:
else:
17
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
break
def deposit(self):
if accno in [Link]:
if p == [Link]:
print("Deposited Successfully!")
else:
print("Incorrect password.")
else:
def withdraw(self):
if accno in [Link]:
if p == [Link]:
print("Insufficient Balance")
else:
print("Withdraw successful!")
18
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
else:
print("Incorrect password.")
else:
def check_balance(self):
if accno in [Link]:
if p == [Link]:
else:
print("Incorrect password.")
else:
def mini_statement(self):
if accno in [Link]:
print("Recent Transactions:")
if transaction[1] == accno:
print()
else:
19
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
def display(self):
print("\nList of Accounts:")
print("Account Number: " + str(accno) + ", Name: " + details[0] + ", Balance: Rs. " +
str(details[1]))
print()
obj = BANK()
while True:
if choice == 1:
[Link]()
elif choice == 2:
[Link]()
elif choice == 3:
[Link]()
elif choice == 4:
obj.mini_statement()
elif choice == 5:
obj.check_balance()
elif choice == 6:
[Link]()
elif choice == 7:
break
else:
20
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
Output:
21
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
22
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
23
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
(i)create
(ii)delete
(iii)update
(iv)search
(v)display
"""
@author: it203
"""
class LIBRARY:
def __init__(self):
[Link] = ""
[Link] = 0
[Link] = ""
[Link] = 0.0
[Link] = ""
def create(self):
[Link](self)
24
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
def delete(self):
for i in l:
if [Link] == bno:
[Link](i)
return
def update(self):
for i in l:
if [Link] == bno:
return
def search(self):
for i in l:
print("Book Found:\n")
if [Link] == bno:
print([Link],[Link],[Link],[Link])
return
25
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
def display(self):
if len(l) == 0:
return
for i in l:
print([Link],[Link],[Link],[Link],[Link])
print()
l=[]
while True:
obj = LIBRARY()
if ch == 1:
[Link]()
elif ch == 2:
[Link]()
elif ch == 3:
[Link]()
elif ch == 4:
[Link]()
elif ch == 5:
[Link]()
elif ch == 6:
26
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
break
else:
Output:
27
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
28
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
(i)push
(ii)pop
(iii)peek
(iv)display
Source code:
"""
@author: it203
"""
class STACK:
29
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
def __init__(self):
self.l=[]
[Link]=0
def push(self):
[Link](ele)
def pop(self):
if len(self.l) == 0:
print("Stack is empty\n")
else:
def peek(self):
if len(self.l) == 0:
print("Stack is empty\n")
else:
def display(self):
if len(self.l) == 0:
print("Stack is empty\n")
else:
rev = self.l[::-1]
obj = STACK()
while True:
30
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
if ch == 1:
[Link]()
elif ch == 2:
[Link]()
elif ch == 3:
[Link]()
elif ch == 4:
[Link]()
elif ch == 5:
break
else:
Output:
31
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
32
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
(i)Enqueue
(ii)Dequeue
(iii)Dsiplay
Source code:
"""
33
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
@author: it203
"""
class Queue:
def __init__(self):
[Link]=0
self.l=[]
def enqueue(self):
[Link]([Link])
def dequeue(self):
if len(self.l)==0:
print("Queue is empty")
else:
def display(self):
if len(self.l)==0:
print("Queue is empty")
else:
print("current Queue:",ans)
obj=Queue()
while True:
print("[Link]\[Link]\[Link]\[Link]\n")
34
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
if ch==1:
[Link]()
elif ch==2:
[Link]()
elif ch==3:
[Link]()
elif ch==4:
break
else:
print("Invalid choice")
Output:
35
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
36
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
(i)create
(ii)insert_at_begin
(iii)insert_at_end
(iv)insert_at_spec_loc
iv)delete_at_begin
(vi)delete_at_end
(vii)delete_at_spec_loc
(viii)display
Source code:
"""
@author: it203
"""
class Node:
[Link]=data
[Link]=None
class linked_list:
def __init__(self):
[Link]=None
[Link]=None
[Link]=None
if [Link] is None:
37
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
[Link]=n
[Link]=[Link]
else:
[Link]=n
[Link]=[Link]
[Link]=[Link]
[Link]=n
if [Link]==None:
[Link]=n
else:
[Link]=[Link]
[Link]=[Link]
[Link]=n
if pos<1:
return
if pos==1:
[Link]=[Link]
[Link]=n
return
tmp=[Link]
count=1
38
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
tmp=[Link]
count+=1
if tmp==None:
else:
[Link]=[Link]
[Link]=n
def delete_at_begin(self):
if [Link]==None:
print("List is empty")
else:
[Link]=[Link]
print("Deleted successfully")
def delete_at_end(self):
if [Link]==None:
print("List is empty")
elif [Link]==None:
[Link]=None
print("Deleted successfully")
else:
tmp=[Link]
tmp = [Link]
[Link] = None
print("Deleted successfully")
if [Link]==None:
39
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
print("List is empty")
return
if pos<1:
return
if pos==1:
[Link]=[Link]
print("Deleted successfully")
return
tmp=[Link]
count=1
tmp=[Link]
count+=1
else:
[Link]=[Link]
print("Deleted successfully")
def display(self):
if [Link]==None:
print("List is empty")
return
tmp=[Link]
tmp=[Link]
40
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
print("None")
a=linked_list()
while True:
if ch==1:
n=Node(d)
[Link](n)
elif ch==2:
n=Node(d)
a.insert_at_begin(n)
elif ch==3:
n=Node(d)
a.insert_at_end(n)
elif ch==4:
n=Node(d)
a.insert_at_specific(n, pos)
elif ch==5:
a.delete_at_begin()
elif ch==6:
a.delete_at_end()
41
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
elif ch==7:
a.delete_at_specific(pos)
elif ch==8:
[Link]()
elif ch==9:
break
else:
print("Invalid choice!")
Output:
42
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
43
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
44
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
45
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
Source code:
import math
class GC:
def __init__(self):
self.a = 0
self.b = 0
def read1(self):
def add(self):
def sub(self):
46
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
def mul(self):
def div(self):
if self.b!= 0:
else:
class SC(GC):
def lcm(self):
while True:
break
greater += 1
def gcd(self):
while self.b:
def fact(self):
if n < 0:
elif n==0:
print("1")
else:
47
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
f=1
for i in range(1,n+1):
f*=i
def sqrt(self):
result= n ** 2
class ASC(SC):
def cos(self):
def sin(self):
def tan(self):
def log(self):
if x > 0:
else:
def fa_to_cel(self):
c=(f-32)*5/9
48
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
def cel_to_fa(self):
f=(c*9/5)+32
def gram_to_kg(self):
kg=gram/1000
def kg_to_gram(self):
kg=int(input("enter kg value"))
gram=kg*1000
def dollar_to_rupees(self):
r=d*85
def rupees_to_dollar(self):
d=r/85
while True:
if ch == 1:
obj1 = GC()
49
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
if ch1 == 1:
obj1.read1()
[Link]()
elif ch1 == 2:
obj1.read1()
[Link]()
elif ch1 == 3:
obj1.read1()
[Link]()
elif ch1 == 4:
obj1.read1()
[Link]()
elif ch == 2:
obj2 = SC()
if ch2==1:
obj2.read1()
[Link]()
elif ch2==2:
obj2.read1()
[Link]()
elif ch2==3:
obj2.read1()
50
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
[Link]()
elif ch2==4:
obj2.read1()
[Link]()
elif ch2 == 5:
obj2.read1()
[Link]()
elif ch2 == 6:
obj2.read1()
[Link]()
elif ch2 == 7:
[Link]()
elif ch2 == 8:
[Link]()
elif ch == 3:
obj3 = ASC()
print("[Link]\[Link]\[Link]\[Link]\[Link]\[Link]\[Link]
\[Link] root\[Link] functions\[Link] Conversions\n")
if ch3 == 1:
obj3.read1()
[Link]()
elif ch3 == 2:
obj3.read1()
[Link]()
elif ch3 == 3:
obj3.read1()
51
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
[Link]()
elif ch3 == 4:
obj3.read1()
[Link]()
elif ch3== 5:
obj3.read1()
[Link]()
elif ch3==6:
obj3.read1()
[Link]()
elif ch3==7:
obj3.read1()
[Link]()
elif ch3==8:
obj3.read1()
[Link]()
elif ch3==9:
print("[Link]\[Link]\[Link]\[Link]")
if ch33==1:
[Link]()
elif ch33==2:
[Link]()
elif ch33==3:
[Link]()
elif ch33==4:
[Link]()
52
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
elif ch3==10:
if ch44==1:
obj3.fa_to_cel()
elif ch44==2:
obj3.cel_to_fa()
elif ch44==3:
obj3.gram_to_kg()
elif ch44==4:
obj3.kg_to_gram()
elif ch44==5:
obj3.dollar_to_rupees()
elif ch44==6:
obj3.rupees_to_dollar()
elif ch==4:
print("Exiting Calculator.")
break
else:
Output:
53
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
54
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
55
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
56
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
57
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
(a)Create
(b)Insert
(c)Display
(d)Update
(e)Search
(f)Delete
(g)Exit
Source code:
"""
@author: it203
"""
class DATABASE:
def create(self):
import sqlite3
try:
conn = [Link]("[Link]")
cursor = [Link]()
myquery = """
EMPNAME TEXT,
EMPID INTEGER,
58
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
DNO INTEGER,
GENDER TEXT,
EMPSALARY INTEGER
"""
[Link](myquery)
[Link]()
finally:
if conn:
[Link]()
def insert(self):
import sqlite3
try:
conn=[Link]("[Link]")
cursor=[Link]()
for i in range(n):
59
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
[Link]()
finally:
if conn:
[Link]()
def display(self):
import sqlite3
try:
conn=[Link]("[Link]")
cursor=[Link]()
[Link](cr)
records=[Link]()
print("name is:",row[0])
print("Id is:",row[1])
print("Dno is:",row[2])
print("Gender is:",row[3])
60
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
print("Salary is:",row[4])
print("\n")
finally:
if conn:
[Link]()
def update(self):
import sqlite3
try:
conn = [Link]("[Link]")
cursor = [Link]()
record = [Link]()
if record:
[Link]()
else:
61
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
finally:
if conn:
[Link]()
def search(self):
import sqlite3
try:
conn = [Link]("[Link]")
cursor = [Link]()
records=[Link]()
if records:
print("Employee found")
print("name is:",row[0])
print("Id is:",row[1])
print("Dno is:",row[2])
print("Gender is:",row[3])
print("Salary is:",row[4])
print("\n")
else:
62
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
finally:
if conn:
[Link]()
def delete(self):
import sqlite3
try:
conn = [Link]("[Link]")
cursor = [Link]()
[Link]()
finally:
if conn:
[Link]()
obj=DATABASE()
while True:
if choice == 1:
[Link]()
63
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
elif choice == 2:
[Link]()
elif choice == 3:
[Link]()
elif choice == 4:
[Link]()
elif choice == 5:
[Link]()
elif choice == 6:
[Link]()
elif choice == 7:
break
else:
64
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
65
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
66
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
67
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
Aim: Write a python programme to demonstrate the EXCEL- file on student management
system ?
(a)Basic
(b)Range
(c)Merge
(d)Sort
(e)Search
(f)Startswith
(g)Exit
Source code:
"""
@author: ambat
"""
class EXCEL:
def basic(self):
import pandas as pd
df = pd.read_excel('[Link]')
print("sum:", df["marks"].sum())
print("mean:", df["marks"].mean())
print("max:", df["marks"].max())
print("min:", df["marks"].min())
def range(self):
import pandas as pd
68
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
df = pd.read_excel('[Link]')
start_range = 20
end_range = 30
print(students_in_range)
def merge(self):
import pandas as pd
df3.to_excel("[Link]", index=False)
def sort(self):
import pandas as pd
df = pd.read_excel('[Link]')
print(sorted_df)
def search(self):
import pandas as pd
df = pd.read_excel('[Link]')
def find_student_details(regno):
regno = ['Y23AIT901']
print(find_student_details(reg))
69
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
print()
def startswith(self):
import pandas as pd
df = pd.read_excel('[Link]')
print(filtered)
print("\n")
obj = EXCEL()
while True:
if n == 1:
[Link]()
elif n == 2:
[Link]()
elif n == 3:
[Link]()
elif n == 4:
[Link]()
elif n == 5:
[Link]()
elif n == 6:
[Link]()
elif n == 7:
print("Exiting program.")
70
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
break
else:
Output:
71
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
72
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
73
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
74
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
Aim: Python Program to implement a Simple Game. (Tic Tac Toe or Number Game or Quiz
or Puzzle or Etc...)
Source code:
"""
@author: ambat
"""
puzzles = ["e _ e _ _ a _ _", "t _ _ e _", "g _ _ _ _ f _", "m _ _ _ e _", "p _ _ _ _ t"]
while True:
score = 0
for i in range(len(words)):
print("Puzzle", i + 1)
print("Clue:", puzzles[i])
if user_input.lower() == words[i]:
score = score + 1
else:
print("Game Over.")
75
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
if [Link]() != "yes":
break
print()
Output:
76
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
77
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
78
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
Aim: Python program to implement a simple calculator with a GUI interface using the tkinter
module.
Source code:
"""
@author: ambat
"""
import tkinter as tk
def calculate():
num1 = [Link]()
num2 = [Link]()
op = [Link]()
try:
n1 = float(num1)
n2 = float(num2)
if op == "+":
result = n1 + n2
elif op == "-":
result = n1 - n2
elif op == "*":
result = n1 * n2
elif op == "/":
if n2 != 0:
result = n1 / n2
else:
79
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
return
else:
return
except ValueError:
window = [Link]()
[Link]("Simple Calculator")
[Link]()
entry1 = [Link](window)
[Link]()
[Link]()
entry2 = [Link](window)
[Link]()
[Link]()
operator = [Link]()
[Link]("+")
[Link]()
[Link]()
80
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
result_label.pack()
[Link]()
Output:
81
DEPARTMENT OF INFORMATION TECHNOLOGY
PYTHON PROGRAMMING LAB (20ITL401/SOC2) REGDNO: Y23AIT403
82
DEPARTMENT OF INFORMATION TECHNOLOGY