df-listing.py

# dfListing.printSchema()
root
 |-- id: integer (nullable = true)
 |-- listing_url: string (nullable = true)
 |-- scrape_id: long (nullable = true)
 |-- last_scraped: string (nullable = true)
 |-- name: string (nullable = true)
 |-- summary: string (nullable = true)
 |-- space: string (nullable = true)
 |-- description: string (nullable = true)
 |-- experiences_offered: string (nullable = true)
 |-- neighborhood_overview: string (nullable = true)
 |-- notes: string (nullable = true)
 |-- transit: string (nullable = true)
 |-- access: string (nullable = true)
 |-- interaction: string (nullable = true)
 |-- house_rules: string (nullable = true)
 |-- thumbnail_url: string (nullable = true)
 |-- medium_url: string (nullable = true)
 |-- picture_url: string (nullable = true)
 |-- xl_picture_url: string (nullable = true)
 |-- host_id: integer (nullable = true)
 |-- host_url: string (nullable = true)
 |-- host_name: string (nullable = true)
...

# dfListing\
#    .select("id", "listing_url", "name", "description", "property_type", "city", "review_scores_rating", "price")\
#    .show()
+------+--------------------+--------------------+--------------------+-------------+---------+--------------------+-------+
|    id|         listing_url|                name|         description|property_type|     city|review_scores_rating|  price|
+------+--------------------+--------------------+--------------------+-------------+---------+--------------------+-------+
|   360|https://www.airbn...|LoHi Secret garde...|Come enjoy our oa...|   Guesthouse|   Denver|                 100|$140.00|
|   590|https://www.airbn...|Comfortable  - an...|Large guest room ...|        House|   Denver|                  97| $61.00|
|   592|https://www.airbn...|             private|This room is in t...|        House|   Denver|                  97| $44.00|
|  1940|https://www.airbn...|Baker Studio Clos...|Great place for a...|   Guesthouse|   Denver|                  99| $95.00|
|  2086|https://www.airbn...|  Garden Level Condo|A furnished, gard...|    Apartment|   Denver|                  96| $76.00|
| 31503|https://www.airbn...|Highland Park Gue...|Highland Park Gue...|  Guest suite|   Denver|                  98|$110.00|
| 39405|https://www.airbn...|LoHi Secret garde...|Come enjoy our oa...|      Cottage|   Denver|                  98|$111.00|
| 56185|https://www.airbn...|charming home for...|Spend time in Den...|        House|   Denver|                  98|$300.00|
| 59631|https://www.airbn...|VICTORIAN TOWNHOM...|License #2017-BFN...|    Townhouse|   Denver|                  96|$179.00|
| 74125|https://www.airbn...|Spacious Cap Hill...|1000' entire-firs...|    Apartment|   Denver|                  94|$130.00|
| 81540|https://www.airbn...|Affordable S. Den...|Bright, sunny 1 b...|   Guesthouse|Englewood|                  98| $75.00|
| 90307|https://www.airbn...|Comfy King Size R...|This private bedr...|        House|   Denver|                  98| $90.00|
| 98008|https://www.airbn...|Beautiful sun fil...|Locaton, location...|        House|   Denver|                  99| $70.00|
| 98014|https://www.airbn...|Beautiful single ...|Hi Folks!  Welcom...|        House|   Denver|                  98| $60.00|
|142683|https://www.airbn...|Historic Denver C...|One of three cond...|        House|   Denver|                  94|$125.00|
|172196|https://www.airbn...|Luxury Wash Park ...|Remodeled wash pa...|        House|   Denver|                  99|$411.00|
|184529|https://www.airbn...|HIP SUITE IN  WES...|Private SUIITE   ...|  Guest suite|   Denver|                  97| $35.00|
|192430|https://www.airbn...|TREETOP VIEW ROOM...|Located in the de...|  Condominium|   Denver|                  94| $32.00|
|217996|https://www.airbn...|       Highland Snug|Comfortable and c...|  Condominium|   Denver|                 100| $66.00|
|236207|https://www.airbn...|Denver Penthouse ...|Important Note : ...|         Loft|   Denver|                  99|$235.00|
+------+--------------------+--------------------+--------------------+-------------+---------+--------------------+-------+