INDEX

S. No. PROGRAM
1 Write the definition of a function Alter (A,N) in python, which should change all the odd numbers in
the list to 1 and even

numbers to 0.

2 Write a code in python for a function Convert ( T, N) , which repositions all the elements of array by
shifting each of them

to next position and shifting first element to last position.

3 Write a function SWAP2BEST ( ARR, Size) in python to modify the content of the list in such a way that
the elements,

which are multiples of 10 swap with the value present in the very next position in the list.

4 Write function definition for SUCCESS(), to read the content of a text file STORY.TXT, and count the
presence of word
STORY and display the number of occurences of this word.

5 Write a program to find no of lines starting with ‘F’ in firewall.txt.

6 Write a program that reads character from the keyboard one by one. All lower case characters get
store inside the file

LOWER, all upper case characters get stored inside the file UPPER and all other characters get stored
inside OTHERS.

7 Write a definition for a function Economic() to read each record of a binary file ITEMS.DAT, find and
display those items

which cost less than 2500.

8 Write a function to search for a tablet from a binary file “table.dat”. The user should enter the model
no and function

should search and display the details of the tablet.

9 Write a program to find how many 'firewall' or 'to’ are present in a file firewall.txt.

10 Write a python function to search and display the record of that product from the file PRODUCT.CSV
which has

maximum cost.

Sample of product.csv is given below:

pid,pname,cost,quantity

p1,brush,50,200

p2,toothbrush,120,150

p3,comb,40,300

p4,sheets,100,500

p5,pen,10,250

11 Write a program to find no of lines starting with F in firewall.txt.

12 Write the definition of a member function PUSH() in python to add a new book in a dynamic stack of
BOOKS considering

the following code is already included in the program: ISBN, TITLE.

13 Write a function in python to delete a node containing book’s information, from a dynamically
allocated stack of books

implemented with the help of the following structure: BNo, BName.

14 Write a function in python PUSH (Arr), where Arr is a list of numbers. From this list, push all numbers
divisible by 5 into a
stack implemented by using a list. Display the stack if it has at least one element, otherwise display
appropriate error

message.

15 Write a function in python POP (Arr), where Arr is a stack implemented by a list of numbers. The
function returns the

value deleted from the stack.

16 A linear stack called "List" contains the following information:

a. Roll Number of student

b. Name of student

Write add(List) and pop(List) methods in python to add and remove from the stack.

17 Write SQL command for (a) to (f) and write the outputs for (g) on the basis of tables INTERIORS and
NEWONES.

18 Write SQL commands for (a) to (f) and write the outputs for (g) on the basis of table HOSPITAL.

19 Write a MySQL-Python connectivity code display ename, empno, designation, sal of those employees
whose salary is

more than 3000 from the table emp . Name of the database is “Emgt”.

20 Write a MySQL-Python connectivity code to increase the salary (sal) by 300 of those employees
whose designation (job) is clerk from the table emp. Name of the database is “Emgt”.

PROGRAMS
#Program 1
def Alter(A,N):

for i in range(N):

if (A[i]%2==0):

A[i]=0

else:

A[i]=1

print(“List after alteration”, A)

D=[10,13,15,21]

print(“Original list”, d)

r=len(d)
Alter(d,r)

#OUTPUT

Original list [10,13,15,21]

List after alteration [0,1,1,1]

#Program 2
def Convert(T,N):

t=T[0]

for i in range(N-1):

T[i]=T[i+1]

T[N-1]=t

print("after conversion", T)

d=[10,14,11,21]

print("Original List", d)

r=len(d)

Convert(d,r)

#OUTPUT

Original List [10, 14, 11, 21]

after conversion [14, 11, 21, 10]

#Program 3
def SWAP2BEST(A,size):

i=0

while(i<size):

if(A[i]%10==0):

A[i],A[i+1]=A[i+1],A[i]

i=i+2

else:
 i=i+1

return(A)

d=[90,56,45,20,34,54]

print("actual list", d)

r=len(d)

print("after swapping", SWAP2BEST(d,r))

#OUTPUT

actual list [90, 56, 45, 20, 34, 54]

after swapping [56, 90, 45, 34, 20, 54]

#Program 4
def SUCCESS():

f=open("STORY.txt")

r=f.read()

c=0

for i in r.split():

if(i=="STORY"):

i=i.lower()

c=c+1

print(c)

f.close()

SUCCESS()

#Program 5
f=open(r"C:\Users\hp\Desktop\cs\networking\firewall.txt")

c=0

for i in f.readline():

if(i=='F'):
 c=c+1

print(c)

#OUTPUT

#Program 6
f=open(r"C:\Users\user\Desktop\cs\networking\firewall.txt")

f1=open("lower.txt","a")

f2=open("upper.txt","a")

f3=open("others.txt","a")

r=f.read()

for i in r:

if(i>='a' and i<='z'):

f1.write(i)

elif(i>='A' and i<='Z'):

f2.write(i)

else:

f3.write(i)

f.close()

f1.close()

f2.close()

f3.close()

#Program 7
def Economic():

f1=open("items.dat","ab")

while True:

try:
 g=pickle.load(f1)

if(g['cost']<250):

print(g)

except:

break

Economic()

#OUTPUT

enter giftname flowers

enter id 2

enter cost 500

{'giftname': ' flowers', 'id': 2, 'cost': 500.0}

#Program 8
def search():

f2=open("tablet.dat","rb")

m=int(input("enter the model no which you want to search"))

print("\n records satisfy the condition are \n")

while True:

try:

g=pickle.load(f1)

if g[0]==m:

print(g)

except:

break

f2.close()

search()

#OUTPUT

enter how many records 1

enter modelno 2
enter RAM 94

enter hd 56

details beautiful brand new, gen 6 iPad

{‘how many records’: 1, ‘modelno’: 2, ‘RAM’: 94, ‘hd’: 56, ‘details’: ‘beautiful brand new, gen 6 iPad’}

#Program 9
f=open(r"C:\Users\user\Desktop\cs\networking\firewall.txt")

t=f.read()

c=0

for i in t.split():

if(i=='firewall')or (i=='is'):

c=c+1

print(c)

#OUTPUT

#Program 10
import csv

def writecsv():

f=open("product.csv","w")

r=csv.writer(f,lineterminator='\n')

r.writerow(['pid','pname','cost','qty'])

r.writerow(['p1','brush','50','200'])

r.writerow(['p2','toothbrush','120','150'])

r.writerow(['p3','comb','40','300'])

r.writerow(['p5','pen','10','250'])

def searchcsv():

f=open("product.csv","r")
 r=csv.reader(f)

next(r)

m=-1

for i in r:

if (int(i[2])>m):

m=int(i[2])

d=i

print(d)

writecsv()

searchcsv()

#OUTPUT

['p2', 'toothbrush', '120', '150']

#Program 11
f=open(r"C:\Users\hp\Desktop\cs\networking\firewall.txt")

c=0

for i in f.readline():

if(i=='F'):

c=c+1

print(c)

#OUTPUT

#Program 12
s=[]

def push():

a=int(input("enter ISBN no"))

t=input("enter title")
 l=[a,t]

s.append(l)

def disp(s):

if(s==[]):

print("list is empty")

else:

top=len(s)-1

print(s[top],"---top")

for i in range(top-1,-1,-1):

print(s[i])

push()

disp(s)

#OUTPUT

enter ISBN no 2

enter title Encyclopedia

[2, ' Encyclopedia’] ---top

#Program 13
s=[]

def pop():

if(s==[]):

print("stack is empty")

else:

Book_no,Book_title=s.pop()

print("element deleted")

def disp(s):

if(s==[]):

print("list is empty")

else:
 top=len(s)-1

print(s[top],"---top")

for i in range(top-1,-1,-1):

print(s[i])

pop()

disp(s)

#OUTPUT

stack is empty

list is empty

#Program 14
st=[]

def PUSH(Arr):

for i in Arr:

if(i%5==0):

st.append(i)

if(len(st)<0):

print(st)

else:

print("stack empty")

#OUTPUT

stack empty

#Program 15
def POP(Arr):

if(len(st)>0):

r=st.pop()

return r
 else:

print("stack empty")

#OUTPUT

Blank

#Program 16
List=[]

def add(List):

rno=int(input("Enter roll number"))

name=input("Enter name")

item=[rno,name]

List.append(item)

def pop(List):

if len(List)>0:

List.pop()

else:

print("Stack is empty")

def disp(s):

if(s==[]):

print("list is empty")

else:

top=len(s)-1

print(s[top],"---top")

for i in range(top-1,-1,-1):

print(s[i])

#Call add and pop function to verify the code

add(List)

add(List)

disp(List)
pop(List)

disp(List)

#OUTPUT

Enter roll number 1

Enter name reena

Enter roll number 2

Enter name teena

[2, 'teena'] ---top

[1, 'reena']

[1, 'reena'] ---top

#Program 17
#Program 18
#Program 19
import mysql.connector as m

db=m.connect(host="localhost",user="root",passwd="1234",database="Emgt")

c=db.cursor()

c.execute("select * from emp where sal>3000")

for i in r:

print(i)

#Program 20
import mysql.connector as m

db=m.connect(host="localhost",user="root",passwd="1234",database="Emgt")

c=db.cursor()

c.execute("update emp set sal=sal+300 where job=”clerk”)

db.commit()