---
title: "Discussion on \"What I Learned Analyzing 20,000 Airbnb Listings\" | Hashnode"
description: "Discussion on \"What I Learned Analyzing 20,000 Airbnb Listings\". My first market analysis: capping price outliers, why location matters at neighbourhood not borough level."
url: "https://hashnode.com/posts/what-i-learned-analyzing-20-000-airbnb-listings/6ad0dc5cafbfd10d12158c93"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [What I Learned Analyzing 20,000 Airbnb Listings](https://beginnerslog.hashnode.dev/what-i-learned-analyzing-20-000-airbnb-listings?utm_source=hashnode&utm_medium=feed)

My first market analysis: capping price outliers, why location matters at neighbourhood not borough level.

Oct 15 · 5 min read · beginnerslog.hashnode.dev  
Read the article

-   [#python](https://hashnode.com/tag/python)
-   [#data-science](https://hashnode.com/tag/data-science)
-   [#airbnb](https://hashnode.com/tag/airbnb)
-   [#learninginpublic](https://hashnode.com/tag/learninginpublic)

## Written by

[Faith Mwende](https://hashnode.com/@mwendekiindu)

@mwendekiindu · Nairobi, Kenya

  
[View profile](https://hashnode.com/@mwendekiindu)

Learning in public, one post at a time.

Learning cloud and data science from zero. Writing what I learn so it sticks; the wins, the confusion, and everything in between.

## Responses 2

Markdown supported · ⌘↵ to post

[StackShortlist](https://hashnode.com/@veristria)

[Oct 17](https://hashnode.com/posts/what-i-learned-analyzing-20-000-airbnb-listings/6ad0dc5cafbfd10d12158c93/comment/6ad31a906293c02f94751d61)

The price cap table makes the point better than any explanation would. Median stuck at $125 while the mean dropped $27, so anyone quoting the uncapped mean would have overstated the typical night by a lot. Capping at the 99th percentile still removed 231 rows. Did any of those turn out to be real luxury listings rather than entry errors?

[Faith Mwende](https://hashnode.com/@mwendekiindu)

[Oct 18](https://hashnode.com/posts/what-i-learned-analyzing-20-000-airbnb-listings/6ad0dc5cafbfd10d12158c93/comment/6ad31a906293c02f94751d61#reply-6ad4be530be4dd6114d7d9f4)

Yes. A spot-check of the 197 listings priced above `$999` found that roughly half were plausibly legitimate luxury accommodations, including high-end condos, five bedroom properties, serviced apartments, and boutique hotels. However, around 10–15 appeared to be clear pricing errors or placeholders, such as private rooms listed at $100,000 per night. The rest were ambiguous. So, the cap did remove some genuine luxury listings, but it was intended to prevent extreme prices from distorting the mean not to imply that every outlier was erroneous....also the price cap removed 197 listings. Before that, 34 listings were dropped for missing price data (7 of which also lacked location), since they could not contribute to a price analysis.