Large Stata Datasets and False Errors about ‘Duplicates’

Variable storage types exercise more importance when working with larger datasets, and variables with more digits. I'm reminded of this because of an error message Stata threw while trying to perform a long reshape, claiming duplicate entries of the ID variable. That was obviously not the case, since the _n id was uniquely created, and … Continue reading Large Stata Datasets and False Errors about ‘Duplicates’

Identify nth-Degree Neighbors Using R’s Simple Features Package, Simply

You're more likely to complain about the neighbors upstairs who are making noise after midnight than those in an apartment two buildings away. Proximity matters and that's patently obvious, but oftentimes it takes a bit of work to identify who is close and who isn't. While raster data is packaged in a consistent gridded format for … Continue reading Identify nth-Degree Neighbors Using R’s Simple Features Package, Simply

Local Macros in Stata Using Regular Expressions

Regular expressions can dramatically make your scripting simpler, more automated, and enable you to embed systematically-important information in filenames, variables, dictionaries, and paths. With enough practice, xkcd reminds us that regexp can also make you a superhero. Stata provides a very nice table of their regular expressions and offers some helpful examples, but these seem … Continue reading Local Macros in Stata Using Regular Expressions

Converting .TXT/.GRD Climate Data Files to netCDF Format

Climate data is packaged and distributed in too many file formats.  Under ideal circumstances, you could easily convert data from formats you're not familiar with (and don't have scripts to handle), to those that you do. This is why analogous tools like Stat/Transfer for statistical databases often used by social scientists, are so helpful.  If a stranger … Continue reading Converting .TXT/.GRD Climate Data Files to netCDF Format

Effortlessly Merging 1,000s of Raw Data Files with Stata

I frequently have to consolidate 100s or 1,000s of raw data files into Stata, that are potentially stored in numerous and potentially unknown folders and subfolders, and have developed a workflow that I think is useful.  This approach means I don't need to know file names or paths, and can instead assign search parameters that … Continue reading Effortlessly Merging 1,000s of Raw Data Files with Stata

Stata-Latex esttab Regression Table Output Streamlining

Researchers spend an excessive amount of time getting up to speed with a field's chosen tools and methods, excessive because there is often a consensus on best practice and yet those best practices are not made common knowledge.  I think the CS and statistics communities have this right in their pushing for open data, transparency, and reproducibility … Continue reading Stata-Latex esttab Regression Table Output Streamlining

Stata: Reghdfe and factor interactions

If you don't know about the reghdfe function in Stata, you are likely missing out, especially if you run 'high dimensional fixed effects' models -- i.e., your model includes 3+ dimensions of FE, perhaps 2 in time and 1 in space-time.  I've been encountering a situation which raises this unhelpful error message: (null assertion) Empty … Continue reading Stata: Reghdfe and factor interactions

Tutorial: FuzzyWuzzy String Matching in Python – Improving Merge Accuracy Across Data Products and Naming Conventions

If you work with manually-entered string character data or data coming from multiple providers, you may encounter the reality of not being able to a.) merge the data, or b.) produce correct summary statistics.  Regarding a.), take the example in the picture of Indian district names exported from two data sources -- we'd have a … Continue reading Tutorial: FuzzyWuzzy String Matching in Python – Improving Merge Accuracy Across Data Products and Naming Conventions