Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Intro a Google Refine

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for dcabo dcabo
May 25, 2013
640
0

Intro a Google Refine

Avatar for dcabo

dcabo

May 25, 2013

More Decks by dcabo

See All by dcabo
Open Data y Transparencia
Avatar for dcabo dcabo
0
75
Mejorando el periodismo con Ruby
Avatar for dcabo dcabo
0
600
Reutilización de datos y transparencia
Avatar for dcabo dcabo
3
350
Preparando datos para su análisis
Avatar for dcabo dcabo
0
630
Beyond FOIA (FOIA and Technology)
Avatar for dcabo dcabo
1
89
Open Data y Transparencia
Avatar for dcabo dcabo
0
200
¿Dónde van mis impuestos?
Avatar for dcabo dcabo
3
250
Casos prácticos de la reutilización de datos públicos
Avatar for dcabo dcabo
2
140
Against the Spanish odds (the techie side)
Avatar for dcabo dcabo
3
280

Featured

See All Featured
Joys of Absence: A Defence of Solitary Play
Avatar for Sebastian Deterding codingconduct
1
360
Fireside Chat
Avatar for paigeccino paigeccino
42
3.9k
Are puppies a ranking factor?
Avatar for Jono Alderson jonoalderson
1
3.4k
Music & Morning Musume
Avatar for Bryan Veloso bryan
47
7.2k
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore lauravandoore
463
34k
Deep Space Network (abreviated)
Avatar for Tony Rice tonyrice
0
140
Stop Working from a Prison Cell
Avatar for Chris Michel hatefulcrawdad
274
21k
Why Your Marketing Sucks and What You Can Do About It - Sophie Logan
Avatar for Sophie Logan marketingsoph
0
140
Conquering PDFs: document understanding beyond plain text
Avatar for Ines Montani inesmontani
PRO
4
2.7k
Building Better People: How to give real-time feedback that sticks.
Avatar for Will Jessup wjessup
370
20k
WENDY [Excerpt]
Avatar for Tessa Abrams tessaabrams
10
37k
Done Done
Avatar for chrislema chrislema
186
16k

Transcript

  1. Limpiando datos con Google Refine David Cabo (@dcabo) [email protected]

  2. Limpiando datos • Refine: Herramienta de exploración y limpieza de

    datos • Proceso • 1. Obtener los datos • 2. Limpiarlos con Refine • 3. Analizarlos: Excel, Open Office, R...

  3. ¿Qué puede hacer? • Filtrar y agrupar datos por distintos

    criterios • Aplicar transformaciones a los datos • Unir/partir columnas • Verificar con bases de datos externas:FreeBase, Open Corporates... • Clustering: limpieza basada en similitudes: corrección de erratas • ...