New York City Airbnb Market Analysis

Introduction

Welcome to the New York City Airbnb Market Analysis project! This project aims to provide insights into the short-term rental market in New York City by analyzing Airbnb listing data from multiple sources. Our goal is to help a real estate start-up understand market trends, specifically focusing on private room listings.

---

Data Sources

The analysis is based on three datasets:

1. airbnb_price.csv: Contains data on listing prices and locations.
2. airbnb_room_type.xlsx: Contains data on listing descriptions and room types.
3. airbnb_last_review.tsv: Contains data on host names and review dates.

---

Objectives

1. Determine Review Dates: Identify the earliest and most recent review dates.
2. Count Private Rooms: Calculate the number of listings that are private rooms.
3. Calculate Average Price: Compute the average nightly price of listings.
4. Combine Insights: Aggregate the results into a single DataFrame for a comprehensive overview.

---

Approach

• Load and preprocess data from CSV, Excel, and TSV files.
• Extract and transform relevant information.
• Perform calculations to derive key metrics.
• Combine and present the results in a structured format.

By conducting this analysis, we provide valuable insights into the Airbnb market, helping the real estate start-up make informed decisions about short-term rentals in New York City.

---