Learning a new language? Feeling homesick? Or just plain adventurous?
Let's find the right place for you!
Let's find the right place for you!
CSV file to use in conjunction with code. Source code linked below. If you use any part of my code for other projects, please don't forget to give me credit :)
If you're visiting a new country or place in general, and you don't speak the language of the locals, this site makes the perfect assistant. You'll be able to find out where you can go and still be understood, or if you're feeling adventurous, you can try to learn a new language!
(Please note: At the moment, our data only includes the NYC area. More data to come in the future.)
Simply type the language and the name of the place you're visiting, and you'll instantly get the areas which fit your needs. We're constantly updating our site to bring you the most current data available.
We make it our mission to ensure that our site is 100% reliable. If you don't get the exact results you're looking for, please don't hesitate to let us know; we'll be more than happy to help you!
Please reach us at grant.paul.227@gmail.com if you cannot find an answer to your question.
A: My underlying hypothesis was that people would speak a wider variety of different languages in Manhattan, which turned out to be true (evidence by the csv file). I used a compilation of data from 2015, which was the most recent version of data available, and I used many sites to help, such as https://languagemap.nyc, https://www1.nyc.gov, and https://www.worldatlas.com, to name a few.
The dataset from this website contains charts for all five boroughs, and New York City altogether. There are over 30 different languages represented throughout the charts, and each language has a number which represents the population in the given area who speak that language.
(Note: I purposely left out the second page (Limited English Proficiency) for simplicity; in addition, they are all included in the first page anyway with the general population.)
I started out with a blank Excel file, and then added a column for the languages, as well as one for NYC and another five for the boroughs. I then carefully went down row-by-row, starting with the name of the language, and then the number of people who spoke the language (under the "Total" section). For simplicity, I ignored the "Speak Only English" and ":Language Other Than English" rows, as well as the "Percent" column. I started with the NYC column and worked my way towards the bottom. Then, I moved on the "Bronx" column and did the same thing, and so on and so forth. Whenever a new language name appeared, I created a new row, being careful to check if that language had already been added (obviously to avoid duplicates). Once I finished all the rows and columns, there were several cells that had no values. I simply typed "N/A" as a placeholder for those cells. Finally, I wrote my code, and used the "pandas" and "csv" libraries in Python to make life easier. Before implementing the functions and variables, I tested to see if the csv would be imported and outputted successfully, which it was. Three functions later, my code was done, and by extension, the project. Dare I say, at least phase 1 is done ;)
Data sources:
All code was 100% handwritten by me, thus there are no code sources, nor any publications used. Source code linked above (in the Files Available for Download section).
Sign up to hear from us.
We love our customers, so feel free to email us whenever you'd like!
Who Speaks What Where?
Copyright © 2021 Who Speaks What Where? - All Rights Reserved.
Powered by GoDaddy
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.