Scribd Logo
Upload

Welcome to Scribd!

  • 37 views

    Term Project - Python

    Uploaded by

    Davith Chien
    This document describes a final project analyzing hotel booking data. The project aims to analyze customer behavior, products and services, and sales and marketing. The data contains over 100,000 rows with information on bookings, guests, rooms, and transactions. Key findings will include popular months, guest nationalities, preferred meals and rooms, price variations, booking and cancellation trends, and effective market segments. Graphs and tables will be used to summarize insights from the data analysis. The conclusion will highlight main results regarding customer behavior, products/services, and sales/marketing.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Term Project - Python

    Uploaded by

    Davith Chien
    37 views27 pages
    This document describes a final project analyzing hotel booking data. The project aims to analyze customer behavior, products and services, and sales and marketing. The data contains over 100,000 rows with information on bookings, guests, rooms, and transactions. Key findings will include popular months, guest nationalities, preferred meals and rooms, price variations, booking and cancellation trends, and effective market segments. Graphs and tables will be used to summarize insights from the data analysis. The conclusion will highlight main results regarding customer behavior, products/services, and sales/marketing.

    Original Title

    Term Project _ Python

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document describes a final project analyzing hotel booking data. The project aims to analyze customer behavior, products and services, and sales and marketing. The data contains over 100,000 rows with information on bookings, guests, rooms, and transactions. Key findings will include popular months, guest nationalities, preferred meals and rooms, price variations, booking and cancellation trends, and effective market segments. Graphs and tables will be used to summarize insights from the data analysis. The conclusion will highlight main results regarding customer behavior, products/services, and sales/marketing.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    37 views27 pages

    Term Project - Python

    Uploaded by

    Davith Chien
    This document describes a final project analyzing hotel booking data. The project aims to analyze customer behavior, products and services, and sales and marketing. The data contains over 100,000 rows with information on bookings, guests, rooms, and transactions. Key findings will include popular months, guest nationalities, preferred meals and rooms, price variations, booking and cancellation trends, and effective market segments. Graphs and tables will be used to summarize insights from the data analysis. The conclusion will highlight main results regarding customer behavior, products/services, and sales/marketing.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 27

    Department of Civil Engineering

    ENGR 231 : Introduction To Programming

    Final Project-Semester I

    Hotel Booking

    Davith Chien
    CONTENTS

    ABSTRACT DATA DESCRIPTION MOTIVATION CONCLUSION

    Get to know what What we discover Our assumption Outcome Summary


    we’re studying through the data and idea how we Action Step toward
    about can utilize this data data analysis
    ABSTRACT
    Here is our study on the data that provided by
    a hotel that located in city and resort. With all
    the data that have given, we decided to
    analyze on our customer behaviour, our
    product and services as well as our sale and
    marketing.

    As a result, we can get to know which month


    has highest guests, guests’ nationalities, most
    preferred meal and room type, rooms’ price in
    each month, total booking and cancellation,
    and market segment depending on room types.
    DATA DESCRIPTION
    1. There are 119390 rows x 32 columns.
    2. The columns in the dataset:
    ● Hotel ● babies
    ● Is canceled ● Meal
    ● Arrival date year ● County
    ● Arrival date month ● Market segment
    ● Arrival date week number ● Assigned room type
    ● Arrival date day of months ● Deposit type
    ● Stays in weekend nights ● Agent
    ● Stays in week nights ● Company
    ● Adults ● Adr
    ● Children ● Total of special requests, etc.
    MOTIVATION

    Customer Behaviour Product & Services Sale & Marketing

    - Popular coming month - Most preferred room - Effective market


    - Nationalities - Highest & Lowest segments
    - Meal preferences price of room
    - Number of Booking
    and Cancellation
    CUSTOMER
    BEHAVIOUR
    WHICH IS THE BUSIEST MONTH?

    Select only guest


    Plot it into a
    Clean the data who stay (not
    graph
    cancel)

    Select months
    Combine the
    with number of
    data of both
    guests who
    types of hotel
    stayed
    WHERE DOES ALL THE CUSTOMER COME FROM?

    Select only guest


    Clean the data
    who stay

    Count the
    number of Plot it into a
    guests in each graph
    country
    WHAT IS THE MOST PREFERRED MEAL IN EACH
    TYPES OF HOTEL?

    Count # guest
    Get rid of any guest Who ordered
    Data Cleaning
    who canceled booking different meals
    in each hotel

    Display its Group both “hotel”


    output in Pie and “meal”,
    Chart
    PRODUCT
    AND SERVICES
    WHAT IS THE NUMBER OF
    TOTAL BOOKING AND TOTAL CANCELLATION?

    “0” is the stay,


    Count the
    while “1” is the
    Total Booking
    cancellation

    Count the
    “is_canceled” = 1
    WHICH ROOM TYPES ARE MOSTLY
    PREFERRED IN EACH HOTEL?

    Count # of guests Group” hotel “


    Display its
    stay in each room with”assigned_room_ty
    outcome as
    types for each pe “ for each assigned
    dataframe
    hotel room types counts.

    Convert it into Pie


    Chart
    WHAT ARE THE HIGHEST AND THE LOWEST ROOMS’
    PRICE IN EACH MONTH ?

    Sort Month for both Merge both adr_resort


    Clean the data
    types of hotel and adr_city

    Display it in
    graph
    SALE AND
    MARKETING
    WHICH ARE OUR TARGET MARKET SEGMENTS
    DEPENDING ON ROOM TYPES ?

    Select only guest Plot cleaned data into


    Data Cleaning who stay bar plotting

    Display ‘y=adr’,
    and ‘x=market
    segment’
    CONCLUSION
    ❖ Customer Behaviour
    ➢ Busiest Time
    ➢ Nationalities
    ➢ Meals

    ❖ Product And Services


    ➢ Room types
    ➢ Highest and lowest rooms’ price in each month
    ➢ Booking and Cancellation

    ❖ Sale and Marketing


    ➢ Effective market segments
    REFERENCE

    Data Analysis Real world use-cases- Hands on Python. (2021).


    Retrieved 19 February 2022, from
    https://www.udemy.com/course/data-analysis-real-world-use-cases-h
    ands-on-python

    You might also like