3 ms·

It's a goldmine, there are 350k datasets available, and a lot of them that will not make some people happy (criminality by geographic zone for example). It ope

by brohee 15y ago

It's a goldmine, there are 350k datasets available, and a lot of them that will not make some people happy (criminality by geographic zone for example). It opens possibilities to create a really nice multi-factor (e.g. crime, pollution, education) "best place to live" application. A lot of the data is available in a very manageable CSV, sadly some is only available in XLS that may be a bit harder to manipulate programmaticaly.

hessenwolf 15y ago
For the ones that aren't formatted randomly in Excel: library(RODBC) channel <- odbcConnectExcel("myExcelFile.xls") myDataFrame <- sqlFetch(channel, "Sheet1") odbcCloseAll() write.csv( file = paste("myExcelFile", "Sheet1.csv"), myDataFrame, row.names = F )
thibaut_barrere 15y ago
For XLS, be sure to check out Roo http://roo.rubyforge.org/ http://roo.rubyforge.org/ or use Java libraries and JRuby.
BasDirks 15y ago
for a pretty good python library: pip install xlrd
1100110101 15y ago
What are the problems with catdoc's "xls2csv"? Or libxls (sourceforge)?