Wednesday, July 15, 2009

Explore Data.gov and Google Fusion

I am going to cop out tonight and refer you to Blog about Stats which shows an interesting way to display data from some of our US Gov collected databases using Google Fusion. You can learn more about how to use Google Fusion at the Official Google Research Blog. I tried the service using a large .csv file that I had downloaded from Data.Gov on household energy usage that was conducted in 2005. I found the database was to large to work effectively in Google Fusion so you should use Excel or other similar program to edit your data upfront to the specific columns you are interested in.

For a second try I used a baseball database that one of my University of Phoenix statistics classes use for projects. I quickly was able to generate a simple scatter plot of attendance vs wins for the year 2002 in MLB.

Google Fusion saves your data files under your account. It lets you share the data with others if you desire.

After working with this for about an hour I am not yet willing to give up my other tools for creating graphics. Excel can make the same chart quickly and easily and even produce a regression trend. None the less, I think it is interesting what Google is doing with this product and it should encourage people to share data and graphic data representations. There seemed to be a good Filter and Merge utility that would allow you to filter data or even merge two datasets together.



Give it a try if you like.
Post a Comment