<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: times new roman,new york,times,serif; font-size: 12pt; color: #000000'><br><br><hr id="zwchr"><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>De: </b>"SILVIA PATRICIA BARRETO SANTANA" <silpat@ufrb.edu.br><br><b>Para: </b>"r-br" <r-br@listas.c3sl.ufpr.br><br><b>Enviadas: </b>Terça-feira, 11 de dezembro de 2018 18:05:24<br><b>Assunto: </b>Criação de um dataframe a partir das diferenças<br><br><style>p { margin: 0; }</style><div style="font-family: times new roman,new york,times,serif; font-size: 12pt; color: #000000">Bom dia pessoal.<br> <br>Estou com dificuldade em obter os dados que necessito<span id="DWT7591" class="ZmSearchResult"></span> e qualque<span id="DWT7593" class="ZmSearchResult">r</span> ajuda se<span id="DWT7595" class="ZmSearchResult">r</span>á bem vinda, po<span id="DWT7597" class="ZmSearchResult">r</span> isso já começo ag<span id="DWT7599" class="ZmSearchResult">r</span>adecendo.<br>Com este banco de dados (abaixo) gosta<span id="DWT7601" class="ZmSearchResult">r</span>ia de obte<span id="DWT7603" class="ZmSearchResult">r</span> a seguinte info<span id="DWT7605" class="ZmSearchResult">r</span>mação (mais abaixo):<br><br>Ho<span id="DWT7607" class="ZmSearchResult">r</span>a<span id="DWT7609" class="ZmSearchResult">r</span>io Nivel Status<br><span class="Object" id="OBJ_PREFIX_DWT269_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT483_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7610_com_zimbra_date">01/01/2011</span></span></span> 00:00 29 0<br><span style="background-color: rgb(255, 246, 179);"><span class="Object" id="OBJ_PREFIX_DWT270_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT484_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7611_com_zimbra_date">01/01/2011</span></span></span> 00:01 29 0<br><span class="Object" id="OBJ_PREFIX_DWT271_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT485_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7612_com_zimbra_date">01/01/2011</span></span></span> 00:02 30 1<br><span class="Object" id="OBJ_PREFIX_DWT272_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT486_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7613_com_zimbra_date">01/01/2011</span></span></span> 00:03 31 1</span><br><span class="Object" id="OBJ_PREFIX_DWT273_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT487_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7614_com_zimbra_date">01/01/2011</span></span></span> 00:04 29 0<br><span class="Object" id="OBJ_PREFIX_DWT274_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT488_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7615_com_zimbra_date">01/01/2011</span></span></span> 00:05 29 0<br><span class="Object" id="OBJ_PREFIX_DWT275_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT489_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7616_com_zimbra_date">01/01/2011</span></span></span> 00:06 29 0<br><span style="background-color: rgb(255, 246, 179);"><span class="Object" id="OBJ_PREFIX_DWT276_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT490_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7617_com_zimbra_date">01/01/2011</span></span></span> 00:07 29 0<br><span class="Object" id="OBJ_PREFIX_DWT277_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT491_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7618_com_zimbra_date">01/01/2011</span></span></span> 00:08 30 1<br><span class="Object" id="OBJ_PREFIX_DWT278_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT492_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7619_com_zimbra_date">01/01/2011</span></span></span> 00:09 32 1<br><span class="Object" id="OBJ_PREFIX_DWT279_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT493_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7620_com_zimbra_date">01/01/2011</span></span></span> 00:10 34 1<br><span class="Object" id="OBJ_PREFIX_DWT280_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT494_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7621_com_zimbra_date">01/01/2011</span></span></span> 00:11 35 1<br><span class="Object" id="OBJ_PREFIX_DWT281_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT495_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7622_com_zimbra_date">01/01/2011</span></span></span> 00:12 35 1</span><br><div><span class="Object" id="OBJ_PREFIX_DWT282_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT496_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7623_com_zimbra_date">01/01/2011</span></span></span> 00:13 25 0</div><div><br></div><div><br></div><div>O banco abaixo consiste em guardar a informação do horário em que o status muda de 0 para 1 com as diferenças dos níveis.</div><div> <br></div><div><br></div><div>Ho<span id="DWT7607" class="ZmSearchResult">r</span>a<span id="DWT7609" class="ZmSearchResult">r</span>io Nivel Status<br><br><span style="background-color: rgb(255, 255, 153);"><span class="Object" id="OBJ_PREFIX_DWT271_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT485_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7612_com_zimbra_date">01/01/2011</span></span></span> 00:02 01 1<br><span class="Object" id="OBJ_PREFIX_DWT272_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT486_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7613_com_zimbra_date">01/01/2011</span></span></span> 00:03 01 1</span><br><span style="background-color: rgb(255, 255, 153);"><span class="Object" id="OBJ_PREFIX_DWT277_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT491_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7618_com_zimbra_date">01/01/2011</span></span></span> 00:08 01 1<br><span class="Object" id="OBJ_PREFIX_DWT278_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT492_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7619_com_zimbra_date">01/01/2011</span></span></span> 00:09 02 1<br><span class="Object" id="OBJ_PREFIX_DWT279_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT493_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7620_com_zimbra_date">01/01/2011</span></span></span> 00:10 02 1<br><span class="Object" id="OBJ_PREFIX_DWT280_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT494_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7621_com_zimbra_date">01/01/2011</span></span></span> 00:11 01 1<br><span class="Object" id="OBJ_PREFIX_DWT281_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT495_com_zimbra_date"><span class="Object" id="OBJ_PREFIX_DWT7622_com_zimbra_date">01/01/2011</span></span></span> 00:12 00 1</span></div><div><span style="background-color: rgb(255, 255, 255);"><br></span></div><div><span style="background-color: rgb(255, 255, 255);"><br></span></div><div><span style="background-color: rgb(255, 255, 255);">Muito grata!</span></div><div><span style="background-color: rgb(255, 255, 255);"><br></span></div><div><span style="background-color: rgb(255, 255, 255);">Silvia</span><br></div></div></div><br></div>
<br><br></body></html>