<div dir="ltr"><div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small">Hola,</div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small">Esta es otra alternativa:</div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small">> Lines <- "<br>+ Numero_vuelo Nacionalidad Pax<br>+ 1240 Argentina 2341<br>+ 1240 Uruguaya 4432<br>+ 1240 Paraguaya 67000<br>+ 1240 Brasilera 1234<br>+ 1241 Argentina 7344<br>+ 1241 Uruguaya 543000<br>+ 1241 Paraguaya 3000<br>+ 1241 Brasilera 23400<br>+ "<br>> <br>> DF <- read.table(textConnection(Lines), header = TRUE, <a href="http://as.is">as.is</a> = TRUE)<br>> <br>> library(data.table)<br>> DT <- as.data.table(DF)<br>> dcast(DT, Numero_vuelo ~ Nacionalidad, value.var =c('Pax') )<br> Numero_vuelo Argentina Brasilera Paraguaya Uruguaya<br>1: 1240 2341 1234 67000 4432<br>2: 1241 7344 23400 3000 543000</div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small">Saludos,</div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small">Carlos Ortega</div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small"><a href="http://www.qualityexcellence.es">www.qualityexcellence.es</a><br></div></div></div><br><div class="gmail_quote"><div dir="ltr">El jue., 11 oct. 2018 a las 17:33, juan manuel dias (<<a href="mailto:juamadias@gmail.com">juamadias@gmail.com</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hola,<div>Tengo la siguiente base de datos</div><div><br></div><div><table border="0" cellpadding="0" cellspacing="0" width="379" style="border-collapse:collapse;width:284pt">
<colgroup><col width="184" style="width:138pt">
<col width="115" style="width:86pt">
<col width="80" style="width:60pt">
</colgroup><tbody><tr height="20" style="height:15pt">
<td height="20" class="m_4817103390913073912gmail-xl65" width="184" style="height:15pt;width:138pt;text-align:center;vertical-align:middle;border:0.5pt solid gray;background:rgb(242,242,242);padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif">Numero
de vuelo</td>
<td class="m_4817103390913073912gmail-xl65" width="115" style="border-left:none;width:86pt;text-align:center;vertical-align:middle;border-top:0.5pt solid gray;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background:rgb(242,242,242);padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif">Nacionalidad</td>
<td class="m_4817103390913073912gmail-xl65" width="80" style="border-left:none;width:60pt;text-align:center;vertical-align:middle;border-top:0.5pt solid gray;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background:rgb(242,242,242);padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif">Pax</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="m_4817103390913073912gmail-xl64" style="height:15pt;border-top:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;border-left:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">1240</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">Argentina</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">2341</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="m_4817103390913073912gmail-xl64" style="height:15pt;border-top:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;border-left:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">1240</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">Uruguaya</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">4432</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="m_4817103390913073912gmail-xl64" style="height:15pt;border-top:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;border-left:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">1240</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">Paraguaya</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">67000</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="m_4817103390913073912gmail-xl64" style="height:15pt;border-top:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;border-left:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">1240</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">Brasilera</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">1234</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="m_4817103390913073912gmail-xl64" style="height:15pt;border-top:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;border-left:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">1241</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">Argentina</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">7344</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="m_4817103390913073912gmail-xl64" style="height:15pt;border-top:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;border-left:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">1241</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">Uruguaya</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">543000</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="m_4817103390913073912gmail-xl64" style="height:15pt;border-top:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;border-left:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">1241</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">Paraguaya</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">3000</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="m_4817103390913073912gmail-xl64" style="height:15pt;border-top:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;border-left:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">1241</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">Brasilera</td>
<td class="m_4817103390913073912gmail-xl64" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">234000</td>
</tr>
</tbody></table><br></div><div>y quiero que quede del siguiente modo:</div><div><br></div><div><table border="0" cellpadding="0" cellspacing="0" width="817" style="border-collapse:collapse;width:613pt">
<colgroup><col width="127" style="width:95pt">
<col width="177" style="width:133pt">
<col width="171" style="width:128pt">
<col width="162" style="width:122pt">
<col width="180" style="width:135pt">
</colgroup><tbody><tr height="20" style="height:15pt">
<td height="20" class="m_4817103390913073912gmail-xl67" width="127" style="height:15pt;width:95pt;text-align:center;vertical-align:middle;border:0.5pt solid gray;background:rgb(242,242,242);padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif">Numero de
vuelo</td>
<td class="m_4817103390913073912gmail-xl67" width="177" style="border-left:none;width:133pt;text-align:center;vertical-align:middle;border-top:0.5pt solid gray;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background:rgb(242,242,242);padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif">Nacionalidad_argentina</td>
<td class="m_4817103390913073912gmail-xl67" width="171" style="border-left:none;width:128pt;text-align:center;vertical-align:middle;border-top:0.5pt solid gray;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background:rgb(242,242,242);padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif">Nacionalidad_uruguaya</td>
<td class="m_4817103390913073912gmail-xl67" width="162" style="border-left:none;width:122pt;text-align:center;vertical-align:middle;border-top:0.5pt solid gray;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background:rgb(242,242,242);padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif">Nacionalidad_paraguaya</td>
<td class="m_4817103390913073912gmail-xl67" width="180" style="border-left:none;width:135pt;text-align:center;vertical-align:middle;border-top:0.5pt solid gray;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background:rgb(242,242,242);padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif">Nacionalidad_brasilera</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="m_4817103390913073912gmail-xl66" style="height:15pt;border-top:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;border-left:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">1240</td>
<td class="m_4817103390913073912gmail-xl66" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">2341</td>
<td class="m_4817103390913073912gmail-xl66" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">4432</td>
<td class="m_4817103390913073912gmail-xl66" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">67000</td>
<td class="m_4817103390913073912gmail-xl66" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">1234</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="m_4817103390913073912gmail-xl66" style="height:15pt;border-top:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;border-left:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">1241</td>
<td class="m_4817103390913073912gmail-xl66" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">7344</td>
<td class="m_4817103390913073912gmail-xl66" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">543000</td>
<td class="m_4817103390913073912gmail-xl66" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">3000</td>
<td class="m_4817103390913073912gmail-xl66" style="border-top:none;border-left:none;text-align:center;vertical-align:middle;border-right:0.5pt solid gray;border-bottom:0.5pt solid gray;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;white-space:nowrap">234000</td>
</tr>
</tbody></table></div><div><br></div><div> intenté con <b style="color:rgb(0,0,0);font-family:Tahoma,sans-serif;font-size:14.6667px">vuelos_f<-t(vuelos) </b><span style="color:rgb(0,0,0);font-family:Tahoma,sans-serif;font-size:14.6667px">pero no logro lo que quiero, queda así:</span></div><div><br></div><div><div><img src="cid:ii_jn4qrs890" alt="image.png" width="503" height="65"><br></div></div><div><br></div><div>Muchas gracias! Saludos, Juan.</div></div>
_______________________________________________<br>
R-help-es mailing list<br>
<a href="mailto:R-help-es@r-project.org" target="_blank">R-help-es@r-project.org</a><br>
<a href="https://stat.ethz.ch/mailman/listinfo/r-help-es" rel="noreferrer" target="_blank">https://stat.ethz.ch/mailman/listinfo/r-help-es</a><br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><span style="font-family:verdana,sans-serif">Saludos,</span><br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">Carlos Ortega</span><br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif"><a href="http://www.qualityexcellence.es" target="_blank">www.qualityexcellence.es</a></span></div>