<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div><span>Jackson,</span></div><div id="yui_3_16_0_ym19_1_1498438453280_41965"><span><br></span></div><div id="yui_3_16_0_ym19_1_1498438453280_41964"><span id="yui_3_16_0_ym19_1_1498438453280_41963">Se a quantidade de medidas que você possui for alta, entao o seu conjunto de dados é um perfeito candidato para pacotes que trabalhem com big data. </span>A minha recomendação é o data.table, porque ele é otimizado para trabalhar com dados de tamanho na casa das dezenas ou centenas de gigabytes. </div><div id="yui_3_16_0_ym19_1_1498438453280_41964"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41216"><span id="yui_3_16_0_ym19_1_1498438453280_42191">A seguir eu vou mostrar um exemplo da sumarizacao que você precisa fazer, baseado em dados aleatórios de temperatura gerados no próprio exemplo. Gerei dados de temperatura porque a variabilidade dos dados é mais previsível, mas é só para você ter ideia de como funciona e adaptar para o seu caso.</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41216"><span><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41216"><span id="yui_3_16_0_ym19_1_1498438453280_42240">O truque do código é separar a data em dia, mes e ano, e rodar o comando de sumarização para a frequencia que voce precisa (diaria, mensal etc). Veja o codigo a seguir e reporte de volta caso tenha alguma duvida.</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41216"><span><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41315"># Cria sequencia de datas</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41316">idx = seq(as.Date("1961/1/1"), as.Date("2010/12/31"), by = "day")</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41317"><br id="yui_3_16_0_ym19_1_1498438453280_41318"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41319"># Cria sequencia aleatória de temperatura entre 10C e 30C</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41320">temp = runif(10, 30, n=length(idx))</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41321"><br id="yui_3_16_0_ym19_1_1498438453280_41322"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41323"># Organiza tudo em data frame, incluindo data "separada" em ano, mes e dia</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41324">DF <- data.frame(date=idx,</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41325"> year=as.numeric(format(idx, format="%Y")),</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41326"> month=as.numeric(format(idx, format="%m")),</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41327"> day=as.numeric(format(idx, format="%d")),</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41328"> temp=temp)</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41329"><br id="yui_3_16_0_ym19_1_1498438453280_41330"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41331"># Carrega pacote e converte data frame em data table</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41332">library(data.table)</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41333">DT <- data.table(DF)</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41334"><br id="yui_3_16_0_ym19_1_1498438453280_41335"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41336"># Roda as operações de sumarização que voce precisa</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41336"># Obviamente substitua mean por sum para somar os seus dados reais.</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41337">dt1 <- DT[, mean(temp), by = "day"]</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41216"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41338">dt2 <- DT[, mean(temp), by = c("day","month")]</div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41339"><br id="yui_3_16_0_ym19_1_1498438453280_41340"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1498438453280_41339">Espero que ajude,</div><div class="signature" id="yui_3_16_0_ym19_1_1498438453280_40941"><div id="yui_3_16_0_ym19_1_1498438453280_41218"> -- Thiago V. dos Santos</div><div id="yui_3_16_0_ym19_1_1498438453280_40940"><br></div><div id="yui_3_16_0_ym19_1_1498438453280_41219">PhD student</div><div id="yui_3_16_0_ym19_1_1498438453280_41220">Land and Atmospheric Science</div><div id="yui_3_16_0_ym19_1_1498438453280_41221">University of Minnesota</div></div> <div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 13px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"><font size="2" face="Arial"> On Sunday, June 25, 2017 3:58 PM, Jackson Rodrigues via R-br <r-br@listas.c3sl.ufpr.br> wrote:<br></font></div> <br><br> <div class="y_msg_container"><div id="yiv0595134068"><div dir="ltr"><div>Olá pessoal,<br><br>Preciso muito da ajuda de vocês. Tenho que sintetizar dados de precipitação de vários dias e meses em uma única tabela.<br>No entanto, os dados que possuo estão dispersos em dias e horas diferentes. A maior frequência de observações estão nos dias mais chuvosos enquanto os dias mais secos tem poucas.<br><br>Vou colocar aqui um exemplo de tabela como os dados estão e em seguida a tabela que gostaria que se tornasse.<br><br>Os dados estão como na tabela abaixo que representa a precipitaçção de 1 único ano. Vejam que a quantidade de observações varia de um dia para outro o ano todo.<br><br><table class="yiv0595134068gmail-MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="border-collapse:collapse;border:none;">
<tbody><tr>
<td width="41" style="width:30.9pt;border:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;"> </span></div>
</td>
<td width="39" style="width:29.05pt;border-top:1pt solid windowtext;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">Dia<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:1pt solid windowtext;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">Hora<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:1pt solid windowtext;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">Prec<span></span></span></div>
</td>
</tr>
<tr>
<td width="41" rowspan="7" style="width:30.9pt;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:1pt solid windowtext;border-top:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span lang="EN-US" style="font-size:10pt;">Jan<span></span></span></div>
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;"> </span></div>
</td>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">1<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">7:00<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">20<span></span></span></div>
</td>
</tr>
<tr>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">1<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">7:20<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">15<span></span></span></div>
</td>
</tr>
<tr>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">1<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">7:30<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">5<span></span></span></div>
</td>
</tr>
<tr>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">2<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">6:00<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">10<span></span></span></div>
</td>
</tr>
<tr>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">2<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">15:00<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">16<span></span></span></div>
</td>
</tr>
<tr>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">...<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">...<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">...<span></span></span></div>
</td>
</tr>
<tr>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">31<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">7:00<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">2<span></span></span></div>
</td>
</tr>
<tr>
<td width="41" rowspan="7" style="width:30.9pt;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:1pt solid windowtext;border-top:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">Fev<span></span></span></div>
</td>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">1<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">9:00<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">6<span></span></span></div>
</td>
</tr>
<tr>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">1<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">9:45<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">30<span></span></span></div>
</td>
</tr>
<tr>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">2<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">6:45<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">12<span></span></span></div>
</td>
</tr>
<tr>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">2<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">16:00<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">20<span></span></span></div>
</td>
</tr>
<tr>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">2<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">22:00<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">60<span></span></span></div>
</td>
</tr>
<tr>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">...<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">...<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">...<span></span></span></div>
</td>
</tr>
<tr>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">28<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">11:30<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">25<span></span></span></div>
</td>
</tr>
<tr>
<td width="41" style="width:30.9pt;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:1pt solid windowtext;border-top:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">...<span></span></span></div>
</td>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">...<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">...<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">...<span></span></span></div>
</td>
</tr>
<tr>
<td width="41" style="width:30.9pt;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:1pt solid windowtext;border-top:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">Dez<span></span></span></div>
</td>
<td width="39" style="width:29.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">31<span></span></span></div>
</td>
<td width="52" style="width:38.75pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">...<span></span></span></div>
</td>
<td width="45" style="width:33.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;"><span style="font-size:10pt;">...<span></span></span></div>
</td>
</tr>
</tbody></table><br> Desse jeito fica difícil trabalhar quando for comparar com a precipitação dos outros anos.</div><div>Assim gostaria de sintetizar toda essa informação em uma única tabela.</div><div><br></div><div>Somar tudo que for de Janeiro 1, somar tudo que for de janeiro 2 e assim por diante até o fim do ano gerando a tabela a seguir.<br><br><div align="center">
<table class="yiv0595134068gmail-MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="border-collapse:collapse;border:none;">
<tbody><tr>
<td width="102" valign="top" style="width:76.3pt;border:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">Mês Dia-></div>
</td>
<td width="44" valign="top" style="width:33.05pt;border-top:1pt solid windowtext;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">1</div>
</td>
<td width="44" valign="top" style="width:33.05pt;border-top:1pt solid windowtext;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">2</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:1pt solid windowtext;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">3</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:1pt solid windowtext;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">4</div>
</td>
<td width="33" valign="top" style="width:24.65pt;border-top:1pt solid windowtext;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">...</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:1pt solid windowtext;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">31</div>
</td>
<td width="83" valign="top" style="width:61.95pt;border-top:1pt solid windowtext;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;"><span> </span></div>
</td>
</tr>
<tr>
<td width="102" valign="top" style="width:76.3pt;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:1pt solid windowtext;border-top:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">Jan</div>
</td>
<td width="44" valign="top" style="width:33.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">40</div>
</td>
<td width="44" valign="top" style="width:33.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">16</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">50</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">66</div>
</td>
<td width="33" valign="top" style="width:24.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">...</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">90</div>
</td>
<td width="83" rowspan="4" style="width:61.95pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" align="center" style="margin-bottom:0.0001pt;text-align:center;line-height:normal;">Total precipitado por dia</div>
</td>
</tr>
<tr>
<td width="102" valign="top" style="width:76.3pt;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:1pt solid windowtext;border-top:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">Fev</div>
</td>
<td width="44" valign="top" style="width:33.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">60</div>
</td>
<td width="44" valign="top" style="width:33.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">120</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">25</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">45</div>
</td>
<td width="33" valign="top" style="width:24.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">...</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">87</div>
</td>
</tr>
<tr>
<td width="102" valign="top" style="width:76.3pt;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:1pt solid windowtext;border-top:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">...</div>
</td>
<td width="44" valign="top" style="width:33.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">...</div>
</td>
<td width="44" valign="top" style="width:33.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">...</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">...</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">...</div>
</td>
<td width="33" valign="top" style="width:24.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">...</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">...</div>
</td>
</tr>
<tr>
<td width="102" valign="top" style="width:76.3pt;border-right:1pt solid windowtext;border-bottom:1pt solid windowtext;border-left:1pt solid windowtext;border-top:none;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">Dez</div>
</td>
<td width="44" valign="top" style="width:33.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">120</div>
</td>
<td width="44" valign="top" style="width:33.05pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">30</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">26</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">90</div>
</td>
<td width="33" valign="top" style="width:24.65pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">...</div>
</td>
<td width="37" valign="top" style="width:27.45pt;border-top:none;border-left:none;border-bottom:1pt solid windowtext;border-right:1pt solid windowtext;padding:0cm 5.4pt;">
<div class="yiv0595134068MsoNormal" style="margin-bottom:0.0001pt;line-height:normal;">5</div>
</td>
</tr>
</tbody></table>
</div><br></div><div>A grande questão é como fazê-lo. </div><div>Preciso de um comando que diga some tudo que for do dia 1 de Jan, some tudo de 2 de Jan e assim sucessivamente.<br><br>Alguém poderia me ajudar com isso?<br><br>Obrigado<br><br>Jackson</div><br clear="all"><div><br></div>-
</div></div>_______________________________________________<br>R-br mailing list<br><a ymailto="mailto:R-br@listas.c3sl.ufpr.br" href="mailto:R-br@listas.c3sl.ufpr.br">R-br@listas.c3sl.ufpr.br</a><br><a 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>Leia o guia de postagem (<a 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><br></div> </div> </div> </div></div></body></html>