<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Caros,<div><br></div><div><br></div><div>estou com um problema que deve ser simples de responder mas que eu fiquei empacado. Tenho uma base de dados (data frama) com 15.245 linhas por 369 colunas. Destas 369 colunas as 19 primeiras são médias de variáveis ambientais (retiradas do worldclim) e 330 representam a presená/ausência de determinada espécie nas células. a matrix ficaria assim:</div><div><br></div><div><span class="Apple-style-span" style="font-family: Monaco; font-size: 13px; "><br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; ">Rangebio2<span style="color: #042299"> </span>StdDevbio2<span style="color: #042299"> </span>CoefVarbio2<span style="color: #042299"> </span>Minbio3<span style="color: #042299"> </span>Meanbio3<span style="color: #042299"> </span>Agalychniscallidryas<span style="color: #042299"> </span>Agalychnislitodryas<span style="color: #042299"> </span>Acriscrepitans<span style="color: #042299"> </span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; color: rgb(4, 34, 153); "><span style="color: #055118">2.402</span> <span style="color: #055118">0.034</span> <span style="color: #055118">50</span> <span style="color: #055118">50.889</span> <span style="color: #055118">51.0</span> <span style="color: #055118">0</span> <span style="color: #055118">0</span> <span style="color: #055118">0</span> </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; color: rgb(4, 34, 153); "><span style="color: #055118">1.680</span> <span style="color: #055118">0.022</span> <span style="color: #055118">50</span> <span style="color: #055118">51.611</span> <span style="color: #055118">51.5</span> <span style="color: #055118">0</span> <span style="color: #055118">0</span> <span style="color: #055118">0</span> </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; color: rgb(4, 34, 153); "><span style="color: #055118">1.136</span> <span style="color: #055118">0.014</span> <span style="color: #055118">50</span> <span style="color: #055118">51.344</span> <span style="color: #055118">51.5</span> <span style="color: #055118">0</span> <span style="color: #055118">0</span> <span style="color: #055118">0</span> </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; color: rgb(4, 34, 153); "><span style="color: #055118">0.860</span> <span style="color: #055118">0.011</span> <span style="color: #055118">50</span> <span style="color: #055118">50.867</span> <span style="color: #055118">50.5</span> <span style="color: #055118">0</span> <span style="color: #055118">0</span> <span style="color: #055118">0</span> </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; color: rgb(4, 34, 153); "><span style="color: #055118">2.819</span> <span style="color: #055118">0.045</span> <span style="color: #055118">46</span> <span style="color: #055118">46.971</span> <span style="color: #055118">47.0</span> <span style="color: #055118">0</span> <span style="color: #055118">0</span> <span style="color: #055118">0</span> </div><div><span class="Apple-style-span" style="color: rgb(4, 34, 153); font-family: Monaco; font-size: 11px; "><span style="color: #055118">2.126</span> <span style="color: #055118">0.032</span> <span style="color: #055118">47</span> <span style="color: #055118">47.639</span> <span style="color: #055118">48.0</span> <span style="color: #055118">0</span> <span style="color: #055118">0</span> <span style="color: #055118">0</span> </span><span class="Apple-style-span" style="font-family: Monaco; font-size: 13px; "> </span><font class="Apple-style-span" face="Monaco"><span class="Apple-style-span" style="font-size: 13px;"><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12.5px/normal Monaco; ">
</div></span></font></div><div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12.5px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12.5px/normal Monaco; "><font class="Apple-style-span" size="3">O problema é que eu preciso de uma média de cada variável climática para cada espécie, que são 330 em coluna.</font></div></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12.5px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12.5px/normal Monaco; "><font class="Apple-style-span" size="3">Minha primeira tentativa foi gerar um classificador com cada espécie e usar o nome da espécie como id e fazer as operações. isso não funcionou.</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12.5px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12.5px/normal Monaco; "><font class="Apple-style-span" size="3">O que eu fiz então, foi usar o seguinte comando:</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12.5px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12.5px/normal Monaco; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><span style="color: #042299"><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><span style="color: #042299"><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><span style="color: #042299">with(</span>spp<span style="color: #042299">, mean(</span>Meanbio1<span style="color: #042299"> [</span>Agalychnisannae<span style="color: #042299">!=</span><span style="color: #055118">0</span><span style="color: #042299">]))</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><span style="color: #042299"><font class="Apple-style-span" size="3"><br></font></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3">Isso funciona bem. O problema é que são 330 nomes e mais 18 variáveis para fazer.</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3">tentei fazer um loop para chamar todos os nomes e gerar uma tabela de saida com o nome da espécie (nome da coluna) e a média da variável mas não consegui nada.</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3">Por isso gostaria de saber se alguém poderia me dar uma força sugerindo uma forma de fazer esse loop ou indicando outra possibilidade.</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3">Como apenas abri o data frame e usei esta função este é o código mínimo (e único) que eu tenho.</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3">Obrigado antecipadamente</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3">Mauricio</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><span style="color: #042299"><font class="Apple-style-span" size="3"><br></font></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><span style="color: #042299"><font class="Apple-style-span" size="3"><br></font></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><span style="color: #042299"><br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><span style="color: #042299"><br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><span style="color: #042299"><br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 4px; text-indent: -4px; font: normal normal normal 10.9px/normal Monaco; "><font class="Apple-style-span" color="#042299"><br></font></div></div></body></html>