XII- PYTHON RECORD PROGRAMS

 

LIST OF RECORD PROGRAMS

Program-1
Aim:

To write a python program  to search for a specific element using linear search

Source Code:

def LINEAR(a,key):

    for i in a:

        if i==key:

            print(key,"found at location",a.index(key))

            break

    else:

        print("Element not found")

a=eval(input("Enter the list of elements"))

key=eval(input("Enter the key to be searched"))

LINEAR(a,key)

Sample Output:

Program-2
Aim:

 To write a python program  to swap first half of the list with second half in a list

Source Code:

def SWAP(a):

    if len(a)%2==0:

        j=len(a)//2

    else:

        j=len(a)//2+1

    i=0

    while i<len(a)//2:

        a[i],a[j]=a[j],a[i]

        i+=1

        j+=1

    print("After swapping the list is",a)

a=eval(input("Enter the list of elements"))

SWAP(a)

Sample Output:

Program-3
Aim:

To write a python program  to find the largest in a given tuple(without max() function).

Source Code:

def Largest(a):

    lar=a[0]

    for i in a[1:]:

        if i>lar:

            lar=i

    print("Largest is ",lar)

a=eval(input("Enter a tuple"))

Largest(a)

Sample Output:

Program-4
Aim:

To write a python program  to check whether the inputted number is palindrome or not

Source Code:

def PALINDROME(n):

    temp=n

    r=0

    while n>0:

        d=n%10

        r=(r*10)+d

        n=n//10

    if temp==r:

        print(temp,"is palindrome")

    else:

        print(temp,"is not palindrome")

n=int(input("Enter a number"))

PALINDROME(n)

Sample Output:

Program-5
Aim:

To write a python program  to count vowels in an inputted string

Source Code:

def COUNT(a):

    c=0

    for i in a:

        if i in'aeiouAEIOU':

            c+=1

    print("Total number of vowels are",c)

a=input("Enter a string")

COUNT(a)

Sample Output:

Program-6
Aim:

To write a python program  to copy all the consonants from file1.txt to file2.txt

Source Code:

f1=open("file1.txt",'r')

f2=open("file2.txt",'w')

data=f1.read()

for i in data:

    if i not in 'AEIOUaeiou':

        f2.write(i)

f1.close()

f2.close()

Sample Output:

Program-7
Aim:

To write a python program  to print all the five letter words from text file File1.txt

Source Code:

f=open("file1.txt",'r')

c=0

data=f.read()

data=data.split()

print("Five letter words present in the text file are")

for i in data:

    if len(i)==5:

        print(i)

f.close()

Sample Output:

Program - 8

Aim:

To write a python program to count the occurrences of the words "Me" & "My" from text file File1.txt

Source Code:

f=open("file1.txt",'r')

c=0

data=f.read()

data=data.split()

for i in data:

    if i.lower()=="me" or i.lower()=="my" :

        c=c+1

print("No of occurrences of the words Me & My is", c)

f.close()

Sample Output:

Program-9
Aim:

To write a python program  to display all the lines starting with ‘I’ from text file File1.txt

Source Code:

f=open("file1.txt",'r')

data=f.readlines()

for i in data:

    if i[0]=='I':

        print(i,end='')

f.close()

Sample Output:

Program-10
Aim:

To write a python program  to display to write, read and display the content of a binary file

Source Code:

import pickle

f=open("Student.dat",'wb+')

n=int(input("Enter the number of students"))

rec=[]

for i in range(n):

    rno=int(input("Enter the rollno :"))

    name=input("Enter the student name :")

    marks=float(input("Enter the total marks in 500 :"))

    rec=[rno,name,marks]

    pickle.dump(rec,f)

f.seek(0)

try:

    while True:

        rec=pickle.load(f)

        print("The records are",end='')

        print(rec)

except EOFError:

    pass

f.close()

Sample Output:

Program-11
Aim:

To write a python program  to display to search and display the content of a binary file

Source Code:

import pickle

f=open("Student.dat",'wb+')

n=int(input("Enter the number of students"))

rec=[]

for i in range(n):

    rno=int(input("Enter the rollno :"))

    name=input("Enter the student name :")

    marks=float(input("Enter the total marks in 500 :"))

    rec=[rno,name,marks]

    pickle.dump(rec,f)

f.seek(0)

r=int(input("Enter the rollno to be searched"))

try:

    while True:

        rec=pickle.load(f)

        if r in rec:

            print(rec)

except EOFError:

    pass

f.close()

Sample Output:

Program-12
Aim:

To write a python program  to implement operations in a stack

Source Code:

a=[]

def PUSH():

    n=int(input("Enter the number of elements to be pushed"))

    for i in range(n):

        ele=int(input("Enter the element"))

        a.append(ele)

def POP():

    if len(a)==0:

        print("Underflow")

    else:

        print("Deleted element is",a.pop())

def DISPLAY():

    if len(a)==0:

        print("Underflow")

    else:

        print("Elements are",a[::-1])

PUSH()

POP()

DISPLAY()

Sample Output:

Program-13
Aim:

To write a python program  to implement operations in a queue

Source Code:

a=[]

def INSERT():

    n=int(input("Enter the number of elements to be added"))

    for i in range(n):

        ele=int(input("Enter the element"))

        a.append(ele)

def DELETE():

    if len(a)==0:

        print("Underflow")

    else:

        print("Deleted element is",a.pop(0))

def DISPLAY():

    if len(a)==0:

        print("Underflow")

    else:

        print("Elements are",a)

INSERT()

DELETE()

DISPLAY()

Sample Output:

Program-14
Aim:

To write a python program  to check whether an inputted number is prime or not

Source Code:

n=int(input("Enter the number"))

for i in range(2,n):

    if n%i==0:

        print(n,"is not prime")

        break

else:

        print(n,"is prime")

Sample Output:

Program-15
Aim:

To write a python program  to generate a random number between an upper limit and lower limit

Source Code:

import random

l=int(input("Enter the lower limit"))

u=int(input("Enter the upper limit"))

print(random.randint(l,u))

Sample Output:

Program-16

Aim:

To write a python program  to perform search and display operations in a CSV file.

Source Code:

import csv

student=[(1,'Lata',450),(2,'Anil',496),(3,'John',390)]

f=open('students.csv','a', newline='')

obj=csv.writer(f)

for stud in student:

    obj.writerow(stud)

f.close()

f=open('students.csv','r', newline='')

obj=csv.reader(f)

print("The details in the files are")

for i in obj:

    print(i)

f.close()

f=open('students.csv','r', newline='')

n=input("Enter the name to be searched")

obj=csv.reader(f)

for stud in obj:

    if n in stud:

        print("The details are")

        print (stud)

        break

else:

    print("Data is not available")

f.close()

Sample Output:

Program-17
Aim:

To write a Python-SQL connectivity program to create a database 'EMPLOYEE' , table 'DATA' using below information and display it.

EMPNO	EMPNAME	SALARY	EXPERIENCE
1	Ram	25000	5
2	'Rohith'	20000	4
3	'Ann'	35000	7
4	'Aman'	15000	2
5	'Ranjini'	26000	6

Source Code:

import mysql.connector

mydb=mysql.connector.connect(host="localhost",user="root",passwd="admin")

 mycursor=mydb.cursor()

 mycursor.execute("CREATE DATABASE EMPLOYEE")

 mycursor.execute("USE EMPLOYEE")

 mycursor.execute("CREATE TABLE DATA (EMPNO INT,EMPNAME CHAR(10),SALARY FLOAT,EXPERIENCE INT)")

 mycursor.execute("INSERT INTO DATA VALUES(1,'Ram',25000,5)")

 mycursor.execute("INSERT INTO DATA VALUES(2,'Rohith',20000,4)")

 mycursor.execute("INSERT INTO DATA VALUES(3,'Ann',35000,7)")

 mycursor.execute("INSERT INTO DATA VALUES(4,'Aman',15000,2)")

 mycursor.execute("INSERT INTO DATA VALUES(5,'Ranjini',26000,6)")

 mycursor.execute("SELECT * FROM DATA")

 for i in mycursor:

     print(i)

Sample Output:

Program-18
Aim:

To write a Python-SQL connectivity program to create a table to create a database 'EMPLOYEE' , table 'DATA' and search for a specific data from it.

EMPNO	EMPNAME	SALARY	EXPERIENCE
1	Ram	25000	5
2	'Rohith'	20000	4
3	'Ann'	35000	7
4	'Aman'	15000	2
5	'Ranjini'	26000	6

Source Code:

import mysql.connector

mydb=mysql.connector.connect(host="localhost",user="root",passwd="admin")

mycursor=mydb.cursor()

mycursor.execute("CREATE DATABASE EMPLOYEE")

mycursor.execute("USE EMPLOYEE")

mycursor.execute("CREATE TABLE DATA (EMPNO INT,EMPNAME CHAR(10),SALARY FLOAT,EXPERIENCE INT)")

mycursor.execute("INSERT INTO DATA VALUES(1,'Ram',25000,5)")

mycursor.execute("INSERT INTO DATA VALUES(2,'Rohith',20000,4)")

mycursor.execute("INSERT INTO DATA VALUES(3,'Ann',35000,7)")

mycursor.execute("INSERT INTO DATA VALUES(4,'Aman',15000,2)")

mycursor.execute("INSERT INTO DATA VALUES(5,'Ranjini',26000,6)")

mycursor.execute("SELECT * FROM DATA where EMPNO=2")

for i in mycursor:

          print(i)

Sample Output:

Program-19
Aim:

To write a Python-SQL connectivity program to create a database 'EMPLOYEE' , table 'DATA' and update data in it.

EMPNO	EMPNAME	SALARY	EXPERIENCE
1	Ram	25000	5
2	'Rohith'	20000	4
3	'Ann'	35000	7
4	'Aman'	15000	2
5	'Ranjini'	26000	6

Source Code:

import mysql.connector

mydb=mysql.connector.connect(host="localhost",user="root",passwd="admin")

mycursor=mydb.cursor()

mycursor.execute("CREATE DATABASE EMPLOYEE")

mycursor.execute("USE EMPLOYEE")

mycursor.execute("CREATE TABLE DATA (EMPNO INT,EMPNAME CHAR(10),SALARY FLOAT,EXPERIENCE INT)")

mycursor.execute("INSERT INTO DATA VALUES(1,'Ram',25000,5)")

mycursor.execute("INSERT INTO DATA VALUES(2,'Rohith',20000,4)")

mycursor.execute("INSERT INTO DATA VALUES(3,'Ann',35000,7)")

mycursor.execute("INSERT INTO DATA VALUES(4,'Aman',15000,2)")

mycursor.execute("INSERT INTO DATA VALUES(5,'Ranjini',26000,6)")

mycursor.execute("UPDATE DATA SET SALARY =SALARY+1000")

mycursor.execute("SELECT * FROM DATA")

for i in mycursor:

          print(i)

Sample Output:

Before Updation:

After Updation:

Program-20
Aim:

To write a Python-SQL connectivity program to create a database 'EMPLOYEE' , table 'DATA' and delete a specific record in it.

EMPNO	EMPNAME	SALARY	EXPERIENCE
1	Ram	25000	5
2	'Rohith'	20000	4
3	'Ann'	35000	7
4	'Aman'	15000	2
5	'Ranjini'	26000	6

Source Code:

import mysql.connector

mydb=mysql.connector.connect(host="localhost",user="root",passwd="admin")

mycursor=mydb.cursor()

mycursor.execute("CREATE DATABASE EMPLOYEE")

mycursor.execute("USE EMPLOYEE")

mycursor.execute("CREATE TABLE DATA (EMPNO INT,EMPNAME CHAR(10),SALARY FLOAT,EXPERIENCE INT)")

mycursor.execute("INSERT INTO DATA VALUES(1,'Ram',25000,5)")

mycursor.execute("INSERT INTO DATA VALUES(2,'Rohith',20000,4)")

mycursor.execute("INSERT INTO DATA VALUES(3,'Ann',35000,7)")

mycursor.execute("INSERT INTO DATA VALUES(4,'Aman',15000,2)")

mycursor.execute("INSERT INTO DATA VALUES(5,'Ranjini',26000,6)")

mycursor.execute("DELETE FROM DATA WHERE EMPNO=5")

mycursor.execute("SELECT * FROM DATA")

for i in mycursor:

            print(i)

Sample Output:

Before Deletion:

After Deletion: