Skip to content

Instantly share code, notes, and snippets.

@metodologia
Last active December 17, 2015 00:10
Show Gist options
  • Save metodologia/5518673 to your computer and use it in GitHub Desktop.
Save metodologia/5518673 to your computer and use it in GitHub Desktop.
Microdados com R - Parte 4
# ----------------------------------------------
# Acessar dados de arquivo csv via sqldf
# instalar o pacote sqldf()
#install.packages(sqldf)
# carregar o pacote
library(sqldf)
# listar itens no diretório de trabalho
dir()
#acessar dados selecionados em um arquivo csv
a <- read.csv2.sql('2011_PES.csv', sql=" select V0101, UF, V0302, V8005, V0404, V4011, V06111, V06112, V9906, V9008, V9532, V4729 from file where V9906=2141 ", header=TRUE, sep=";")
ls()
dim(a)
names(a)
head(a,15)
# ----------------------------------------------
{{código do R – Fim}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment