Using SQL for data consolidation in R

Working with multiple data sources implies data cleaning and consolidation prior to analysis. R has become popular among social scientists (Kelley, 2007; Clark, 2014), who are advised to screen data in a “favorite spreadsheet program” (Muenchen, 2011:21), before importing it to R. This way, users av...

Descripción completa

Guardado en:
Detalles Bibliográficos
Autores principales: Vinas Forcade, Jennifer, Nacci, Julien, Mels, Cindy, Valcke, Martin, Derluyn, Ilse
Formato: Objeto de conferencia Resumen
Lenguaje:Inglés
Publicado: 2018
Materias:
Ciencias Informáticas
SQL
sqldf, R
database consolidation
data cleaning
R.
Acceso en línea:http://sedici.unlp.edu.ar/handle/10915/72795
http://47jaiio.sadio.org.ar/sites/default/files/LatinR_57.pdf
Aporte de:
SEDICI (UNLP) de Universidad Nacional de La Plata
id I19-R120-10915-72795
record_format dspace
institution Universidad Nacional de La Plata
institution_str I-19
repository_str R-120
collection SEDICI (UNLP)
language Inglés
topic Ciencias Informáticas
SQL
sqldf, R
database consolidation
data cleaning
R.
spellingShingle Ciencias Informáticas
SQL
sqldf, R
database consolidation
data cleaning
R.
Vinas Forcade, Jennifer
Nacci, Julien
Mels, Cindy
Valcke, Martin
Derluyn, Ilse
Using SQL for data consolidation in R
topic_facet Ciencias Informáticas
SQL
sqldf, R
database consolidation
data cleaning
R.
description Working with multiple data sources implies data cleaning and consolidation prior to analysis. R has become popular among social scientists (Kelley, 2007; Clark, 2014), who are advised to screen data in a “favorite spreadsheet program” (Muenchen, 2011:21), before importing it to R. This way, users avoid typing in the R console and are supported by a graphical user interface. Even for experienced R users, querying/ retrieving data from multiple large sources takes a lot of computing power, which is better handled by SQL language (Table 2; KeyCentrix, 2015).
format Objeto de conferencia
Resumen
author Vinas Forcade, Jennifer
Nacci, Julien
Mels, Cindy
Valcke, Martin
Derluyn, Ilse
author_facet Vinas Forcade, Jennifer
Nacci, Julien
Mels, Cindy
Valcke, Martin
Derluyn, Ilse
author_sort Vinas Forcade, Jennifer
title Using SQL for data consolidation in R
title_short Using SQL for data consolidation in R
title_full Using SQL for data consolidation in R
title_fullStr Using SQL for data consolidation in R
title_full_unstemmed Using SQL for data consolidation in R
title_sort using sql for data consolidation in r
publishDate 2018
url http://sedici.unlp.edu.ar/handle/10915/72795
http://47jaiio.sadio.org.ar/sites/default/files/LatinR_57.pdf
work_keys_str_mv AT vinasforcadejennifer usingsqlfordataconsolidationinr
AT naccijulien usingsqlfordataconsolidationinr
AT melscindy usingsqlfordataconsolidationinr
AT valckemartin usingsqlfordataconsolidationinr
AT derluynilse usingsqlfordataconsolidationinr
bdutipo_str Repositorios
_version_ 1764820483181641731

Ejemplares similares