Cleaned Airbnb Listings Dataset

This dataset contains a cleaned and pre-processed version of the publicly available Airbnb Listings dataset originally published on Kaggle. The raw dataset is available from:

Airbnb Listings (Kaggle):https://www.kaggle.com/datasets/ulrikthygepedersen/airbnb-listings

The original dataset is licensed under Creative Commons Attribution 4.0 (CC BY 4.0), which permits sharing, adaptation, and redistribution with attribution. This cleaned dataset is a derived work and continues to follow the CC BY 4.0 licensing requirements.

Purpose of This Cleaned Dataset

The goal of this dataset is to provide a well-structured, analysis-ready version of the original Airbnb listings data. It was created as part of a data-cleaning and analysis workflow for a practical portfolio project involving Python, SQL, and visualisation tools.

The cleaned dataset is intended for:

Exploratory data analysis (EDA)

Machine learning or statistical modelling

Data visualisation projects

Demonstrating real-world data cleaning workflows

Teaching or portfolio examples

Cleaning and Transformation Steps

The following steps were applied to prepare the dataset for analysis:

1. Data Type Standardisation

Converted host_since to datetime format

Normalised boolean-like fields (e.g., t/f, yes/no) into proper Boolean types

Treated categorical text fields appropriately

2. Missing Value Handling

Imputed missing bedroom values using the median per property type

Created a has_reviews flag for entries with missing review scores

Preserved NA values in cases where imputation would distort meaning

3. Amenities Processing

Cleaned and standardised amenity strings

Extracted amenity indicators (e.g., WiFi)

Created an amenities_count feature

4. Column Normalisation and Cleanup

Removed unused or low-utility fields (e.g., district)

Standardised formatting for categorical and text fields

Relationship to Original Dataset

This cleaned dataset is derived from the Kaggle dataset listed above.Users wishing to reproduce the cleaning process should download the raw dataset from Kaggle and place it into the appropriate directory as described in the accompanying GitHub repository.

Associated GitHub Repository

The complete cleaning workflow, code, and project context are available here:

GitHub Repository:https://github.com/stephenjpdelta/portfolio-2025

License

This derived dataset is released under the CC BY 4.0 license, consistent with the original data.Users should attribute the data creator as:

Airbnb Listings dataset by Ulrik Thyge Pedersen, used under CC BY 4.0.