Python_Project-Hotel_Data_Analytics

Problem Statement

AtliQ Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, AtliQ Grands are losing its market share and revenue in the luxury/business hotels category.

Task :

Retrieve the data within a Jupyter Notebook and conduct an analysis through pandas

1. Understanding business problems

2. Data collection and understanding

• Reading files

3. Data cleaning and Exploration

• Clean invalid guests
• Outlier removal in revenue generated

4. Data transformation

• Create occupancy percentage column

5. Collect insights

• Average occupancy rate in each of the room categories
• Print average occupancy rate per city
• When was the occupancy better? Weekday or Weekend?
• In the month of June, what is the occupancy for different cities?
• We got new data for the month of august. Append that to existing data
• Print revenue realized per city
• Print month by month revenue
• Print revenue realized per hotel type
• Print average rating per city
• Print a pie chart of revenue realized per booking platform

key Learnings :

1. Python basics :

• Variables
• Numbers
• String
• Lists
• If condition
• For loop
• Functions
• Dictionary
• Tuples
• Modules and pip : Matplotlib for creating visuals
• File handling
• classes & Objects
• Inheritance
• Exception handling

2. Pandas basics :

• Read Excel & CSV files
• Handle NA values
• Group by
• Concat and Merge
• Dataframe functions: shape, columns, apply, set_index, loc, iloc, describe
• Column level functions: unique, value_counts, max, min