[Os-datawrangling] Workshop on Openspending

Fri Oct 4 11:35:21 UTC 2013

Hi Gabriela,
(looping in the openspending data wrangling list)

To help you prepare the CSV file for upload to openspending we have this
section in the guide:
http://community.openspending.org/help/guide/en/formatting-data/

Really looking forward to follow this project!

Best,
Anders

On 3 October 2013 16:56, Gabriela <gabelula at gmail.com> wrote:

> I'm downloading the data from comprasestatales.gub.uy. It includes
> contractors names and amounts. I will upload it to datahub.
>
> 2013/10/3 Anders Pedersen <anders.pedersen at okfn.org>:
> > Hi Gabriela,
> >
> > Thanks! It would be great to work on this data as well for the training.
> >
> > I did a download of the Excel file bus not really sure what the it
> contains
> > (metadata?):
> >
> https://docs.google.com/a/okfn.org/spreadsheet/ccc?key=0AvdkMlz2NopEdGlaUUlKMHN1dVN1UkJXM1ZMYVdJTnc&hl=en#gid=0
> >
> > Does it include contractors names and amounts?
> >
> > Best,
> > Anders
> >
> >
> >
> > On 3 October 2013 16:33, Gabriela <gabelula at gmail.com> wrote:
> >>
> >> Yes. That information is at
> >> http://www.comprasestatales.gub.uy/sicepublic/SearchCatalogPublic.iface
> >>
> >>
> >>
> >>
> >> 2013/10/3 Anders Pedersen <anders.pedersen at okfn.org>:
> >> > Hi Gabriela,
> >> >
> >> > That sounds good. Two quick questions:
> >> >
> >> > 1) The data from http://agev.opp.gub.uy/advni/#/~/cr-dito-total-2013is
> >> > project/programme level I assume.
> >> > Do you have any data on the spending on contractors (eg. all payments
> to
> >> > IBM
> >> > or Siemens)?
> >> >
> >> > 2) Yes, it would be helpful if you could upload it to the datahub as
> >> > CSV-file.
> >> >
> >> > Best,
> >> > Anders
> >> >
> >> >
> >> >
> >> > On 3 October 2013 16:28, Gabriela <gabelula at gmail.com> wrote:
> >> >>
> >> >> I can upload it to datahub.io if it is needed.
> >> >>
> >> >> 2013/10/3 Gabriela <gabelula at gmail.com>:
> >> >> > Hi!
> >> >> >
> >> >> > The spending data can be found here:
> >> >> > http://agev.opp.gub.uy/advni/#/~/cr-dito-total-2013
> >> >> >
> >> >> > G
> >> >> >
> >> >> > 2013/10/2 Gabriela <gabelula at gmail.com>:
> >> >> >> Wednesday 9th at 6pm UYT that is 5pm EST and 2pm PST.
> >> >> >>
> >> >> >>
> >> >> >> ok. I will create a form so people register for this workshop and
> we
> >> >> >> know how many people to expect. It will also give a way to send
> the
> >> >> >> invite for GH .
> >> >> >>
> >> >> >> I will check into the datasets and datahub.io this week.
> >> >> >>
> >> >> >> G
> >> >> >>
> >> >> >> 2013/10/2 Anders Pedersen <anders.pedersen at okfn.org>:
> >> >> >>> Hi Gabriela,
> >> >> >>>
> >> >> >>> I think Google Hangout is the best option, and so let's limit the
> >> >> >>> participation to Uruguay.
> >> >> >>>
> >> >> >>> For preparation:
> >> >> >>> It would be really helpful if you could share the spending data
> >> >> >>> beforehand
> >> >> >>> (this week if possible). By uploading it to the datahub.io or
> >> >> >>> another
> >> >> >>> site,
> >> >> >>> we would be able to check if the data needs cleaning before being
> >> >> >>> ready to
> >> >> >>> upload to OpenSpending.
> >> >> >>>
> >> >> >>> I will attend the training possibly combined with one of my
> >> >> >>> colleagues.
> >> >> >>>
> >> >> >>> Could you specify the time on Wednesday 9th?
> >> >> >>>
> >> >> >>> Best,
> >> >> >>> Anders
> >> >> >>>
> >> >> >>>
> >> >> >>> On 1 October 2013 17:31, Gabriela <gabelula at gmail.com> wrote:
> >> >> >>>>
> >> >> >>>> GH's limit for video calls is 10 persons. If we are going to do
> it
> >> >> >>>> as
> >> >> >>>> a video call then we will need to find other tool. How do you
> >> >> >>>> usually
> >> >> >>>> do this workshops online? We could do it via skype but you will
> >> >> >>>> have
> >> >> >>>> to have a skype pro account. We need to decide on this because
> we
> >> >> >>>> need
> >> >> >>>> a way to tell people where we meet online for this workshop.
> >> >> >>>>
> >> >> >>>> Other thing about the content of the workshop so we call people
> >> >> >>>> for
> >> >> >>>> it. The idea is for you or you colleage to show us (in english)
> >> >> >>>> how
> >> >> >>>> open spending work and we will try to look at some of the data
> for
> >> >> >>>> uruguay in it? right?
> >> >> >>>>
> >> >> >>>>
> >> >> >>>> 2013/9/30 Gabriela <gabelula at gmail.com>:
> >> >> >>>> > Sure. The only issue with google hangout is the limit, right?
> It
> >> >> >>>> > seems
> >> >> >>>> > to me that GH is better for this type of workshops but I don't
> >> >> >>>> > remember exactly the limit on people able to attend.
> >> >> >>>> >
> >> >> >>>> > 2013/9/30 Anders Pedersen <anders.pedersen at okfn.org>:
> >> >> >>>> >> Perfect Gabriela,
> >> >> >>>> >>
> >> >> >>>> >> Will you prefer Google Hangout or Skype?
> >> >> >>>> >>
> >> >> >>>> >> Would it be OK if we invite other community members from the
> >> >> >>>> >> Americas
> >> >> >>>> >> to
> >> >> >>>> >> join on the training as well?
> >> >> >>>> >>
> >> >> >>>> >> Best,
> >> >> >>>> >> Anders
> >> >> >>>> >>
> >> >> >>>> >>
> >> >> >>>> >> On 30 September 2013 17:27, Gabriela <gabelula at gmail.com>
> >> >> >>>> >> wrote:
> >> >> >>>> >>>
> >> >> >>>> >>> No problem. 6pm UYT works for you? It would be 5pm EDT.
> >> >> >>>> >>>
> >> >> >>>> >>>
> >> >> >>>> >>> 2013/9/30 Anders Pedersen <anders.pedersen at okfn.org>:
> >> >> >>>> >>> > Hi Gabriela,
> >> >> >>>> >>> >
> >> >> >>>> >>> > Apologies the delay. Wednesday October 9th would be
> perfect.
> >> >> >>>> >>> > I
> >> >> >>>> >>> > or a
> >> >> >>>> >>> > colleague should be available all day (EDT), so let me
> know
> >> >> >>>> >>> > what
> >> >> >>>> >>> > works
> >> >> >>>> >>> > for
> >> >> >>>> >>> > you :-)
> >> >> >>>> >>> >
> >> >> >>>> >>> > Best,
> >> >> >>>> >>> > Anders
> >> >> >>>> >>> >
> >> >> >>>> >>> >
> >> >> >>>> >>> > On 30 September 2013 16:12, Gabriela <gabelula at gmail.com>
> >> >> >>>> >>> > wrote:
> >> >> >>>> >>> >>
> >> >> >>>> >>> >> Hi!
> >> >> >>>> >>> >>
> >> >> >>>> >>> >> I'm resending this mail ccing Lucy in case I got Anders
> >> >> >>>> >>> >> mail
> >> >> >>>> >>> >> wrong.
> >> >> >>>> >>> >> We
> >> >> >>>> >>> >> need to change the open spending workshop because we are
> >> >> >>>> >>> >> holding a
> >> >> >>>> >>> >> data exploration the same day and it conflicts with the
> >> >> >>>> >>> >> people
> >> >> >>>> >>> >> that
> >> >> >>>> >>> >> may attend one and the other.
> >> >> >>>> >>> >>
> >> >> >>>> >>> >> saludos,
> >> >> >>>> >>> >> Gaba
> >> >> >>>> >>> >>
> >> >> >>>> >>> >>
> >> >> >>>> >>> >> ---------- Forwarded message ----------
> >> >> >>>> >>> >> From: Gabriela <gabelula at gmail.com>
> >> >> >>>> >>> >> Date: 2013/9/26
> >> >> >>>> >>> >> Subject: Change on Open Spending workshop with Uruguay
> >> >> >>>> >>> >> To: Anders Pedersen <anders.pedersen at okfn.org>
> >> >> >>>> >>> >> CC: "nucleo at datauy.org" <nucleo at datauy.org>
> >> >> >>>> >>> >>
> >> >> >>>> >>> >>
> >> >> >>>> >>> >> Hi!
> >> >> >>>> >>> >>
> >> >> >>>> >>> >> We have a conflicting day with the open spending workshop
> >> >> >>>> >>> >> we
> >> >> >>>> >>> >> agreed
> >> >> >>>> >>> >> upon on during OkCon. We are having a data exploration
> the
> >> >> >>>> >>> >> same day
> >> >> >>>> >>> >> already organized with other groups in Uruguay. Can we
> >> >> >>>> >>> >> change
> >> >> >>>> >>> >> this
> >> >> >>>> >>> >> open spending training (2 hours) for any day during the
> >> >> >>>> >>> >> week
> >> >> >>>> >>> >> from
> >> >> >>>> >>> >> October 7th to October 11th? It will have to be around
> 6pm
> >> >> >>>> >>> >> UYT
> >> >> >>>> >>> >> (5pm
> >> >> >>>> >>> >> Washington DC). Please let me know which day asap so we
> >> >> >>>> >>> >> start
> >> >> >>>> >>> >> promoting it.  Thanks
> >> >> >>>> >>> >>
> >> >> >>>> >>> >> --
> >> >> >>>> >>> >> Gabriela Rodriguez
> >> >> >>>> >>> >> (503) 415 0030
> >> >> >>>> >>> >>
> >> >> >>>> >>> >>
> >> >> >>>> >>> >> --
> >> >> >>>> >>> >> Gabriela Rodriguez
> >> >> >>>> >>> >> (503) 415 0030
> >> >> >>>> >>> >
> >> >> >>>> >>> >
> >> >> >>>> >>> >
> >> >> >>>> >>> >
> >> >> >>>> >>> > --
> >> >> >>>> >>> >
> >> >> >>>> >>> > Anders Pedersen
> >> >> >>>> >>> >
> >> >> >>>> >>> > Community Coordinator  |  skype: anpehej  |  @anpe
> >> >> >>>> >>> >
> >> >> >>>> >>> > The Open Knowledge Foundation
> >> >> >>>> >>> >
> >> >> >>>> >>> > Empowering through Open Knowledge
> >> >> >>>> >>> >
> >> >> >>>> >>> > http://okfn.org/  |  @okfn  |  OKF on Facebook  |  Blog
>  |
> >> >> >>>> >>> > Newsletter
> >> >> >>>> >>> >
> >> >> >>>> >>> >
> >> >> >>>> >>> > OpenSpending | http://openspending.org | @openspending
> >> >> >>>> >>> >
> >> >> >>>> >>> > School of Data | http://schoolofdata.org | @schoolofdata
> >> >> >>>> >>> >
> >> >> >>>> >>> >
> >> >> >>>> >>>
> >> >> >>>> >>>
> >> >> >>>> >>>
> >> >> >>>> >>> --
> >> >> >>>> >>> Gabriela Rodriguez
> >> >> >>>> >>> (503) 415 0030
> >> >> >>>> >>
> >> >> >>>> >>
> >> >> >>>> >>
> >> >> >>>> >>
> >> >> >>>> >> --
> >> >> >>>> >>
> >> >> >>>> >> Anders Pedersen
> >> >> >>>> >>
> >> >> >>>> >> Community Coordinator  |  skype: anpehej  |  @anpe
> >> >> >>>> >>
> >> >> >>>> >> The Open Knowledge Foundation
> >> >> >>>> >>
> >> >> >>>> >> Empowering through Open Knowledge
> >> >> >>>> >>
> >> >> >>>> >> http://okfn.org/  |  @okfn  |  OKF on Facebook  |  Blog  |
> >> >> >>>> >> Newsletter
> >> >> >>>> >>
> >> >> >>>> >>
> >> >> >>>> >> OpenSpending | http://openspending.org | @openspending
> >> >> >>>> >>
> >> >> >>>> >> School of Data | http://schoolofdata.org | @schoolofdata
> >> >> >>>> >>
> >> >> >>>> >>
> >> >> >>>> >
> >> >> >>>> >
> >> >> >>>> >
> >> >> >>>> > --
> >> >> >>>> > Gabriela Rodriguez
> >> >> >>>> > (503) 415 0030
> >> >> >>>>
> >> >> >>>>
> >> >> >>>>
> >> >> >>>> --
> >> >> >>>> Gabriela Rodriguez
> >> >> >>>> (503) 415 0030
> >> >> >>>
> >> >> >>>
> >> >> >>>
> >> >> >>>
> >> >> >>> --
> >> >> >>>
> >> >> >>> Anders Pedersen
> >> >> >>>
> >> >> >>> Community Coordinator  |  skype: anpehej  |  @anpe
> >> >> >>>
> >> >> >>> The Open Knowledge Foundation
> >> >> >>>
> >> >> >>> Empowering through Open Knowledge
> >> >> >>>
> >> >> >>> http://okfn.org/  |  @okfn  |  OKF on Facebook  |  Blog  |
> >> >> >>> Newsletter
> >> >> >>>
> >> >> >>>
> >> >> >>> OpenSpending | http://openspending.org | @openspending
> >> >> >>>
> >> >> >>> School of Data | http://schoolofdata.org | @schoolofdata
> >> >> >>>
> >> >> >>>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Gabriela Rodriguez
> >> >> >> (503) 415 0030
> >> >> >
> >> >> >
> >> >> >
> >> >> > --
> >> >> > Gabriela Rodriguez
> >> >> > (503) 415 0030
> >> >>
> >> >>
> >> >>
> >> >> --
> >> >> Gabriela Rodriguez
> >> >> (503) 415 0030
> >> >
> >> >
> >> >
> >> >
> >> > --
> >> >
> >> > Anders Pedersen
> >> >
> >> > Community Coordinator  |  skype: anpehej  |  @anpe
> >> >
> >> > The Open Knowledge Foundation
> >> >
> >> > Empowering through Open Knowledge
> >> >
> >> > http://okfn.org/  |  @okfn  |  OKF on Facebook  |  Blog  |
>  Newsletter
> >> >
> >> >
> >> > OpenSpending | http://openspending.org | @openspending
> >> >
> >> > School of Data | http://schoolofdata.org | @schoolofdata
> >> >
> >> >
> >>
> >>
> >>
> >> --
> >> Gabriela Rodriguez
> >> (503) 415 0030
> >
> >
> >
> >
> > --
> >
> > Anders Pedersen
> >
> > Community Coordinator  |  skype: anpehej  |  @anpe
> >
> > The Open Knowledge Foundation
> >
> > Empowering through Open Knowledge
> >
> > http://okfn.org/  |  @okfn  |  OKF on Facebook  |  Blog  |  Newsletter
> >
> >
> > OpenSpending | http://openspending.org | @openspending
> >
> > School of Data | http://schoolofdata.org | @schoolofdata
> >
> >
>
>
>
> --
> Gabriela Rodriguez
> (503) 415 0030
>

-- 
*

Anders Pedersen

Community Coordinator  |  skype: anpehej  |  @anpe <https://twitter.com/>

The Open Knowledge Foundation <http://okfn.org/>

Empowering through Open Knowledge

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>

*

OpenSpending | http://openspending.org |
@openspending<http://twitter.com/openspending>

School of Data | http://schoolofdata.org |
@schoolofdata<http://twitter.com/schoolofdata>

*

**

*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/os-datawrangling/attachments/20131004/10f64e8e/attachment.html>