What 218,812 Airbnb reviews talk about
A Python check and keyword scan of a large review dataset. It turns free text into a service-quality snapshot, with aggregate counts only.
- Question
- How can a large set of review text become a service-quality snapshot that a host team can trust?
- Data
- 218,812 reviews of 4,760 listings by 197,439 reviewers, 15 Feb 2010 – 10 Sep 2022.
- Method
- A Python script checks row counts, schema, dates, duplicate IDs and missing values. Then it counts reviews by listing, year and comment length, and scans the text for six keyword groups.
- ResultPublished
- No duplicate review IDs and no missing comments. Location, cleanliness, host contact and comfort are the strongest themes.
The data comes from a COMM 414 assignment. I made this analysis in July 2026; it is not the assignment that the group submitted. The scan is keyword-based and directional. It is not sentiment modelling or proof of customer retention. The page shows no raw comments or reviewer names.
Share of reviews that mention each theme
| Item | Value (%) |
|---|---|
| Location | 48.8 |
| Clean | 33.6 |
| Host | 31.95 |
| Comfort | 25.68 |
| Check-in | 10.1 |
| Value | 4.31 |
More work
- Stay for the exhale
I turned a yoga teacher's classes into a membership product. I did the strategy, the design, the build and the operations.
- A bank reconciliation that explains each difference
A working sample of the reconciliation method from my years as Operations & Finance Lead. Excel formulas match 119 bank lines to 121 ledger entries, explain each difference and reconcile to 0.00.
- SQL case studies: revenue share, donor segments and a 3NF schema
Three SQL studies on small course datasets. Each one starts with a business question. Every figure is query output that you can run again.