Two new(ish) tools from Google make it easier to examine and organize your data. Back in November they announced Google Refine (which looks totally awesome if I do say so myself):
Google Refine is a power tool for working with messy data sets, including cleaning up inconsistencies, transforming them from one format into another, and extending them with new data from external web services or other databases. Version 2.0 introduces a new extensions architecture, a reconciliation framework for linking records to other databases (like Freebase), and a ton of new transformation commands and expressions.
Today, we’re opening the Public Data Explorer to your data. We’re making a new data format, the Dataset Publishing Language (DSPL), openly available, and providing an interface for anyone to upload their datasets. DSPL is an XML-based format designed from the ground up to support rich, interactive visualizations like those in the Public Data Explorer. The DSPL language and upload interface are available in Google Labs.
If I had more time to play with organizing and analyzing data I would be playing with these tools! Instead I’m sharing the info with you all so you can tell me your experiences!!