This project takes maps of construction applications and prices of sold properties in NYC and combines them to understand the relationsship between the amount of housing construction and the property prices.
- What areas of the city (borough, community district, etc.) are seeing the most construction of housing? How many units can be expected?
- What kinds of housing are being prioritized by the city? New developments? Renovations? Low density? High density? Luxury? Affordable?
- Do people apply for construction permits in areas with high property prices?
- We are using an incremental data load method to load data from the NYC OpenData API.
- This method is preferable to using the append method because it allows us to update data that is already in the Google BigQuery table as well as add additional rows that are new.
- Additonally, this method should be faster than using a truncate and load method which would recreate the entire table each time the script is run.
- We are hoping that using an incremental method not only captures the most up to date data but also helps speed up the site.
-
- Open a new window in VS Code.
-
- Click "Clone Git Repository."
-
- Copy the URL "https://github.com/advanced-computing/will-naga-krishna" and paste it in the search bar. And Enter.
-
- Select the repository destination. Select "Open."
-
- Open a new Terminal.
-
- Run the following command
python -m venv .venv
to set up the virtual environment.
- Run the following command
-
- Right click on the file path for the virtual environment and copy the file path. Activate the environment by running the following command
source .venv/bin/activate
if you are a Mac user. If you are a Windows user, refer to this page.
- Right click on the file path for the virtual environment and copy the file path. Activate the environment by running the following command
-
- Install the requirements using
pip install -r requirements.txt
.
- Install the requirements using
-
- Run the app by putting
streamlit run Home.py
.
- Run the app by putting