CBSE COMPUTER SCIENCE
Ir al canal en Telegram
QUESTION BANK, REFERENCE BOOK, LAB MANUAL , WORKSHEET ETC., PYTHON TEXT BOOK AND REFERENCE BOOKS, 01. ASK QUESTIONS AT https://t.me/joinchat/FJ1noGs-64I0OWI1
Mostrar más549
Suscriptores
Sin datos24 horas
Sin datos7 días
Sin datos30 días
Archivo de publicaciones
CS
Python Basics 1 : https://forms.gle/M6dDNphiHh4bRgxs8
Python Basics 2 : https://forms.gle/dUxG6ZHHXYknNLxS6
Python Basics 3 : https://forms.gle/jo5emGGiMy6Pwhft8
Python Basics 4 : https://forms.gle/APYRruoMjMszWr1Q6
Functions 1 : https://forms.gle/xoV6fstREXndY3CG8
Functions 2 : https://forms.gle/FFcMpV2ERrCNenK46
List : https://forms.gle/KdV4iz8Y765Z27Fc7
String : https://forms.gle/Te8nzz3iPcTHppji6
Tuple : https://forms.gle/iGd6KudqwmZSRzWi6
Dictionary : https://forms.gle/uUqc8vZdrc6FzgSG8
Data Structure 1 : https://forms.gle/BLob2Y7hxqKBszk28
Data Structure 2 : https://forms.gle/SSe8pJhpVberpZ7A9
Computer Networks 1 : https://forms.gle/PBYLuAKzRmZ7r9Rw7
Computer Networks 2 : https://forms.gle/nRWNqGaW6xFRMHiB6
Computer Networks 3 : https://forms.gle/gXHErV2oXfscFycq7
Binary File : https://forms.gle/yVaV2GhSEwKvu4w88
PT2 : https://forms.gle/uisopa6KWnHBuCAXA
Sample QP : https://forms.gle/TQLs5f7BNGP5hXi86
Online Class : https://forms.gle/AtYV6o2pmCJFE2Wr9
import pickle
def writedata( ):
list =[ ]
while True:
roll = input("Enter student Roll No:")
sname = input("Enter student Name :")
student = {"roll":roll,"name":sname}
list.append(student)
choice= input("Want to add more record(y/n) :")
if(choice=='n'):
break
file = open("student.dat","wb")
pickle.dump(list,file) #list of dictionary dumped only once in file as now dictionary is appended inside the list
file.close( )
def readdata( ):
file = open("student.dat", "rb")
list1 = pickle.load(file)
print(list1)
for i in list1:
print(i['roll'],i['name'])
file.close()
def search():
file = open("student.dat", "rb")
list1 = pickle.load(file)
pname=input("enter the name to be searched:")
for i in list1:
if (i['name']==pname):
print("record found!")
print("rollno=",i['roll'],"name=",i['name'])
break
else:
print("not found!")
print("Press-1 to write data and Press-2 to read data Press 3 to search record ")
choice=int(input( "enter choice:"))
if choice==1:
writedata()
elif choice==2:
readdata()
elif choice==3:
search()
else:
print("You entered invalid value")
#Write a program to insert, display and search a number in a binary file. If number is not found then display appropriate message.
#single list program
import pickle
def write():
f=open("sample.dat",'wb')
rec=[3,5,7,2,6,7,1] #pre-defined list
#user input code below
'''
while True:
x=int(input("enter value:"))
rec.append(x)
ch=input("enter more?:")
if(ch=='n'):
break
'''
pickle.dump(rec,f) # entire list written to file once
print("added")
f.close()
def read():
print("reading...")
f=open("sample.dat",'rb')
p=pickle.load(f)
print(p)
f.close()
def search():
print("searching....")
f=open("sample.dat",'rb')
found=0
x=int(input("enter the number you want to search:"))
rec=pickle.load(f)
print(rec)
for R in rec:
if x==R:
found=1
print("record found")
break
if(found==0):
print("record not found")
f.close()
print("*"*20,"MENU","*"*20)
print("1.write\n2.read\n3.search")
choice=int(input("enter your choice:"))
if(choice==1):
write()
elif choice==2:
read()
elif choice==3:
search()
else:
print("invalid input")
-------------------------------------------------------------------------------
#Write a program to search a record using its roll number and display the name of student. If record not found then display appropriate message.
#nested list
import pickle
def write():
f=open("sample.dat",'wb')
rec=[[1,'sakshi',45],[2,'kiara',66],[3,'inaya',47],[4,'anjali',76]] #pre-set list
pickle.dump(rec,f)
print("added")
f.close()
def read():
print("reading...")
f=open("sample.dat",'rb')
p=pickle.load(f)
#print(p) # will print the nested list
#display element by element
print("rno name marks")
for i in p:
print(" ",i[0],i[1]," ",i[2])
f.close()
def search():
print("searching....")
f=open("sample.dat",'rb')
found=0
x=int(input("enter the rno you want to search:"))
rec=pickle.load(f)
#print(rec) #... will print nested list
for i in rec:
if x==i[0]:
found=1
print("record found")
print("name=",i[1],"marks=",i[2])
break
if(found==0): print("record not found")
f.close()
print("*"*20,"MENU","*"*20)
print("1.write\n2.read\n3.search")
choice=int(input("enter your choice:"))
if(choice==1):
write()
elif choice==2:
read()
elif choice==3:
search()
else:
print("invalid input")
----------------------------------------------------------------------------------------------------
#Write a program to write and display the contents of a dictionary into a binary file.
#only dictionary but multiple records
import pickle
def write():
f=open("maps.dat","ab")
ch="y"
while ch == "y":
r=int(input("input enter rno "))
s=input("enter name ")
m=int(input("input enter marks "))
d={"rno":r,"name":s,"MARKS":m}
pickle.dump(d,f) # only 1 record dumped in file.loop repeats, next dumped.
# dictionaries dont have append() function, so each record needs to be written separately #using loop
ch=input("want to enter more rec ")
f.close()
def read():
f=open("maps.dat","rb")
d={}
try:
while True: # as long as there is data in the file
d=pickle.load(f)
print(d['rno'],':',d['name'])
#print(d)
except EOFError:
f.close()
write()
read()
-------------------------------------------------------------------
#WAP to read,write and seach a record in a binary file using list of dictionaries.
#binary file - list of dictionary
t1="Ind-23"
t2=""
i=1
while i<len(t1):
if t1[i]>="0" and t1[i]<="9": #50>=48 and 50<=57 51>=48 and 51<=57
val=int(t1[i])
val=val+2
t2=t1+str(val)
#print(t1,val,t2)
elif t1[i]>"A" and t1[i]<="Z":
t2=t2+(t1(i+1))
else:
t2=t2+"*"
i+=1
print(t2)
#A=65 a=97 0=48
import mysql.connector as mcr
cn=mcr.connect(host='localhost',user='root',passwd='Admin')
cr=cn.cursor()
#Create and Use Database
cr.execute('create database if not exists TEST')
cr.execute('use TEST')
#Create Table
cr.execute('create table if not exists member(M_ID char(5),Name Varchar(30),Activity varchar(10))')
#Inserting Records
qry="insert into member values('M1001','Amina','Gym'),('M1002','Pratik','Gym')\
,('M1003','Simon','Swimming'),('M1004','Rakesh','Gym'),('M1005','Avneet','Swimming')"
cr.execute(qry)
cr.execute('Select * from member where activity="Gym"')
R=cr.fetchone()
#print(R)
for i in range(2):
R=cr.fetchone()
print(R[0],R[1],sep='#')
'''
M1002#Pratik
M1004#Rakesh
'''
CS
Python Basics 1 : https://forms.gle/M6dDNphiHh4bRgxs8
Python Basics 2 : https://forms.gle/dUxG6ZHHXYknNLxS6
Python Basics 3 : https://forms.gle/jo5emGGiMy6Pwhft8
Python Basics 4 : https://forms.gle/APYRruoMjMszWr1Q6
Functions 1 : https://forms.gle/xoV6fstREXndY3CG8
Functions 2 : https://forms.gle/FFcMpV2ERrCNenK46
List : https://forms.gle/KdV4iz8Y765Z27Fc7
String : https://forms.gle/Te8nzz3iPcTHppji6
Tuple : https://forms.gle/iGd6KudqwmZSRzWi6
Dictionary : https://forms.gle/uUqc8vZdrc6FzgSG8
Data Structure 1 : https://forms.gle/BLob2Y7hxqKBszk28
Data Structure 2 : https://forms.gle/SSe8pJhpVberpZ7A9
Computer Networks 1 : https://forms.gle/PBYLuAKzRmZ7r9Rw7
Computer Networks 2 : https://forms.gle/nRWNqGaW6xFRMHiB6
Computer Networks 3 : https://forms.gle/gXHErV2oXfscFycq7
Binary File : https://forms.gle/yVaV2GhSEwKvu4w88
PT2 : https://forms.gle/uisopa6KWnHBuCAXA
Sample QP : https://forms.gle/TQLs5f7BNGP5hXi86
Online Class : https://forms.gle/AtYV6o2pmCJFE2Wr9
