Re:Show HN: Explore 16 Years of Green Card Applications
by negrit on Friday June 05, 2015 @04:28PM
(#9667910)
All my datasource where csv and mdb files. So, I directly imported them to PostgreSQL. Very little code was written to clean the data. 99% of the cleaning was done with SQL queries.
The code is mostly used to display the data. Cleaning the data with SQL queries is much faster than writing code.
The code is mostly used to display the data. Cleaning the data with SQL queries is much faster than writing code.