[ddj] A question about Google Refine

[mirko.lorenz at gmail.com]

Hi Damien,
check out Databeast by my colleague Cosmin Cabulea. He has published a
number of Google Refine/Open Refine tutorials, in German though.
http://www.databeast.org
If nothing helps, contact him directly via cosmin.cabulea at dw.de. I am quite
sure he can show you a very easy solution to what you want to do. Agreeing
with Michael, that using the facets function (combined with collapsing
unneeded columns) might do the trick. Additionally Google Refine offers
extensive filtering options, again to limit the amount of data to workable
amounts.

Plus: For fast, very easy statistical analysis you should check out
Statwing, it's like SPSS/R for people who just want to run statistical
analysis. There was a short interview with them published on
datadrivenjournalism.net last year. Link:
http://datadrivenjournalism.net/resources/Statwing_Powerful_Data_Analysis_Simple_to_Use

Best,
Mirko

2013/2/7 Damien Brunon <damien.brunon at gmail.com>

> Hi everyone!
>
> I'm Damien, I work for @jplusplus_ and I need some help about Google
> Refine.
>
> I'm trying to work on a database about health structures in France that
> are dedicated to autist people.
>
> I downloaded a database with every structures that work with mentally
> handicapped people, I succeded in taking out those who are not linked with
> autist people but I still got a problem.
>
> The thing is, some structures work with autist but with other mentally
> handicapped people. So in the table you got:
>
> structure_activity1 ; structure_clients_type1 ; number_of_beds1 ;
> structure_activity2 ; structure_clients_type2 ; number_of_beds2 etc.
>
> In exemple that makes:
>
> *Line 1) General education / Intellectual deficient people */ 6 *;*Professional education / autists / 24
> *;* General education / autists / 20
> Line 2) Professional education / autists / 12 *;* *Professional education
> / Intelletual deficient people / 20*
> Line 3) General Education / autists / 10 ; Professional education /
> autistes / 24 ; *General Education / Intelletual deficient people / 8*
>
> What I want to do with Google Refine is delete every cell that doesn't
> concern autism (like the ones underligned) and at the end just have the
> informations about autists with the number of places.
>
> Until  then I didn't succed because every time I try to delete the things
> I  don't want using "facet", I delete the whole column (wich deletes also
> things I want to keep).
>
> One solution would be to concatenate all the structure_clients_type cols
> into a new column, but how could I then extract the number of beds that
> only concern autism?
>
> So if you can help me that would be great!
>
> --
> Damien Brunon
> damien.brunon at gmail.com
> @silveroux
>
> _______________________________________________
> data-driven-journalism mailing list
> data-driven-journalism at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/data-driven-journalism
> Unsubscribe: http://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/20130207/12f4e821/attachment-0001.html>