Exploratory Analysis of TripAdvisor and US Census Data

Inspiration

We knew that US Census Data was publicly accessible and wanted to use it, along with other data, to discover new correlations. US Census Data is limited in its ability to analyze the impact of cultural attractions and eateries on the demographics on a town or county. TripAdvisor fills the gap with information delving into the success and popularity of certain attractions within these areas.

What it does

Our application information from the US Census Data API and the TripAdvisor API and combines the information to show correlations between traits such as median household income of a specific county and price point of restaurants around that area.

How we built it

We used Python 3 for the API calls and data manipulation, with help from pyplot to create nice looking visuals for the data.

Challenges we ran into

Merging the data from the APIs was a large challenge. The data given to us by the US Census API did not allow us to easily get the associated data from TripAdvisor. Our workaround for this was to use Google Maps API to translate Census data to Census data to the TripAdvisor API calls.

Accomplishments that we're proud of

Learning how to do API calls in Python, and the creativity needed to merge the API information into coherent data sets

What we learned

Merging data from multiple APIs is not necessarily an easy task. Also a lot about pyplot and text formatting in Python 3.

What's next for Exploratory Analysis of TripAdvisor and US Census Data

Using it to explore other kinds of comparisons beyond the scope of restaurants Making it more flexible with user input and allowing more dynamic API calls.

Built With

• google-maps
• pyplot
• python
• tripadvisor
• us-census-api