Have real estate data analytics questions? Join the private Facebook Group to ask questions and learn from peers - facebook.com/groups/techinrealestate
This is so useful. I'm a data analytics guy, not new to Python, know how to use APIs but the Census people made it so complicated and unclear. Thanks for showing how to construct the URL, which I couldn't get from their documentation.
Thanks Ariel! This was really helpful. I'm trying to find data for different zip codes but can't seen to find that in the supported geographies section. If possible could you please help me with that, I would be really grateful. Thanks!
Hi Haseeb, thanks for watching! I see Census made some changes including removing the previous link for reviewing data tables and fields. I will circle back once I do some additional research
Thanks for watching! Yes, you can change the place and variables within the API call to retrieve data you are looking for. Here's a more recent video on Census data and visualizing it that you may find useful - ruclips.net/video/4v1OJjLhGFs/видео.html
Thanks for watching Ashwika! You can find this data from NAR (National Association of Realtors). The FRED API provides this data - fred.stlouisfed.org/tags/series?t=nar. You can reference previous videos / work I have on FRED API to see how to extract data - github.com/analyticsariel/projects/blob/master/economic_data/fred_economic_us_data_real_estate.ipynb
the census site used to have available, the block group data by state, which could be downloaded as a csv. This could be used to look up a block group id and view some of the demographic detail for that group - median income, average income, households etc. However, since the site has been changed around, I cannot for the life of me find this information anywhere. You seem to be pretty familiar with their API as well as their site layout, would you happen to know how to find this? Or even, if the API could be used to retrieve this data? Say for example, if you send in the full census ID and return the details for that census tract/block group? Any guidance or suggestions would be very much appreciated!
Hi Nathan thanks for watching! I believe this is the API you are looking for www.census.gov/data/developers/data-sets/acs-5year.html. From the variables in the HTML table it looks like it has data for income based on block. Hope this helps!
Hey Daniel thanks for watching! Yes, you can make a request to Census API, more information here - levelup.gitconnected.com/how-to-get-total-population-from-the-census-api-using-python-bbf23758bfa7 I also have an entire section for the Census API in my new course releasing this October - Introduction to Real Estate Data Analytics
Thanks for watching! Api keys are the equivalent of passwords, it is best practice to keep it private in a separate file. I created a csv file to put my keys to then locate with pandas later and assign to a variable. You can put your api key directly into the code as a string or create your own api keys csv file
Have real estate data analytics questions? Join the private Facebook Group to ask questions and learn from peers - facebook.com/groups/techinrealestate
This is so useful. I'm a data analytics guy, not new to Python, know how to use APIs but the Census people made it so complicated and unclear. Thanks for showing how to construct the URL, which I couldn't get from their documentation.
Thanks for watching Chuck, glad it was helpful!
Thanks Ariel! This really helped me out with a homework assignment. Was having issues navigating the API. You explained it so well.
Thanks for watching, happy to hear that!
you are ahead of your time. NOw is a great time for these tools!
Thanks for watching and yes agreed now is the time to leverage these tools!
Thank you for a great lecture.
Thanks for watching!
really nice work! thanks!
Thanks for watching!
Great content!
Thanks Ariel! This was really helpful. I'm trying to find data for different zip codes but can't seen to find that in the supported geographies section. If possible could you please help me with that, I would be really grateful.
Thanks!
Hi Haseeb, thanks for watching! I see Census made some changes including removing the previous link for reviewing data tables and fields. I will circle back once I do some additional research
Could you help extracting population and GDP by city for every city in US?
Thanks for watching! Yes, you can change the place and variables within the API call to retrieve data you are looking for. Here's a more recent video on Census data and visualizing it that you may find useful - ruclips.net/video/4v1OJjLhGFs/видео.html
Hello, how to get the monthly new home sales data, I have tried many times but never get the right data
Thanks for watching Ashwika! You can find this data from NAR (National Association of Realtors). The FRED API provides this data - fred.stlouisfed.org/tags/series?t=nar. You can reference previous videos / work I have on FRED API to see how to extract data - github.com/analyticsariel/projects/blob/master/economic_data/fred_economic_us_data_real_estate.ipynb
the census site used to have available, the block group data by state, which could be downloaded as a csv. This could be used to look up a block group id and view some of the demographic detail for that group - median income, average income, households etc. However, since the site has been changed around, I cannot for the life of me find this information anywhere. You seem to be pretty familiar with their API as well as their site layout, would you happen to know how to find this? Or even, if the API could be used to retrieve this data? Say for example, if you send in the full census ID and return the details for that census tract/block group? Any guidance or suggestions would be very much appreciated!
Hi Nathan thanks for watching! I believe this is the API you are looking for www.census.gov/data/developers/data-sets/acs-5year.html. From the variables in the HTML table it looks like it has data for income based on block. Hope this helps!
@@TechInRealEstate Thanks, I think this is a start perhaps. It may just be that the API does not have the feature I want.
How to find that a zipcode is in the top 10 percent of per capita income of the state?
Is there a way to do this without rapid api?
Hey Daniel thanks for watching! Yes, you can make a request to Census API, more information here - levelup.gitconnected.com/how-to-get-total-population-from-the-census-api-using-python-bbf23758bfa7
I also have an entire section for the Census API in my new course releasing this October - Introduction to Real Estate Data Analytics
where do you find those "api_keys.csv ' dataset
Thanks for watching! Api keys are the equivalent of passwords, it is best practice to keep it private in a separate file. I created a csv file to put my keys to then locate with pandas later and assign to a variable. You can put your api key directly into the code as a string or create your own api keys csv file
@@TechInRealEstate Very intuitive mam. Can I get your email address I have some doubt on finding certain US voting data .
@@lipuntat sure it's arielherrera@analyticsariel.com
When I click on your rapid API link it shows "page not found"
it is inactive right now, I will update the channel when I update it