Blogs about: Data Insights
Featured Blog
Difference between WLS and weighted average
I hear the phrase “what does it look when we weight the data” a lot. It confused me for a while, but I figured it out: it could mean two things, so the response should be, which of the two… more →
Economics should be open
Difference between WLS and weighted average
howardchong wrote 1 month ago: I hear the phrase “what does it look when we weight the data” a lot. It confused me for … more →
List of european power plants, data sources for electricity generation
howardchong wrote 3 months ago: I was looking for a list of power plants in Europe in 2008. I didn’t find one. You know why? I … more →
Billing Data and Randomized Experiments in Energy Efficiency Evaluation a research survey
howardchong wrote 5 months ago: I’m doing a research survey of empirical evaluations of energy efficiency using billing data. … more →
Why Chinese Electric Cars are different
— 1 comment
howardchong wrote 7 months ago: NYTimes just reported that China’s going gangbusters on electric car development: http://www.n … more →
Clustering with panel data and fixed effects
— 1 comment
howardchong wrote 8 months ago: I have it on good authority that “The cluster option is robust for within-cluster serial corre … more →
MS Access Tables to Stata, for Residential Energy Consumption Survey
howardchong wrote 11 months ago: Problem: To convert MS Access tables (of the EIA Residential Energy Consumption Survey 1997 data) to … more →
perl script for transposing Stata outreg2 output
— 1 comment
howardchong wrote 1 year ago: I’m using Stata’s outreg2 command and love it. But I run this look over 600 stocks. Exce … more →
EPER, consistency with indirect emissions, email
howardchong wrote 1 year ago: So using EPER (European Pollution Emissions Register), I’ve found some anomalies with Aluminum … more →
CITL, coverage for the ETS, matching to EPER
howardchong wrote 1 year ago: This post is a big deal for me because it really pushes me to stay true to open source principles. S … more →
UCLA stata graphing
howardchong wrote 1 year ago: http://www.ats.ucla.edu/stat/stata/topics/graphics.htm Just want to give a shout out that the peop … more →
stata transpose string variable without xpose
howardchong wrote 1 year ago: So STATA will let you transpose the data with the xpose command, but this does not handle string dat … more →
perl script for transposing csv
howardchong wrote 1 year ago: I needed to tranpose a 600×5 csv (comma separated values) file so I could read it in Excel … more →
stata, double quotes, file names with spaces, foreach
howardchong wrote 1 year ago: It took me more than 10 minutes to figure out, so I’m posting this tip here. I needed to loop … more →
Eurostat "database" and downloading bug
— 3 comments
howardchong wrote 1 year ago: I need to download various data from Eurostat (the European statistical unit). I found this bug (and … more →
COMTRADE - data availability of 2006 data, a graph
howardchong wrote 1 year ago: So, here is when countries reported their 2006 COMTRADE data. Comtrade 2006 data publication dates … more →
COMTRADE - some usage notes from UC Berkeley
howardchong wrote 1 year ago: I’m working with COMTRADE data. COMTRADE is the main source for trade data in the world. I tal … more →
