Invisible Inventory: How Federal Loan Pool Liquidation Programs Are Undermining U.S. Housing Affordability

**Instructions for Uploading and Analyzing Data Files Using Google Colab and Zenodo** This guide explains how to upload your data files from Zenodo into Google Colab, run analyses, and generate your results. --- ### Step 1: Download Files from Zenodo1. Visit your Zenodo record where your files are stored.2. Use the download buttons to save the following files to your local device: - `NPL_Analysis_Direct_Load.ipynb` (Jupyter Notebook script) - `NPL Quarterly Aggregates.xlsx` - `NPL Transactions Detail.xlsx` ### Step 2: Upload Files to Google Colab1. Open your Google Colab notebook.2. Run the following code block to upload files from your device: ```pythonfrom google.colab import filesuploaded = files.upload()``` 3. A file upload dialog will appear. Select all the data files you downloaded from Zenodo.4. After uploading, your files will be available in the Colab environment, ready to be used. ### Step 3: Load and Prepare Data FilesUse Python code to load the files into dataframes for analysis. Example: ```pythonimport pandas as pd # Replace 'filename.xlsx' with your actual file namesquarterly_data = pd.read_excel('NPL Quarterly Aggregates.xlsx')transaction_data = pd.read_excel('NPL Transactions Detail.xlsx')``` ### Step 4: Run the Analysis Script1. Execute the `NPL_Analysis_Direct_Load.ipynb` notebook to perform the analysis.2. Follow the in-notebook instructions. It will process your data, generate key statistics, and produce visualizations.3. The notebook outputs will include figures, summaries, and downloadable CSV or image files for your results. ### Step 5: Download Results1. After running the notebook, download the output files (e.g., CSVs, figures) directly from the notebook interface.2. Or, use the following to download any result files programmatically: ```pythonfrom google.colab import filesfiles.download('YourResultFile.csv')``` ### Additional Tips:- Keep your data files in the same directory or ensure correct paths for loading.- Always run the analysis cell after uploading new data.- Save your work frequently to avoid data loss. --- **Note:** All files uploaded are retained only for the session’s duration. To keep your analysis, download all result files before closing the notebook. --- **For questions or further assistance, refer to the Colab and Zenodo support pages or contact your project lead.**