A new fancy hotel has requested your help to build a system to manage guests’ reservations. The hotel has 6 categories of rooms. Additionally, the rooms vary in capacity. The price for each room depends on the type, capacity, and number of nights. Your program will handle both making new reservations and checking out.

- Guests should be asked if they would like to make a new reservation or check out of their current room.
- Your program will ask each guest who wishes to make a new booking the details of their reservation then check availability. If there are rooms available, a booking will be placed in the system.
- When a guest makes a reservation or checks out, the system needs to be updated to reflect the current availability of rooms.
- At the end of the day, a summary must be generated for the management.

Your program must use loops, lists, functions, and files in order to work correctly.

**Instructions:**

1. Begin with a text file called `room_details.txt`, which will contain the details for the rooms offered by the hotel. Each line in the file will represent a room category and is formatted as follows:

`"Category name", number of rooms, capacity, price per night, price per 7 nights, price per 30 nights, number of rooms occupied`

An example of a line in the file:

`"Wonderful",20,2,1200,8000,30000,2`

Notice that each detail is separated by a comma.

2. You will need to create a function called `LoadDetails` which reads each line from the text file into a multidimensional list. The function needs to separate the details in each line so that the data can be used by your system.

3. Use a loop to handle each request since there is no way to know exactly how many guests will interact with the system. When there are no more guests to be processed, the user needs to enter the letter `q` to stop asking for more details.

4. Create a function called `CheckAvailability` that will check if a particular room is available. This function must accept three input parameters called `roomData`, `category`, and `numberOfGuests`. The function will use the data provided to check the category and capacity, then return `True` if a room is available, or `False` if not. `CheckAvailability` will also return the index location of the room that is a match.

5. Create a function `CalculatePrice` which will calculate the price of the guest’s reservation. You will notice that each room category and size have different rates depending on the duration of the booking. This needs to be taken into account when calculating the final price. This function must accept three input parameters called `roomData`, `durationOfStay`, and `roomIndex`. This function must then return the calculated price.

6. Create a function called `CreateSummary` which generates a summary of the availability of the rooms. This function must accept an input parameter called `roomData`. The summary must display the following information for each type of room:

- Category name
- Number of rooms occupied

7. Create a function called `UpdateTextFile` which will save all the updated information into the text file called `room_details.txt`. This update will replace the old information so that the new data will be loaded when the program runs again.

It is extremely important that the system is implemented as specified, meaning that all names must be exactly as required. Your system must also check that the correct information is entered by the user so that the program functions as intended.

**Please see the following output example before starting the program.**

Note: Need this program in Python. Thank you!