<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Vc precisa transformar a tabela do formate wide para long.<div class=""><br class=""></div><div class="">Existem varias formas. Aqui tem um exemplo</div><div class=""><br class=""></div><div class=""><a href="https://www.datasciencemadesimple.com/reshape-in-r-from-wide-to-long-from-long-to-wide/" class="">https://www.datasciencemadesimple.com/reshape-in-r-from-wide-to-long-from-long-to-wide/</a></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">daniel<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On May 25, 2022, at 8:01 AM, Michele Claire Breton por (R-br) <<a href="mailto:r-br@listas.c3sl.ufpr.br" class="">r-br@listas.c3sl.ufpr.br</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Caríssimos(as) colegas(as), muito bom dia!<div class=""><br class=""></div><div class="">Espero que todos se encontrem bem.</div><div class=""><br class=""></div><div class="">Estou com uma dificuldade. Quero fazer um bubble plot usando as funções ggplot2 e dplyr, onde pretendo plotar no eixo x o gene_ID (são 84 linhas), no y a % de ocorrência da expressão na célula e no color, o valor da expressão. O meu primeiro problema é que no y são 9 tipos celulares diferentes e cada um tem, na tabela de entrada de dados, uma coluna com os dados de expressão e outra com os dados de % de ocorrência (amostra abaixo). Como eu escrevo a função geom_point para plotar o gráfico?</div><div class=""><br class=""></div><div class="">Amostra da tabela de entrada</div><div class="">
<table cellspacing="0" border="0" style="font-family:"Liberation Sans";font-size:x-small" class="">
<colgroup width="82" class=""></colgroup>
<colgroup width="55" class=""></colgroup>
<colgroup width="46" class=""></colgroup>
<colgroup width="55" class=""></colgroup>
<colgroup width="46" class=""></colgroup>
<colgroup width="55" class=""></colgroup>
<colgroup width="46" class=""></colgroup>
<colgroup span="3" width="55" class=""></colgroup>
<colgroup width="46" class=""></colgroup>
<colgroup width="55" class=""></colgroup>
<colgroup width="46" class=""></colgroup>
<colgroup width="55" class=""></colgroup>
<colgroup width="46" class=""></colgroup>
<colgroup width="55" class=""></colgroup>
<colgroup width="46" class=""></colgroup>
<colgroup span="2" width="55" class=""></colgroup>
<tbody class=""><tr class="">
<td height="21" align="left" style="font-family:"Liberation Sans"" class="">gene</td>
<td align="left" style="font-family:"Liberation Sans"" class="">BE-exp</td>
<td align="left" style="font-family:"Liberation Sans"" class="">BE%</td>
<td align="left" style="font-family:"Liberation Sans"" class="">CE_exp</td>
<td align="left" style="font-family:"Liberation Sans"" class="">CE%</td>
<td align="left" style="font-family:"Liberation Sans"" class="">E_exp</td>
<td align="left" style="font-family:"Liberation Sans"" class="">E%</td>
<td align="left" style="font-family:"Liberation Sans"" class="">F_exp</td>
<td align="left" style="font-family:"Liberation Sans"" class="">F%</td>
<td align="left" style="font-family:"Liberation Sans"" class="">HE_exp</td>
<td align="left" style="font-family:"Liberation Sans"" class="">HE%</td>
<td align="left" style="font-family:"Liberation Sans"" class="">L-exp</td>
<td align="left" style="font-family:"Liberation Sans"" class="">L%</td>
<td align="left" style="font-family:"Liberation Sans"" class="">LE-exp</td>
<td align="left" style="font-family:"Liberation Sans"" class="">LE%</td>
<td align="left" style="font-family:"Liberation Sans"" class="">N-exp</td>
<td align="left" style="font-family:"Liberation Sans"" class="">N%</td>
<td align="left" style="font-family:"Liberation Sans"" class="">SM-exp</td>
<td align="left" style="font-family:"Liberation Sans"" class="">SM%</td>
</tr>
<tr class="">
<td height="21" align="left" style="font-family:"Liberation Sans"" class="">ACTB</td>
<td align="left" style="font-family:"Liberation Sans"" class="">4.006</td>
<td align="left" style="font-family:"Liberation Sans"" class="">99.8</td>
<td align="left" style="font-family:"Liberation Sans"" class="">3.690</td>
<td align="left" style="font-family:"Liberation Sans"" class="">99.6</td>
<td align="left" style="font-family:"Liberation Sans"" class="">2.691</td>
<td align="left" style="font-family:"Liberation Sans"" class="">95.2</td>
<td align="left" style="font-family:"Liberation Sans"" class="">2.377</td>
<td align="left" style="font-family:"Liberation Sans"" class="">80.1</td>
<td align="left" style="font-family:"Liberation Sans"" class="">2.901</td>
<td align="left" style="font-family:"Liberation Sans"" class="">97.7</td>
<td align="left" style="font-family:"Liberation Sans"" class="">3.182</td>
<td align="left" style="font-family:"Liberation Sans"" class="">94.1</td>
<td align="left" style="font-family:"Liberation Sans"" class="">2.864</td>
<td align="left" style="font-family:"Liberation Sans"" class="">94.0</td>
<td align="left" style="font-family:"Liberation Sans"" class="">3.243</td>
<td align="left" style="font-family:"Liberation Sans"" class="">96.0</td>
<td align="left" style="font-family:"Liberation Sans"" class="">3.214</td>
<td align="left" style="font-family:"Liberation Sans"" class="">93.5</td>
</tr>
<tr class="">
<td height="21" align="left" style="font-family:"Liberation Sans"" class="">ACTG1</td>
<td align="left" style="font-family:"Liberation Sans"" class="">3.850</td>
<td align="left" style="font-family:"Liberation Sans"" class="">5.9</td>
<td align="left" style="font-family:"Liberation Sans"" class="">3.592</td>
<td align="left" style="font-family:"Liberation Sans"" class="">7.1</td>
<td align="left" style="font-family:"Liberation Sans"" class="">2.469</td>
<td align="left" style="font-family:"Liberation Sans"" class="">1.5</td>
<td align="left" style="font-family:"Liberation Sans"" class="">2.252</td>
<td align="left" style="font-family:"Liberation Sans"" class="">1.1</td>
<td align="left" style="font-family:"Liberation Sans"" class="">3.129</td>
<td align="left" style="font-family:"Liberation Sans"" class="">6.4</td>
<td align="left" style="font-family:"Liberation Sans"" class="">2.451</td>
<td align="left" style="font-family:"Liberation Sans"" class="">0.6</td>
<td align="left" style="font-family:"Liberation Sans"" class="">2.979</td>
<td align="left" style="font-family:"Liberation Sans"" class="">1.1</td>
<td align="left" style="font-family:"Liberation Sans"" class="">3.104</td>
<td align="right" style="font-family:"Liberation Sans"" class="">0</td>
<td align="left" style="font-family:"Liberation Sans"" class="">2.500</td>
<td align="left" style="font-family:"Liberation Sans"" class="">2.4</td>
</tr>
<tr class="">
<td height="21" align="left" style="font-family:"Liberation Sans"" class="">AJUBA</td>
<td align="left" style="font-family:"Liberation Sans"" class="">1.185</td>
<td align="left" style="font-family:"Liberation Sans"" class="">5.9</td>
<td align="left" style="font-family:"Liberation Sans"" class="">0.972</td>
<td align="left" style="font-family:"Liberation Sans"" class="">7.1</td>
<td align="left" style="font-family:"Liberation Sans"" class="">1.042</td>
<td align="left" style="font-family:"Liberation Sans"" class="">1.5</td>
<td align="left" style="font-family:"Liberation Sans"" class="">0.912</td>
<td align="left" style="font-family:"Liberation Sans"" class="">1.1</td>
<td align="left" style="font-family:"Liberation Sans"" class="">1.043</td>
<td align="left" style="font-family:"Liberation Sans"" class="">6.4</td>
<td align="left" style="font-family:"Liberation Sans"" class="">0.865</td>
<td align="left" style="font-family:"Liberation Sans"" class="">0.6</td>
<td align="left" style="font-family:"Liberation Sans"" class="">1.024</td>
<td align="left" style="font-family:"Liberation Sans"" class="">1.1</td>
<td align="right" style="font-family:"Liberation Sans"" class="">0</td>
<td align="right" style="font-family:"Liberation Sans"" class="">0</td>
<td align="left" style="font-family:"Liberation Sans"" class="">1.149</td>
<td align="left" style="font-family:"Liberation Sans"" class="">2.4</td>
</tr>
</tbody></table></div><div class=""><br class=""></div><div class="">Muitíssimo obrigada pela ajuda!</div><div class=""><br class=""></div><div class="">Michele</div><div class=""><br class=""></div><div class=""><br clear="all" class=""><div class=""><br class=""></div>-- <br class=""><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr" class="">------------------------------------------------------------------------<br class=""><div class=""><i class=""><b class="">Dra. Michele Claire Breton</b></i></div><div class="">Técnica Superior em Bioinformática</div><div class="">CICS - Centro de Investigação em Ciências da Saúde</div><div class="">Faculdade de Ciências da Saúde</div><div class="">Universidade da Beira Interior</div><div class="">Covilhã - Castelo Branco - Portugal</div></div></div></div></div>
_______________________________________________<br class="">R-br mailing list<br class=""><a href="mailto:R-br@listas.c3sl.ufpr.br" class="">R-br@listas.c3sl.ufpr.br</a><br class="">https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br<br class="">Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forneça código mínimo reproduzível.<br class=""></div></blockquote></div><br class=""></div></body></html>