Free Tools for Data Visualization and Analysis for Google Refine

PR Log - Global Press Release Distribution
Free Tools for Data Visualization and Analysis for Google Refine
By battery
Dated: Apr 25, 2011
Google Refine can be described as a spreadsheet on steroids for taking a first look at both text and
numerical data.
Google Refine: Free Tools for Data Visualization and Analysis | Google Refine can be described as a
spreadsheet on steroids for taking a first look at both text and numerical data. Like Excel, it can import and
export data in a number of formats including tab- and comma-separate text files and Excel, XML and JSON
files.

Refine features several built-in algorithms that find text items that are spelled differently but actually
should be grouped together. After importing your data, you simply select edit cells –> cluster and edit and
select which algorithm you want to use. After Refine runs, you decide whether to accept or reject each
suggestion. For example, you could say yes to combining Microsoft and Microsoft Corp., but no to
combining Coach Inc. with CQG Inc. If it’s offering too few or too many suggestions, you can change the
strength of the suggestion function.

There are also numerical options that offer quick and easy overviews of data distributions. This
functionality can reveal anomalies that might be the result of data input errors — such as $800,000 instead
of $80,000 for a salary entry, or it could expose inconsistencies — such as differences in the way
compensation data is reported from entry to entry, with some showing, say, hourly wages and others
showing weekly pay or yearly salaries.

Beyond data housekeeping, Google Refine offers some useful analysis tools, such as sorting and filtering.

What’s cool: Once you get used to which commands do what, this is a powerful tool for data manipulation
and analysis that strikes a good balance between functionality and ease of use. The undo/redo list of every
action you’ve taken lets you roll back when needed. And text functions handle Java-syntax regular
expressions, allowing you to look for patterns (such as, say, three numbers followed by two digits) as well
as specific text strings and numbers.

Finally, while this is a browser-based application, it works with files on your desktop, so your data remains
local.

Drawbacks: Although Google Refine looks like a spreadsheet, you can’t do typical spreadsheet
calculations with it; for that, you must export to a conventional spreadsheet application. If you’ve got a
large data set, carve out some time in your day to go through all of Refine’s suggested changes, since it can
take a while. And, depending on the data set, be prepared when looking for text items to merge: You’re
likely to get either a lot of false positives or missed problems — or both.

Skill level: Advanced beginner. Knowledge of data analysis concepts is more important than technical
prowess; power Excel users who understand data-cleaning needs should be comfortable with this.

Runs on: Windows, Mac OS X , Linux.

Learn more: These three screencasts give a good overview of why and how you’d use Refine; there’s also
fairly detailed documentation on the Google Code project area.
Page 1/2

---

PR Log - Global Press Release Distribution

More Information: http:// www.batteryfast.co.uk/battery-technology/

Dell latitude d620 laptop battery replacement

US: http:// www.batteryfast.com/dell/latitude-d620.htm
UK: http:// www.batteryfast.com/dell/latitude-d620.htm
###
http:// www.batteryfast.co.uk/- wholesale electronics,Laptop Batteries,Laptop ac Adapter from china.
We aim at offering the most updated and high quality consumer electronics to shoppers from all over the
world.
Category
Internet, Technology, Software
Tags
free tools, data-visualization, analysis, Google Refine
Email
Click to email author
Phone
+44 1428 657789
Fax
+44 1428 657789
Address
Kemp House 58 / 61 City Road London
City/Town
London NW8
State/Province
London
Zip
EC1V 2NX
Country
United Kingdom
Page 2/2

---