[ddj] A question about Google Refine

Thu Feb 7 15:03:19 UTC 2013

Hi Michael!

Thanks for your answer. I'm not sure your solution is the good one because
sometimes the right answer is in a column but not in the other one. I tried
an other solution that seem to work: for every column, I facet and edit
every cells to blank so there will be just "Autistes", the one I want. The
problem is how will I be able to edit the table to suppress the blanks
whithout deleting columns.

Thanks again for your answer!

Take care

Damien

I tried what you told me but didn't work out. Actually I think I just can't
do what I want with refine. I want to delete some cells in some collumns
and make them move

2013/2/7 Michael Bauer <michael.bauer at okfn.org>

> Damien,
>
> Did you try to establish a custom facet or custom filter in refine? You
> should then be able to delete matching or non matching lines... (this
> should _not_ remove columns)
>
> Michael
>
> On Thu, Feb 07, 2013 at 02:29:41PM +0100, Damien Brunon wrote:
> > 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
>
>
> --
> Data Wrangler with the Open Knowledge Foundation (OKFN.org)
> GPG/PGP key: http://tentacleriot.eu/mihi.asc
> Twitter: @mihi_tr Skype: mihi_tr
>
> _______________________________________________
> 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
>

-- 
Damien Brunon @silveroux
damien.brunon at gmail.com
06 75 35 30 35
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20130207/20bdc67a/attachment-0001.html>