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

Piyush Aggarwal me.piyushaggarwal at gmail.com
Mon Oct 27 12:17:05 UTC 2014


Dear Catherine,

Last year, I came across a similar problem of merging two or more CSV files
with common headers but couldn't find anything, so I wrote a simple Python
Script: https://github.com/MePiyush/LivingData. It can help you in merging
two CSV files into one.

Piyush

*about.me/mepiyush <http://about.me/mepiyush>*

On Mon, Oct 27, 2014 at 4:27 PM, Catherine D'Ignazio <dignazio at media.mit.edu
> wrote:

> 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  ||   @kanarinka   ||   +1 617 501 2441   ||
> www.kanarinka.com || http://civic.mit.edu/blog/kanarinka/
>
> _______________________________________________
> data-driven-journalism mailing list
> data-driven-journalism at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> Unsubscribe: https://lists.okfn.org/mailman/options/data-driven-journalism
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20141027/65f61fe3/attachment-0003.html>


More information about the data-driven-journalism mailing list