Skip to content

README.md

Latest commit

 

History

History
60 lines (47 loc) · 1.84 KB

README.md

File metadata and controls

60 lines (47 loc) · 1.84 KB

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