[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 [Link] as plt

import csv

def menu():

print()

print("********************************")

print("This is hotel management system project ")

print("1. About the project")

print("[Link] all customers Details")

print("[Link] new customer detail using location")

print("4. Add new detail with input")

print("[Link] Details of customer detail with new column name")

print("[Link] customer detail by name ")

print("[Link] Type of rooms available")

print("8. Ask Customer Choice of room and calculate charges according")

print("[Link] increment ")

print("[Link] the charges in table laundry")

print("[Link] detail of items and charges in laundry")

print("[Link] Laundry Bill")

print("[Link] column address")

print("[Link] menu of Hotel")

print("[Link] details of food item available in Hotel")

print("[Link] 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("[Link]",index_col=0)

print(df)

def new_customer():

print("Adding New customer details in file ")

df=pd.read_csv("[Link]")

[Link]['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("[Link]",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="))

[Link][a]=[b,c,d,e,f]
 print(df)

def new colnam():

print("previous column name")

df=pd.read_csv("[Link]")

print(df)

print()

print("Display Details of customer with Names")

df=pd.read_csv("[Link]",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("[Link]",index_col=0)

df=[Link] values("name")

print(df)

def show roomtype():

print("Show type of room available")

df=pd.read_csv("[Link]",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("[Link] room Rupee 2000 per Night")

print("[Link] room rupee 3000 per Night")

print("3. Triple room Rupee 4000 per Night")

 print("[Link] 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("[Link]",index_col=0)

print(df)

print("Increase rent by rs. 500")

print()

df['Rent']+=500
 print(df)

def laundry():

df=pd.read_csv("[Link]",index_col=0)

print()

print(df)

def add_laundry():

print("Adding new items to be washed in file laundry ")

print()

df=pd.read_csv("[Link]")

[Link]['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("[Link] 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("[Link]")

print(df)

print()

del df['address']

print(df)

def add_resturant():

print("New dishes are ")

df=pd.read_csv("[Link]")
[Link]['7',:]=['7','juice',90]

print(df)

def show resturant():

print(' MENU')

df=pd.read_csv("[Link]",index_col=0)

print(df)

def res_bill():

print("All food item available")

df=pd.read_csv("[Link]",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

[Link](1000,500)
B
I
BLIOGRAPHY

 [Link]
 [Link]
 [Link]
 [Link]