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

Mon Oct 27 12:48:00 UTC 2014

Also, it's only polite to mention CSV reconcile as a great way of combining
two spreadsheets where things are named inconsistently across them. Not a
tutorial but a tool that the first respondent (Michael Bauer) in fact
built. It uses Open Refine so could be a great tool to introduce later on
in the course:

http://okfnlabs.org/reconcile-csv/

On 27 October 2014 11:54, Claire Miller <claire.l.miller at gmail.com> wrote:

> Hi
>
> I've got a couple of posts on my blog that might be of interest (
> http://clairemiller.net/blog/2014/05/data-journalism-for-beginners-cleaning-up-your-data/#comments
> and
> http://clairemiller.net/blog/2013/08/data-journalism-necessity-is-the-mother-of-invention/)
> but they're not really tutorials (there are a few in the book), given I've
> spent most of this morning trying to clean and combine data using
> OpenRefine I should probably write some more.
>
> Claire
>
> On 27 October 2014 10:57, 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
>>
>>
>
> _______________________________________________
> 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
>
>

-- 

*Sam LeonSchool of Data Fellow | skype: samedleon  |  @Noel_Mas
<https://twitter.com/noel_mas>The Open Knowledge Foundation
<http://okfn.org/>Empowering through Open Knowledgehttp://okfn.org/
<http://okfn.org/>  |  @okfn <http://twitter.com/OKFN>  |  OKF on Facebook
<https://www.facebook.com/OKFNetwork>  |  Blog <http://blog.okfn.org/>  |
 Newsletter <http://okfn.org/about/newsletter>*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20141027/4f88a876/attachment-0003.html>