Skip to content

Instantly share code, notes, and snippets.

@1ambda

1ambda/df-sql-join.py

Created December 26, 2021 05:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 1ambda/abf964f1474fa9d09bd4012c1b96b5b2 to your computer and use it in GitHub Desktop.
Save 1ambda/abf964f1474fa9d09bd4012c1b96b5b2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
df-sql-join.py
# dfListingAvailability.orderBy(desc("count_date_unavailable")).show()
+----------+--------------------+--------------------+--------------------+-------------------+--------------------+----------------------+
|listing_id| listing_url| listing_name|review_scores_rating|listing_price_basic|count_date_available|count_date_unavailable|
+----------+--------------------+--------------------+--------------------+-------------------+--------------------+----------------------+
| 19699920|https://www.airbn...|One bedroom in an...| 97| $80.00| 0| 366|
| 23418604|https://www.airbn...|Bright & Cozy Apt...| 100| $115.00| 0| 366|
| 24306031|https://www.airbn...|Historic Duplex L...| null| $88.00| 0| 366|
| 37912396|https://www.airbn...|Happy Travelers W...| 100| $75.00| 0| 366|
| 19154631|https://www.airbn...|Newly Remodeled H...| 100| $175.00| 0| 366|
| 11533087|https://www.airbn...|Beautiful Home by...| 96| $225.00| 0| 366|
| 18503556|https://www.airbn...|Spacious Studio i...| 100| $119.00| 0| 366|
| 20425070|https://www.airbn...|Location, locatio...| 91| $150.00| 0| 366|
| 39309393|https://www.airbn...|Guest suite Denve...| null| $80.00| 0| 366|
| 14154970|https://www.airbn...|Best Location! Gr...| 99| $229.00| 0| 366|
| 27332948|https://www.airbn...|Cozy Modern Bedro...| 100| $48.00| 0| 366|
| 12172692|https://www.airbn...|Open, bright, mou...| 93| $145.00| 0| 366|
| 32017055|https://www.airbn...|⭐️ Private & Cent...| 99| $49.00| 0| 366|
| 27422441|https://www.airbn...|Friendliest Place...| 100| $101.00| 0| 365|
| 27759634|https://www.airbn...|Cozy Room in Down...| 100| $55.00| 0| 365|
| 19752351|https://www.airbn...|Beautiful townhom...| null| $150.00| 0| 365|
| 27259874|https://www.airbn...|Shared Denver Hou...| 87| $77.00| 0| 365|
| 36149907|https://www.airbn...| The Nest 2.0| 100| $90.00| 0| 365|
| 11509014|https://www.airbn...|Garden Suite - Bo...| 100| $80.00| 0| 365|
| 21781844|https://www.airbn...| Beats Motel| null| $30.00| 0| 365|
+----------+--------------------+--------------------+--------------------+-------------------+--------------------+----------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment