Exploratory data analysis in Python - Step by step guide

  • Download New York Airbnb data from Kaggle.com.
  • Perform a complete EDA including all steps of the process.
  • Write down the conclusions of each step and analyze the results on the relationships between the variables.

🌱 How to start this project

Follow the instructions below:

  1. Create a new repository based on machine learning project by clicking here.
  2. Open the newly created repository in Codespace using the Codespace button extension.
  3. Once the Codespace VSCode has finished opening, start your project by following the instructions below.

🚛 How to deliver this project

Once you have finished solving the exercises, be sure to commit your changes, push to your repository and go to 4Geeks.com to upload the repository link.

📝 Instructions

Airbnb in New York

A company has collected New York housing rental data from the Airbnb app during 2019. This dataset was used to train Machine Learning models during that year, in an open competition.

We will now use it to conduct a study about the variables that make up the dataset in order to understand it and draw conclusions about it.

Step 1: Loading the dataset

You can download the dataset directly from Kaggle.com or from the following link: https://raw.githubusercontent.com/4GeeksAcademy/data-preprocessing-project-tutorial/main/AB_NYC_2019.csv. Store the raw data in the ./data/raw folder.

Step 2: Perform a complete EDA

This step is vital to ensure that we keep the variables that are strictly necessary and eliminate those that are not relevant or do not provide information. Use the example Notebook we worked on and adapt it to this use case.

Be sure to conveniently divide the data set into train and test as we have seen in the lesson.

Step 3: Save the processed dataset

After EDA you can save the data in the ./data/processed folder. Make sure to add the data folder in the .gitignore. The data as well as the models should not be uploaded to git.

NOTE: Solution: https://github.com/4GeeksAcademy/data-preprocessing-project-tutorial/blob/main/solution.ipynb