DataWrangler for your data formatting needs

Posted to Online Applications  |  Tags: , ,  |  Nathan Yau

Formatting data is a necessary pain, so anything that makes formatting easier is always welcome. Data Wrangler, from the Stanford Visualization Group, is the latest in the growing set of tools to get your data the way you need it (so that you can get to the fun part already). It’s similar to Google Refine in that they’re both browser-based, but my first impression is that Data Wrangler is more lightweight and it feels more responsive.

Data Wrangler also seems to do more guesswork, so you can set less specific parameters. Just roll over stuff, and it’ll show a preview of possible changes or formatting. Keep the change or easily undo it.

The video below describes what all the tool can do, but it’s better to just try it out. Copy and paste your own mangled data or give Data Wrangler a whirl with the sample provided.

I’d be interested to hear what the Google Refine users think of Data Wrangler. I never got the hang of it and seem to always end up writing code rather than learn my way around the menus and clicks. I think I’ll be coming back to this one though.

[Data Wrangler via Waxy]

1 Comment

  • Wow,it’s smart. With the suggestions and preview function I don’t have to “learn” to use it at all. Sometimes I get text files from my professor and it always takes a lot of work to extract data from these files into database tables. I think this tool is exactly what I need.

Favorites

How You Will Die

So far we’ve seen when you will die and how other people tend to die. Now let’s put the two together to see how and when you will die, given your sex, race, and age.

10 Best Data Visualization Projects of 2015

These are my picks for the best of 2015. As usual, they could easily appear in a different order on a different day, and there are projects not on the list that were also excellent.

Think Like a Statistician – Without the Math

I call myself a statistician, because, well, I’m a statistics graduate student. However, the most important things I’ve learned are less formal, but have proven extremely useful when working/playing with data.

Pizza Place Geography

Most of the major pizza chains are within a 5-mile radius of where I live, so I have my pick, …