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

[David Sichinava]

Hi Catherine,

Probably command line could be a solution:

http://webpierat.com/2011/05/23/merging-csv-files-using-the-command-line/
http://www.solveyourtech.com/merge-csv-files/

Best,

D.

2014-10-27 15:54 GMT+04:00 Claire Miller <claire.l.miller at gmail.com>:

> 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
>
>


-- 
David Sichinava | GIS and Database Analyst | CRRC Georgia
+995 598 555 381 | http://www.datablog.ge
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20141027/ba7a9800/attachment-0003.html>