City Search Tool

Inspiration

Our project was inspired by the multiple tools that provide data about cities, such as the tool that google provides covid cases. However, there is no conglomeration that handles multiple points of data and shows it to the user easily.

What it does

Our tool takes the top 200 most popular and sought out destinations in the Us and gives relevant data for a person who is desiring to move. They would first input their level of importance for each of our factors. Then, using our quartile based scoring algorithm, we output a map of the most relevant and up to date data that will inform the user.

How I built it

We made this program in Python due to the array of data analysis tools it provides. We first did research and got relevant data for covid cases, crime rates, pollution, and happiness index. We found that in these times, the four variables are the most impactful when one is choosing another city.

Challenges I ran into

When making our program, a big issue we were having was scraping and cleaning the data from the csv files we acquired. Many of the documents did not display the city but the metropolitian area and the state in the same cell. We had to split each document to where we could read only the name of the city and acquire the data we needed. For example, in the covid cases, there was only data for counties, so we had to get another csv file that converted each city into the FIPS number which corresponded to the appropriate city. Then, we used an algorithm to add each part together.

Accomplishments that I'm proud of

We are satisfied by the concise data that our map provided for the user. Especially during these times of covid-19 we felt that it was essential to provide this data for every person who was thinking of moving to a new city. It also always feels great to finally have a working product after hours of errors and bug testing.

What I learned

We learned how to effectively use csv and pandas to manipulate data. We also learned to create a map and collaborate with others.

What's next for City Search Tool

We are planning to add scraping tools that will automatically update the program without user input and more data variables.

Built With

• csv
• google-colab
• python