<div dir="ltr">Prezados,<div><br></div><div>Gostaria de uma ajuda na manipulação de um arquivo JSON dentro do R.</div><div><br></div><div>O arquivo tem as variáveis <b>_id</b>, <b>last_seen</b>, <b>section_views</b>, <b>urls </b>e <b>urls_seen </b>e segue a seguinte estrutura:</div>
<div><br></div><div><span style="color:rgb(255,0,0)">{</span><br></div><div><div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"_id" : "<a href="mailto:2minformatica@uol.com.br">2minformatica@uol.com.br</a>",</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"last_seen" : "2014-06-04T23:12:44.426Z",</font></div><div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"section_views" : {</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"blogs．lancenet．com．br/palestra" : 1,</font></div><div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"www．lancenet．com．br" : 3,</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"www．lancenet．com．br/flamengo" : 1,</font></div><div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"www．lancenet．com．br/futebol" : 1,</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"www．lancenet．com．br/minuto" : 1,</font></div><div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"www．lancenet．com．br/palmeiras" : 5</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>},</font></div><div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"urls" : [</font></div><div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://www.lancenet.com.br/minuto/Palmeiras-Alberto_Valentim_0_1148885234.html">www.lancenet.com.br/minuto/Palmeiras-Alberto_Valentim_0_1148885234.html</a>",</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://blogs.lancenet.com.br/palestra/2014/06/01/diogo-fica-mais-forte-no-ataque-do-palmeiras">blogs.lancenet.com.br/palestra/2014/06/01/diogo-fica-mais-forte-no-ataque-do-palmeiras</a>",</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://www.lancenet.com.br/palmeiras">www.lancenet.com.br/palmeiras</a>",</font></div><div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://www.lancenet.com.br/palmeiras/Uruguaios-citam-saida-Eguren-empresario_0_1150085149.html">www.lancenet.com.br/palmeiras/Uruguaios-citam-saida-Eguren-empresario_0_1150085149.html</a>",</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://www.lancenet.com.br/futebol/Contrato-Neilton-despede-Santos-Aprendi_0_1147685430.html">www.lancenet.com.br/futebol/Contrato-Neilton-despede-Santos-Aprendi_0_1147685430.html</a>",</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://www.lancenet.com.br/flamengo/Andre-Santos-retorna-Fenerbahce-proposta_0_1150085006.html">www.lancenet.com.br/flamengo/Andre-Santos-retorna-Fenerbahce-proposta_0_1150085006.html</a>",</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://www.lancenet.com.br/palmeiras/Pratto-aguarda-Palmeiras-melhor-aceita_0_1150085180.html">www.lancenet.com.br/palmeiras/Pratto-aguarda-Palmeiras-melhor-aceita_0_1150085180.html</a>"</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>],</font></div><div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"urls_seen" : [</font></div><div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://www.lancenet.com.br/minuto/Palmeiras-Alberto_Valentim_0_1148885234.html">www.lancenet.com.br/minuto/Palmeiras-Alberto_Valentim_0_1148885234.html</a>",</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://blogs.lancenet.com.br/palestra/2014/06/01/diogo-fica-mais-forte-no-ataque-do-palmeiras">blogs.lancenet.com.br/palestra/2014/06/01/diogo-fica-mais-forte-no-ataque-do-palmeiras</a>",</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://www.lancenet.com.br">www.lancenet.com.br</a>",</font></div><div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://www.lancenet.com.br/palmeiras">www.lancenet.com.br/palmeiras</a>",</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://www.lancenet.com.br/palmeiras/Uruguaios-citam-saida-Eguren-empresario_0_1150085149.html">www.lancenet.com.br/palmeiras/Uruguaios-citam-saida-Eguren-empresario_0_1150085149.html</a>",</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://www.lancenet.com.br/futebol/Contrato-Neilton-despede-Santos-Aprendi_0_1147685430.html">www.lancenet.com.br/futebol/Contrato-Neilton-despede-Santos-Aprendi_0_1147685430.html</a>",</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://www.lancenet.com.br/flamengo/Andre-Santos-retorna-Fenerbahce-proposta_0_1150085006.html">www.lancenet.com.br/flamengo/Andre-Santos-retorna-Fenerbahce-proposta_0_1150085006.html</a>",</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>"<a href="http://www.lancenet.com.br/palmeiras/Pratto-aguarda-Palmeiras-melhor-aceita_0_1150085180.html">www.lancenet.com.br/palmeiras/Pratto-aguarda-Palmeiras-melhor-aceita_0_1150085180.html</a>"</font></div>
<div><font color="#ff0000"><span class="" style="white-space:pre"> </span>]</font></div><div><font color="#ff0000">}</font></div></div><div><br></div><div>Eu preciso colocar este dados em uma 'tabela' da seguinte maneira:</div>
<div><br></div><div><div align="center">
<table class="" border="0" cellspacing="0" cellpadding="0" width="664" style="width:498pt;margin-left:2.75pt;border-collapse:collapse">
<tbody><tr style="height:15pt">
<td width="181" nowrap style="width:136pt;border:1pt solid windowtext;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="color:black">_id</span></b></p>
</td>
<td width="165" nowrap style="width:124pt;border-style:solid solid solid none;border-top-color:windowtext;border-right-color:windowtext;border-bottom-color:windowtext;border-top-width:1pt;border-right-width:1pt;border-bottom-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="color:black">last_seen</span></b></p>
</td>
<td width="317" nowrap style="width:238pt;border-style:solid solid solid none;border-top-color:windowtext;border-right-color:windowtext;border-bottom-color:windowtext;border-top-width:1pt;border-right-width:1pt;border-bottom-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="color:black">section_views</span></b></p>
</td>
</tr>
<tr style="height:15pt">
<td width="181" nowrap valign="bottom" style="width:136pt;border-style:none solid solid;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;border-right-width:1pt;border-bottom-width:1pt;border-left-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><u><span style="font-size:10pt;color:blue"><a href="mailto:2minformatica@uol.com.br"><span style="color:blue">2minformatica@uol.com.br</span></a></span></u></p>
</td>
<td width="165" nowrap valign="bottom" style="width:124pt;border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><span style="font-size:10pt;color:black">2014-06-04T23:12:44.426Z</span></p>
</td>
<td width="317" nowrap valign="bottom" style="width:238pt;border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><span style="font-size:10pt;color:black">"blogs</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">lancenet</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">com</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">br/palestra</span><span style="font-size:10pt;color:black">"
: 1,</span></p>
</td>
</tr>
<tr style="height:15pt">
<td width="181" nowrap valign="bottom" style="width:136pt;border-style:none solid solid;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;border-right-width:1pt;border-bottom-width:1pt;border-left-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><u><span style="font-size:10pt;color:blue"><a href="mailto:2minformatica@uol.com.br"><span style="color:blue">2minformatica@uol.com.br</span></a></span></u></p>
</td>
<td width="165" nowrap valign="bottom" style="width:124pt;border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><span style="font-size:10pt;color:black">2014-06-04T23:12:44.426Z</span></p>
</td>
<td width="317" nowrap valign="bottom" style="width:238pt;border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><span style="font-size:10pt;color:black">"www</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">lancenet</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">com</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">br</span><span style="font-size:10pt;color:black">"
: 3,</span></p>
</td>
</tr>
<tr style="height:15pt">
<td width="181" nowrap valign="bottom" style="width:136pt;border-style:none solid solid;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;border-right-width:1pt;border-bottom-width:1pt;border-left-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><u><span style="font-size:10pt;color:blue"><a href="mailto:2minformatica@uol.com.br"><span style="color:blue">2minformatica@uol.com.br</span></a></span></u></p>
</td>
<td width="165" nowrap valign="bottom" style="width:124pt;border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><span style="font-size:10pt;color:black">2014-06-04T23:12:44.426Z</span></p>
</td>
<td width="317" nowrap valign="bottom" style="width:238pt;border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><span style="font-size:10pt;color:black">"www</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">lancenet</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">com</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">br/flamengo</span><span style="font-size:10pt;color:black">"
: 1,</span></p>
</td>
</tr>
<tr style="height:15pt">
<td width="181" nowrap valign="bottom" style="width:136pt;border-style:none solid solid;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;border-right-width:1pt;border-bottom-width:1pt;border-left-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><u><span style="font-size:10pt;color:blue"><a href="mailto:2minformatica@uol.com.br"><span style="color:blue">2minformatica@uol.com.br</span></a></span></u></p>
</td>
<td width="165" nowrap valign="bottom" style="width:124pt;border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><span style="font-size:10pt;color:black">2014-06-04T23:12:44.426Z</span></p>
</td>
<td width="317" nowrap valign="bottom" style="width:238pt;border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><span style="font-size:10pt;color:black">"www</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">lancenet</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">com</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">br/futebol</span><span style="font-size:10pt;color:black">"
: 1,</span></p>
</td>
</tr>
<tr style="height:15pt">
<td width="181" nowrap valign="bottom" style="width:136pt;border-style:none solid solid;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;border-right-width:1pt;border-bottom-width:1pt;border-left-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><u><span style="font-size:10pt;color:blue"><a href="mailto:2minformatica@uol.com.br"><span style="color:blue">2minformatica@uol.com.br</span></a></span></u></p>
</td>
<td width="165" nowrap valign="bottom" style="width:124pt;border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><span style="font-size:10pt;color:black">2014-06-04T23:12:44.426Z</span></p>
</td>
<td width="317" nowrap valign="bottom" style="width:238pt;border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><span style="font-size:10pt;color:black">"www</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">lancenet</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">com</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">br/minuto</span><span style="font-size:10pt;color:black">"
: 1,</span></p>
</td>
</tr>
<tr style="height:15pt">
<td width="181" nowrap valign="bottom" style="width:136pt;border-style:none solid solid;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;border-right-width:1pt;border-bottom-width:1pt;border-left-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><u><span style="font-size:10pt;color:blue"><a href="mailto:2minformatica@uol.com.br"><span style="color:blue">2minformatica@uol.com.br</span></a></span></u></p>
</td>
<td width="165" nowrap valign="bottom" style="width:124pt;border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><span style="font-size:10pt;color:black">2014-06-04T23:12:44.426Z</span></p>
</td>
<td width="317" nowrap valign="bottom" style="width:238pt;border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;padding:0cm 3.5pt;height:15pt">
<p class="MsoNormal" align="left"><span style="font-size:10pt;color:black">"www</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">lancenet</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">com</span><span style="font-size:10pt;font-family:'MS Gothic';color:black">．</span><span style="font-size:10pt;color:black">br/palmeiras</span><span style="font-size:10pt;color:black">"
: 5</span></p>
</td>
</tr>
</tbody></table>
</div></div><div><br></div><div><br clear="all"><div>A princípio pretendo utilizar apenas as variáveis <b>_id</b>, <b>last_seen </b>e <b>section_view</b>.</div><div><br></div><div>Desde já agradeço por qualquer ajuda.</div>
<div><br></div><div>Abraços.</div>-- <br><div dir="ltr"><span style="font-family:Calibri,'Segoe UI',Meiryo,'Microsoft YaHei UI','Microsoft JhengHei UI','Malgun Gothic','Khmer UI','Nirmala UI',Tunga,'Lao UI',Ebrima,sans-serif;font-size:16px">Atenciosamente,</span><br style="font-family:Calibri,'Segoe UI',Meiryo,'Microsoft YaHei UI','Microsoft JhengHei UI','Malgun Gothic','Khmer UI','Nirmala UI',Tunga,'Lao UI',Ebrima,sans-serif;font-size:16px">
<br style="font-family:Calibri,'Segoe UI',Meiryo,'Microsoft YaHei UI','Microsoft JhengHei UI','Malgun Gothic','Khmer UI','Nirmala UI',Tunga,'Lao UI',Ebrima,sans-serif;font-size:16px">
<span style="font-family:Calibri,'Segoe UI',Meiryo,'Microsoft YaHei UI','Microsoft JhengHei UI','Malgun Gothic','Khmer UI','Nirmala UI',Tunga,'Lao UI',Ebrima,sans-serif;font-size:16px">Lincoln T Neves</span><br style="font-family:Calibri,'Segoe UI',Meiryo,'Microsoft YaHei UI','Microsoft JhengHei UI','Malgun Gothic','Khmer UI','Nirmala UI',Tunga,'Lao UI',Ebrima,sans-serif;font-size:16px">
<a value="+552188833632" style="color:rgb(17,85,204);font-family:Calibri,'Segoe UI',Meiryo,'Microsoft YaHei UI','Microsoft JhengHei UI','Malgun Gothic','Khmer UI','Nirmala UI',Tunga,'Lao UI',Ebrima,sans-serif;font-size:16px">+55 21 96426-2949</a><br style="font-family:Calibri,'Segoe UI',Meiryo,'Microsoft YaHei UI','Microsoft JhengHei UI','Malgun Gothic','Khmer UI','Nirmala UI',Tunga,'Lao UI',Ebrima,sans-serif;font-size:16px">
<a href="mailto:lincolnthiago.neves@gmail.com" style="color:rgb(17,85,204);font-family:Calibri,'Segoe UI',Meiryo,'Microsoft YaHei UI','Microsoft JhengHei UI','Malgun Gothic','Khmer UI','Nirmala UI',Tunga,'Lao UI',Ebrima,sans-serif;font-size:16px" target="_blank">lincolnthiago.neves@gmail.com</a><br style="font-family:Calibri,'Segoe UI',Meiryo,'Microsoft YaHei UI','Microsoft JhengHei UI','Malgun Gothic','Khmer UI','Nirmala UI',Tunga,'Lao UI',Ebrima,sans-serif;font-size:16px">
<a href="http://www.lincolntneves.weebly.com/" style="color:rgb(17,85,204);font-family:Calibri,'Segoe UI',Meiryo,'Microsoft YaHei UI','Microsoft JhengHei UI','Malgun Gothic','Khmer UI','Nirmala UI',Tunga,'Lao UI',Ebrima,sans-serif;font-size:16px" target="_blank">www.lincolntneves.weebly.com</a><br>
</div>
</div></div>