Skip to content

Instantly share code, notes, and snippets.

@1ambda

1ambda/df-sql.py

Created December 26, 2021 05:51
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/ac1678485711f150af47143195a77a5f to your computer and use it in GitHub Desktop.
Save 1ambda/ac1678485711f150af47143195a77a5f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
df-sql.py
+-----+--------------------+--------------------+-------------+
| id| listing_url| name|property_type|
+-----+--------------------+--------------------+-------------+
| 360|https://www.airbn...|LoHi Secret garde...| Guesthouse|
| 590|https://www.airbn...|Comfortable - an...| House|
| 592|https://www.airbn...| private| House|
| 1940|https://www.airbn...|Baker Studio Clos...| Guesthouse|
| 2086|https://www.airbn...| Garden Level Condo| Apartment|
|31503|https://www.airbn...|Highland Park Gue...| Guest suite|
|39405|https://www.airbn...|LoHi Secret garde...| Cottage|
|56185|https://www.airbn...|charming home for...| House|
|59631|https://www.airbn...|VICTORIAN TOWNHOM...| Townhouse|
|74125|https://www.airbn...|Spacious Cap Hill...| Apartment|
+-----+--------------------+--------------------+-------------+
+----------+----------+---------+-------+--------------+--------------+--------------+
|listing_id| date|available| price|adjusted_price|minimum_nights|maximum_nights|
+----------+----------+---------+-------+--------------+--------------+--------------+
| 1153002|2019-11-29| f|$145.00| $145.00| 30| 60|
| 3138055|2019-11-29| f|$130.00| $130.00| 2| 1125|
| 3138055|2019-11-30| f|$130.00| $130.00| 2| 1125|
| 3138055|2019-12-01| t|$130.00| $130.00| 2| 1125|
| 3138055|2019-12-02| f|$130.00| $130.00| 2| 1125|
| 3138055|2019-12-03| f|$130.00| $130.00| 2| 1125|
| 3138055|2019-12-04| f|$130.00| $130.00| 2| 1125|
| 3138055|2019-12-05| f|$130.00| $130.00| 2| 1125|
| 3138055|2019-12-06| f|$130.00| $130.00| 2| 1125|
| 3138055|2019-12-07| f|$130.00| $130.00| 2| 1125|
+----------+----------+---------+-------+--------------+--------------+--------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment