<div dir="ltr"><div>Dá uma olhada nesse post:</div><div><br></div><a href="http://rcoster.blogspot.com.br/2014/02/lendo-grandes-bancos-de-dados.html">http://rcoster.blogspot.com.br/2014/02/lendo-grandes-bancos-de-dados.html</a><br></div><div class="gmail_extra"><br><div class="gmail_quote">Em 2 de outubro de 2016 08:36, Marcos Silva <span dir="ltr"><<a href="mailto:marcosfs2006@gmail.com" target="_blank">marcosfs2006@gmail.com</a>></span> escreveu:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">André,<div><br></div><div>Este tipo de arquivo não tem um caractere delimitador, tal como virgula, ponto e virgula, pipe ("|"), Você não vai conseguir importar com read.table() e derivações (read.csv(), read.csv2()) ou mesmo com fread().</div><div><br></div><div>Mas para vc "ler" esse arquivo, vc precisa saber qual o comprimento de cada variável (quantidade de caracteres que ocupa no arquivo), informação essa que deveria estar no dicionário de variáveis.<br></div><div><br></div><div>Este tipo de arquivo vc importa com read.fwf() ou read_fwf() do pacote readr. Mas como essa base é muito grande, recomendo utilizar algum pacote, a exemplo do pacote LaF. Existem outras possibilidades talvez melhores.</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><div><div class="h5"><br><div class="gmail_quote">Em 2 de outubro de 2016 03:13, Andre Oliveira <span dir="ltr"><<a href="mailto:andreolsouza@yahoo.com.br" target="_blank">andreolsouza@yahoo.com.br</a>></span> escreveu:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="color:#000;background-color:#fff;font-family:bookman old style,new york,times,serif;font-size:16px"><div id="m_-3874261699229706095m_3037608916558264409yui_3_16_0_ym19_1_1475388494133_3709">Oi Marcos,</div><div dir="ltr" id="m_-3874261699229706095m_3037608916558264409yui_3_16_0_ym19_1_1475388494133_3682">neste dicionário fala que é <span id="m_-3874261699229706095m_3037608916558264409yui_3_16_0_ym19_1_1475388494133_5750"><span id="m_-3874261699229706095m_3037608916558264409yui_3_16_0_ym19_1_1475388494133_5751"><span id="m_-3874261699229706095m_3037608916558264409yui_3_16_0_ym19_1_1475388494133_5752"><span id="m_-3874261699229706095m_3037608916558264409yui_3_16_0_ym19_1_1475388494133_5753"><span id="m_-3874261699229706095m_3037608916558264409yui_3_16_0_ym19_1_1475388494133_5754"> formato em formato ASCII. Não tem mais instruções pelo que percebi. Descreve os nomes da varáveis também! </span></span></span></span></span> </div><span><div id="m_-3874261699229706095m_3037608916558264409yui_3_16_0_ym19_1_1475388494133_3683"><span></span></div><div id="m_-3874261699229706095m_3037608916558264409yui_3_16_0_ym19_1_1475388494133_3712"> </div><div class="m_-3874261699229706095m_3037608916558264409signature" id="m_-3874261699229706095m_3037608916558264409yui_3_16_0_ym19_1_1475388494133_3711">André Oliveira Souza. 
 Graduação em Matemática, mestrado em estatística aplicada.Instituto Federal de Educação, Ciência e Tecnologia do Espirito Santo.  IFES</div> <div class="m_-3874261699229706095m_3037608916558264409qtdSeparateBR"><br><br></div></span><div class="m_-3874261699229706095m_3037608916558264409yahoo_quoted" style="display:block"> <div style="font-family:bookman old style,new york,times,serif;font-size:16px"> <div style="font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:16px"><span> <div dir="ltr"><font size="2" face="Arial"> Em Domingo, 2 de Outubro de 2016 0:13, Marcos Silva <<a href="mailto:marcosfs2006@gmail.com" target="_blank">marcosfs2006@gmail.com</a>> escreveu:<br></font></div>  <br><br> </span><div class="m_-3874261699229706095m_3037608916558264409y_msg_container"><div id="m_-3874261699229706095m_3037608916558264409yiv1691817436"><div><span><div dir="ltr">Acho que este e um arquivo de formato fixo. Vc vai precisar do dicionario de dados para importar. Normalmente este dicionario e disponibilizado com os dados pelo inep.</div>
</span><div class="m_-3874261699229706095m_3037608916558264409yiv1691817436gmail_extra"><br clear="none"><div class="m_-3874261699229706095m_3037608916558264409yiv1691817436gmail_quote"><span>Em 01/10/2016 22:31, "Andre Oliveira via R-br" <<a rel="nofollow" shape="rect" href="mailto:r-br@listas.c3sl.ufpr.br" target="_blank">r-br@listas.c3sl.ufpr.br</a>> escreveu:<br clear="none"></span><blockquote class="m_-3874261699229706095m_3037608916558264409yiv1691817436gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="m_-3874261699229706095m_3037608916558264409yiv1691817436yqt1834513401" id="m_-3874261699229706095m_3037608916558264409yiv1691817436yqt82642"><div><div style="color:#000;background-color:#fff;font-family:bookman old style,new york,times,serif;font-size:16px"><span><div dir="ltr" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2161"><span id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2469">Boa noite,</span></div><div dir="ltr" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2640"><span id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2469">não estou conseguindo identificar o motivo de não abrir este arquivo .txt corretamente, ele tem em torno de <a rel="nofollow" shape="rect" class="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160edited-link-editor" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_4887" href="http://portal.inep.gov.br/basica-levantamentos-microdados" target="_blank">6.3 GB</a></span></div><div dir="ltr" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_5090"><span id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2469">Alguém teria uma dica para compartilhar? Acredito que não estou trabalhando corretamente! <br clear="none"></span></div><div dir="ltr" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_5446"><span id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2469"><br clear="none"></span></div></span><div dir="ltr" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2662"><span id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2469">library(data.table)<br id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2480" clear="none">readLines("DADOS_ENEM_2011. TXT", n = 1) <br clear="none"></span></div><div dir="ltr" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_5525"><span id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2469"><br clear="none"></span></div><div dir="ltr" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_5484"><b id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_5504"><span id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2469">[1] "3000000000012011 2803548708SAO BERNARDO DO CAMPO                                                                                                                                     SP110000000000000000000011        .      .                                                                                                                                                             ...3548708SAO BERNARDO DO CAMPO                                                                                                                                     SP1111   577.10   576.00   575.50   737. 10CEBDCACBEAABBAABAEBDCABDCDEA AADCBBEBADDBEBECDDEECABABEBDDE BAEADCACABCBBECADDAADBADDAABAB CAEEAEAEDDDAAEEBDECADCEABDDBAE CAAABDAEBCCACBAECBAEBECCAAEBAB ECECCDDAACDADADBACCBAADCAECCCE DD1241201251290CECDDACBCAEBEBB ACEEDCAEBDAEDADBEBBDDADCBCBACD DEECEBABAADDEBAECDCACEDCBBEBCD CAADBADDDBAEACAEEDBDBDDCAEDDDA CDEBBECAACDABADBAECCEADDCEBCBA CBAEEBAEEECCEEEBCBECEBADCBDBEA DCDBDCCCBADCAECCCCDDP   140.00   140.00   140.00   140.00    60.00   620.000 .       .      .                                                                                          <br clear="none"></span></b></div><span><div dir="ltr" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_5489"><span id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2469"><br clear="none"></span></div><div dir="ltr" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_5498"><span id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2469">require(bit64) <br id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2482" clear="none">enem2011<- fread("DADOS_ENEM_2011.TXT", nrow = 1, header = TRUE, sep=";")<br id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2483" clear="none">head(enem2011)<br clear="none"></span></div><div dir="ltr" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_5089"><span id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2469"><br id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2484" clear="none"></span></div></span><div dir="ltr" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2701"><span id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2469">3000000000012011 2803548708SAO BERNARDO DO CAMPO                                                                                                                                     SP110000000000000000000011        .      .                                                                                                                                                             ...3548708SAO BERNARDO DO CAMPO                                                                                                                                     SP1111   577.10   576.00   575.50   737. 10CEBDCACBEAABBAABAEBDCABDCDEA AADCBBEBADDBEBECDDEECABABEBDDE BAEADCACABCBBECADDAADBADDAABAB CAEEAEAEDDDAAEEBDECADCEABDDBAE CAAABDAEBCCACBAECBAEBECCAAEBAB ECECCDDAACDADADBACCBAADCAECCCE DD1241201251290CECDDACBCAEBEBB ACEEDCAEBDAEDADBEBBDDADCBCBACD DEECEBABAADDEBAECDCACEDCBBEBCD CAADBADDDBAEACAEEDBDBDDCAEDDDA CDEBBECAACDABADBAECCEADDCEBCBA CBAEEBAEEECCEEEBCBECEBADCBDBEA DCDBDCCCBADCAECCCCDDP   140.00   140.00   140.00   140.00    60.00   620.000 .       .      .                                                                                                                                                             ...<br id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2707" clear="none">1: 3000000000022011 2214125506SAO JOSE DOS PINHAIS                                                                                                                                      PR110000000000000000000011        .      .                                                                                                                                                             ...4125506SAO JOSE DOS PINHAIS                                                                                                                                      PR0000      .        .        .        .                                                                                                                                                                                            1211171251290DCEACDBECBCAEBACB EAECEDEDAABDBEDBBDDDCABCBDCAED EBCEAEDBDAACACECDBBCACEDCDCBAE ADADBBDDEAABAEEDBDBDDCAEDDDACD EBBECAACDABADBAECCEADDCEBCBACB AEEBAEEECCEEEBCBECEBADCBDBEADC DBDCCCBADCAECCCCDDF     0.00     0.00     0.00     0.00     0.00     0.000 .       .      .                                                 </span></div><span><div id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2087"><div id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_2670"> </div><div dir="ltr" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_5515">obrigado. <br clear="none"></div><div id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_5529"><br clear="none"></div><div id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_5527"><br clear="none"></div></div><div class="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160signature" id="m_-3874261699229706095m_3037608916558264409yiv1691817436m_-1712471352952863160yui_3_16_0_ym19_1_1475371361949_5528">André Oliveira Souza. 
 Graduação em Matemática, mestrado em estatística aplicada.Instituto Federal de Educação, Ciência e Tecnologia do Espirito Santo.  IFES</div></span></div></div></div><span><br clear="none">______________________________ _________________<br clear="none">
R-br mailing list<br clear="none">
<a rel="nofollow" shape="rect" href="mailto:R-br@listas.c3sl.ufpr.br" target="_blank">R-br@listas.c3sl.ufpr.br</a><br clear="none">
<a rel="nofollow" shape="rect" href="https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br" target="_blank">https://listas.inf.ufpr.br/ cgi-bin/mailman/listinfo/r-br</a><br clear="none"></span>
Leia o guia de postagem (<a rel="nofollow" shape="rect" href="http://www.leg.ufpr.br/r-br-guia" target="_blank">http://www.leg.ufpr.br/r-br- guia</a>) e forneça código mínimo reproduzível.<br clear="none"></blockquote></div></div>
</div></div><br><br></div>  </div> </div>  </div></div></div></blockquote></div><br><br clear="all"><div><br></div></div></div><span class="HOEnZb"><font color="#888888">-- <br><div class="m_-3874261699229706095gmail_signature" data-smartmail="gmail_signature">Marcos F. Silva<br><a href="http://sites.google.com/site/marcosfs2006" target="_blank">http://sites.google.com/site/<wbr>marcosfs2006</a></div>
</font></span></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Marcos F. Silva<br><a href="http://sites.google.com/site/marcosfs2006" target="_blank">http://sites.google.com/site/marcosfs2006</a></div>
</div>