Pinned Repositories
assessor2sqlite
Through a partnership, some subsidiaries of USC Price gained access to Corelogic's assessor and history files, as well as, the older assessor and history files of DataQuick (that CoreLogic bought). However, the data were tedious to work with because each of the 4 data sets were scattered among 28GB+ files. The goal of this project was to transfer the data to a database to facilitate its use. In the code herein, I transfer the data from the files into an SQLite database and provide an easy python app with which one can query the db.
blognotebooks
Instead of creating individual repositories for notebooks posted for my blog, I created this container.
Casden-Forecasts
The code used to make the Casden rent, vacancy, and construction forecasts.
characterizing-renters
In this notebook, I post the notebooks that generate the visuals and tables behind the characterizing renters posts. Additionally, I present the code that prepared the data use in the notebooks.
EITChousing
Were EITC credits extended to help with housing for low-income families, what would be the cost?
fix_autoparser
FruSleeps
globs
Code for Gene's blog
Milwaukee-crime-data-acquisition
This code is used to download census tract level crime data from the Milwaukee data repository. However, the code is modular and thus can be quickly amended to automate downloads of other data from Milwaukee's data repository
Scraping-Yelp
Scrape Yelp for a city/region
kiwiPhrases's Repositories
kiwiPhrases/Scraping-Yelp
Scrape Yelp for a city/region
kiwiPhrases/Milwaukee-crime-data-acquisition
This code is used to download census tract level crime data from the Milwaukee data repository. However, the code is modular and thus can be quickly amended to automate downloads of other data from Milwaukee's data repository
kiwiPhrases/assessor2sqlite
Through a partnership, some subsidiaries of USC Price gained access to Corelogic's assessor and history files, as well as, the older assessor and history files of DataQuick (that CoreLogic bought). However, the data were tedious to work with because each of the 4 data sets were scattered among 28GB+ files. The goal of this project was to transfer the data to a database to facilitate its use. In the code herein, I transfer the data from the files into an SQLite database and provide an easy python app with which one can query the db.
kiwiPhrases/blognotebooks
Instead of creating individual repositories for notebooks posted for my blog, I created this container.
kiwiPhrases/Casden-Forecasts
The code used to make the Casden rent, vacancy, and construction forecasts.
kiwiPhrases/characterizing-renters
In this notebook, I post the notebooks that generate the visuals and tables behind the characterizing renters posts. Additionally, I present the code that prepared the data use in the notebooks.
kiwiPhrases/EITChousing
Were EITC credits extended to help with housing for low-income families, what would be the cost?
kiwiPhrases/fix_autoparser
kiwiPhrases/FruSleeps
kiwiPhrases/globs
Code for Gene's blog
kiwiPhrases/Inclusionary_Zoning
code for aggregating, preparing, and visually analyzing data pertaining to inclusionary zoning
kiwiPhrases/kiwiphrases.github.io
kiwiPhrases/la_tax_change
We examine the 2004 tax change in Los Angeles by comparing areas contiguous to LA.
kiwiPhrases/landscanToMetroAreas
For this project, I take 2015 [Landscan](https://landscan.ornl.gov/) data and use it to find metropolitan areas in Peru for Jorge De La Roca. Metropolitan areas are determined in R while post-processing in performed in Python (thank you GeoPandas and Fiona). I am glad to have been able to find a way to render both arcGIS and qGIS dispensable for computational purposes (of course, they're still great for mapping)
kiwiPhrases/LEAP_Py3xx
Spring 2016, Duke STA-663 final project
kiwiPhrases/marketConcentration
This repository contains notebooks that were used to compute Herfindahl-Hirschmann Indexes for various US rental housing markets
kiwiPhrases/multiple-regressions
Multiple regressions in Python with Pandas and Statsmodels
kiwiPhrases/Parse_Wikipedia_tables
In scouring the web, it was to the embarrassment of humanity that I could not find a parser that could accurately parse the tables found on Wikipedia - I thus wrote my own.
kiwiPhrases/rentDistributionChanges
I compare the distribution of rents between 2009-2013 and 2013-2017 ACS surveys at the block group level in LA County. I believe this is a better metric of change than comparing changes in median rents because my metric explicitly accounts for the disappearance of low cost units and their replacement with high cost units. I want an index that shows whether the rent distribution has shifted upward or downward across the years but I do not have micro level data. Moreover, using this index, I wish to compare the size and direction of the shift between geographies so that geographies with a high index experienced a rightward shift in the rent distribution (thus became more expensive) while geographies with a low index experienced a leftward shift in the rent distribution (thus became less expensive). I am not aware of any such metrics so I propose one here and map it. In order to construct a metric for distributional change without actually having micro-level data, I 1) normalize bins for each block group, 2) take the difference between the 2017 and 2013 bins, and 3) take the difference between changes in the top two bins against the changes in the bottom two bins. Let b index the 8 bins (ie rent300 to 599 is bin 2, rent 2000 or more is bin 8), i index block groups, and t index survey years . In order to avoid overlap, I exclude the ACS 2011-2015 from the index so in effect, I only use the 2009-2013 and 2013-2017 ACS surveys for the index.
kiwiPhrases/repeatRents
Notebook used to examine AHS panel on rent changes
kiwiPhrases/sccycling-merch
kiwiPhrases/SCcycling_code
# IntroThis code takes the original assets file and dumps it to a database
kiwiPhrases/state_party_strength
The repository contains data on party strength for each state as shown on each state's corresponding party strength Wikipedia page.
kiwiPhrases/TimeInOut
Keep track of your time away from your desk
kiwiPhrases/UncommonGoods
Contains the ipython notebook used to analyze social login data
kiwiPhrases/USC-Dissertation-Manuscript-Template
This repository contains LateX code for USC's PhD Dissertation Manuscript. The Thesis and Dissertation Formatting Guidelines for USC can be found [here](http://graduateschool.usc.edu/current-students/thesis-dissertation-submission/guidelines-for-format-and-presentation/). This .tex file only contains items that precede the actual chapters.