[Date]
Ashish Chand
[COMPANY NAME]
The Cambridge international
school
IP PROJECT FILE
NAME – AKRITI SHARMA, TANISHA
CHAUDHARY, RITIKA RANI
CLASS - 12 A
ROLL NO –
SUBJECT- INFORMATICS PRACTICES
SUBMITTED TO – MRS. ALKA MAM
Certificate
This is to certify Akriti sharma, Tanisha
Chaudhary, Ritika rani of class 12 A has
successfully completed her project work on
“Hotel Management” in informatics practices
(065) and hereby submitting her report as
evidence of the project work for the session
2021-2022.
Teacher’s
signature
_______________
Acknowledgement
We would like to express our special thanks of
gratitude to our IP teacher “Mrs Alka Mam” for
their able guidance and support in completing
our project.
we would also like to extend our gratitude to the
Principal Mam “Mrs. Neelam Singh” for
providing us with all the facility that was
required.
Date: Akriti
sharma,
Tanisha
Chaudhary,
Ritika rani
12- ‘A’
HOTEL MANAGEMENT
import pandas as pd
import matplotlib.pyplot as plt
import csv
def menu():
print()
print("********************************")
print("This is hotel management system project ")
print("1. About the project")
print("2.Show all customers Details")
print("3.Add new customer detail using location")
print("4. Add new detail with input")
print("5.Show Details of customer detail with new column name")
print("6.Short customer detail by name ")
print("7.Show Type of rooms available")
print("8. Ask Customer Choice of room and calculate charges according")
print("9.Rent increment ")
print("10.List the charges in table laundry")
print("11.Add detail of items and charges in laundry")
print("12.Show Laundry Bill")
print("13.Delete column address")
print("14.Show menu of Hotel")
print("15.Add details of food item available in Hotel")
print("16.Hotel bill")
print("*******************************************************************************************")
menu()
def about():
print(" This project is Developed by TANISHA CHOUDHARY on HOTEL MANAGEMENT
SYSTEM .......It contain 16 option..In this project 4 csv files are used
Customers,roomtype,laundry,resturants")
def no_index():
print("Display Customer details without index")
print()
df=pd.read_csv("Tanisha.csv",index_col=0)
print(df)
def new_customer():
print("Adding New customer details in file ")
df=pd.read_csv("Tanisha.csv")
df.at['4',:]=['Geeta','50,karol bagh','8860671794','18-06-2020','22-06-2020','4']
print(df)
def new cust():
print("Adding new customer in file")
df=pd.read_csv("Tanisha.csv",index_col=0)
print(df)
a=input("Enter the name of the customer=")
b=input("Enter address=")
c=int(input("Enter mobile number="))
d=input("Enter the date of check in=")
e=input("Enter the date of check out=")
f=int(input("Enter the duration of stay="))
df.loc[a]=[b,c,d,e,f]
print(df)
def new colnam():
print("previous column name")
df=pd.read_csv("Tanisha.csv")
print(df)
print()
print("Display Details of customer with Names")
df=pd.read_csv("Tanisha.csv",skiprows=1,names=['customer name','Residence','Day of
arrival','Day of departure','stay'])
print(df)
def sort customer():
print("Sorting customer name and details in ascending order")
df=pd.read_csv("Tanisha.csv",index_col=0)
df=df.sort values("name")
print(df)
def show roomtype():
print("Show type of room available")
df=pd.read_csv("roomtype.csv",index_col=0)
print("Without index")
print(df)
def roomrent():
print("Room includes:1 double bed,Television,1 double door cupboard ,1 coffee table with 2
sofa ,bedroom attached washroom with hot/cold water")
print("************ we have the following room for you:")
print("1.Single room Rupee 2000 per Night")
print("2.double room rupee 3000 per Night")
print("3. Triple room Rupee 4000 per Night")
print("4.King room rupee 6000 per night")
x=int(input("Enter your choice Please="))
n=int(input("For how many night did you stay="))
if(x==1):
print("You have chosen single room")
s=2000*n
elif(x==2):
print("You have chosen double room")
s=3000*n
elif(x==3):
print("you have chosen triple room ")
s=4000*n
elif(x==4):
print("You have chosen king Room ")
s=6000*n
else:
print("Please choose a room")
print("Your room rent is =",s,"\n Thank you visit again")
def rent int():
print("previous Rent of rooms")
print()
df=pd.read_csv("roomtype.csv",index_col=0)
print(df)
print("Increase rent by rs. 500")
print()
df['Rent']+=500
print(df)
def laundry():
df=pd.read_csv("laundry.csv",index_col=0)
print()
print(df)
def add_laundry():
print("Adding new items to be washed in file laundry ")
print()
df=pd.read_csv("laundry.csv")
df.at['7',:]=['7','Gents suit',300]
print(df)
def lbill():
print("we change the following rate for laundry ")
print("1. shirt Rupees 75 1 piece ")
print("2.Trouser rupee 100 1 piece ")
print("3. Ladies suits rupee 150 1 piece ")
print("4. saree rupee 200 1 piece")
print("5. Other rupee 200 1 piece")
x=int(input(" Enter your choice of cloth please="))
n=int(input(" How many pieces you want to get washes="))
if(x==1):
print("you want to get shirt washed")
s=75*n
elif(x==2):
print("you want to get trouser washed")
s=100*n
elif(x==3):
print("you want to get ladies suit washed")
elif(x==4):
print("you want to get saree washed")
s=200*n
elif(x==5):
print("you want to get other cloth washed")
s=200*n
else:
print("Please choose the piece of cloth")
print("Your laundry charges are =",s,"\n")
def delete col():
print("Delete column address from customers")
print()
df=pd.read_csv("Tanisha.csv")
print(df)
print()
del df['address']
print(df)
def add_resturant():
print("New dishes are ")
df=pd.read_csv("Resturant.csv")
df.at['7',:]=['7','juice',90]
print(df)
def show resturant():
print(' MENU')
df=pd.read_csv("Resturant.csv",index_col=0)
print(df)
def res_bill():
print("All food item available")
df=pd.read_csv("Resturant.csv",index_col=0)
print(df)
c=int(input("order Your item no."))
d=int(input("Enter the quantity"))
if(c==1):
s=20*d
elif(c==2):
s=10*d
elif(c==3):
s=250*d
elif(c==4):
s=150*d
elif(c==5):
s=75*d
elif(c==6):
s=90*d
else:
print("invalid option")
print("Total Food Bill is Rs=",s,"\n")
opt=" "
opt=int(input("Enter your choice="))
if opt==1:
about()
elif opt==2:
no_index()
elif opt==3:
new_customer()
elif opt==4:
new_cust()
elif opt==5:
new_colnam()
elif opt==6:
sort_customer()
elif opt==7:
show_roomtype()
elif opt==8:
roomrent()
elif opt==9:
rent_int()
elif opt==10:
laundry()
elif opt==11:
add_laundry()
elif opt==12:
lbill()
elif opt==13:
delete_col()
elif opt==14:
show
resturant()
elif opt==15:
add_restura
nt()
elif opt==16:
res bill()
import winsound
winsound.Beep(1000,500)
B
I
BLIOGRAPHY
www.slideshare.com
www.tutorialalaicsip
https://unacademy.com
https://thedarshika.com
