Exploring hotels around my location using Geographical Dataset — Beginner Data Science Project

Sathiya
Sathiya
Nov 2 · 2 min read

Exploring Hotels near a famous Motel during Vacation

People have come to the favorite vacation place in the country — Coimbatore which is a city in southern INDIA.

People want to explore for hotels near a motel that they are staying

So I’ve got the information of all the hotels near the motel using the foursquare API and used it to construct the map using FOLIUM MAPS

DATA SOURCE

The data used in the project is from Foursquare location Database. The data is obtained using the foursquare developer Client ID and secret key and the map is constructed

DATA CLEANING:

The data obtained using JSON response query is stored and it is cleaned for further data analysis.

Only the rows containing

  • Name
  • Categories
  • Address
  • Latitude
  • Longitude
  • PostalCode
  • State

Where required for the map plotting and hence rest of the data was cleared from the pandas data frame

  • DATA value containing NA was dropped from the data frame.
  • DATA containing only Hotels and Motel categories were kept and rest were cleaned.
  • Replacing the non-standard pincode values to standard pincode values.

Only one hotel HOTEL PARK PLAZA fits into all the conditions and in the same Pincode / locality of the selected Motel HOTEL HEM.

The locations of the hotel and motel are mapped using Folium maps in Python.

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade