Update column value of the csv file using Python

Question

My question is: Once the customer selects the hotel, ask him the give feedback for the same and update the rating.csv file as per the data received.And how i update that given feed back to these file.

This is what I tried so far:

h_id=str(input("Enter Hotel_Id:"))
with open("rating.csv", "r") as fb:
    csvreader = csv.reader(fb, delimiter=",")
    for row in csvreader:
        if h_id in row[0]:
           print("Hotel Booked Sucessfully")
           f_back=float(input("Please Give Feedback of Hotel you selected outoff 5:"))

Thanks! Now I see what you want to do. What did you try so far? Can you post some code? — DavideBrex
– DavideBrex, Commented May 14, 2020 at 12:52

DavideBrex · Accepted Answer · 2020-05-14 13:33:25Z

1

I would do it in this way:

import pandas as pd

#read the hotels table
hotels = pd.read_csv("rating.csv")

h_id=str(input("Enter Hotel_Id:"))
f_back=float(input("Please Give Feedback of Hotel you selected outoff 5:"))

hotels.loc[hotels.Hotel == h_id,"no_of_feedback" ] = hotels.loc[hotels.Hotel == h_id,"no_of_feedback" ]+1
hotels.loc[hotels.Hotel == h_id,"Feedback" ] = f_back

#store updated table
hotels.to_csv("rating.csv")

answered May 14, 2020 at 13:33

DavideBrex

2,4241 gold badge14 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update column value of the csv file using Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related