[ddj] Good resource for combining data in Excel or Spreadsheets?

Mon Oct 27 12:03:25 UTC 2014

Catherine,

I assume you are talking about joining datasets. You could do this in refine (using cell.cross).

Also Tony has written about this on the school of data blog
http://schoolofdata.org/2013/10/10/finding-matching-items-on-separate-lists-bangladeshi-garment-factories/

Michael

From: data-driven-journalism [mailto:data-driven-journalism-bounces at lists.okfn.org] On Behalf Of Catherine D'Ignazio
Sent: Monday, October 27, 2014 11:57 AM
To: List about Data Driven Journalism and Open Data in Journalism.
Subject: [Spam?] [ddj] Good resource for combining data in Excel or Spreadsheets?
Importance: Low

Hi all -

I teach a data visualization course at Emerson College. We are just starting to talk about cleaning and combining data from multiple sources into a single file. We are using OpenRefine for cleaning.

Does anyone have a good, simple tutorial link or resource for combining data? Could be in Excel, Google Spreadsheets, or another program if it's free and easily accessible.

Catherine

/////////////////////////////
Catherine D'Ignazio
Research Affiliate, MIT Media Lab Center for Civic Media
dignazio at mit.edu<mailto:dignazio at mit.edu>  ||   @kanarinka   ||   +1 617 501 2441   ||   www.kanarinka.com<http://www.kanarinka.com/> || http://civic.mit.edu/blog/kanarinka/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20141027/fc717827/attachment-0003.html>