I am trying to collect sample datasets to test in OpenVisuals.org. As of that, these sample datasets should:
- sample a generic type of datasets.
- should have different but generic formats, which would be a format outcome of copying/pasting, exporting from excel, etc.. (right now, I can think of differences in comma separated values (sometimes comma, sometime tab, sometimes space).
- should imply comparison among its data.
I will use these datasets to make sure that the website (hence the applets) will be able to work fine with them. I currently fetched couple of datasets that would be suitable:
MDF (wood type) Production for Continents per years (gathered from FAO United Nations website)
years subject commodity America + Asia + Europe + Oceania + 1995 Production Quantity MDF 2398000.00 1582000.00 3363300.00 540000.00 1996 Production Quantity MDF 2725000.00 2190000.00 3604300.00 786000.00 1997 Production Quantity MDF 3285036.00 3737000.00 4587300.00 853000.00 1998 Production Quantity MDF 3899694.00 3484000.00 6557913.00 899000.00 1999 Production Quantity MDF 4635000.00 3854000.00 7288500.00 1025000.00 2000 Production Quantity MDF 4773000.00 4652000.00 8380493.00 1241000.00 2001 Production Quantity MDF 5101472.00 8002300.00 9163590.00 1350000.00 2002 Production Quantity MDF 5601924.00 10135100.00 10386690.00 1419000.00 2003 Production Quantity MDF 6327229.00 13970200.00 11110990.00 1627000.00 2004 Production Quantity MDF 7729545.00 18658026.00 11846105.00 1639000.00 2005 Production Quantity MDF 7751384.00 24133523.00 12704400.00 1622000.00 2006 Production Quantity MDF 8467770.00 27017523.00 13383800.00 1635000.00
In the table above, the generated dataset set is not delimited with comma, but tab spaces (although the file is .csv). This also happens when you copy paste from Excel.
Also below, is a very typical example of a dataset with empty cells (unknown data), though the content is one of the most popular ones lately.
"State","Barack Obama","Hillary Rodham Clinton ","John Edwards","John McCain ","Mike Huckabee","Mitt Romney","Ron Paul" "Alabama",10,19,0,16,21,0,0 "Arizona",21,25,0,50,0,0,0 "Arkansas",3,10,0,1,29,1,0 "California",155,195,0,146,0,3,0 "Connecticut",26,22,0,27,0,0,0 "Delaware",9,6,0,18,0,0,0 "Georgia",22,12,0,3,45,0,0 "Illinois",68,35,0,54,0,3,0 "Kansas",15,6,0,,,,0 "Massachusetts",38,55,0,18,0,22,0 "Missouri",36,36,0,58,0,0,0 "Montana",,,,0,0,25,0 "New Jersey",46,54,0,52,0,0,0 "New Mexico",12,14,0,,,,0 "New York",80,121,0,101,0,0,0 "North Dakota",,,,5,5,8,5 "Oklahoma",14,24,0,32,6,0,0 "Tennessee",14,24,0,19,25,8,0 "Utah",14,9,0,0,0,36,0 "West Virginia",,,,,18,0,0 "Florida",,,,57,0,0,0 "South Carolina",25,12,8,19,5,0,0 "Michigan",,,,6,1,23,0 "New Hampshire",9,9,4,7,1,4,0
Here is also the imported version of this dataset in OpenVisuals.org .