<div dir="ltr">Estimado Juan Manuel Días<div><br></div><div>Yo tengo experiencia en acomodar enfermedades para analizar en R. Nunca busque en R una función para ordenar enfermedades, por ejemplo, en sus datos supongamos que aparece neoplasia, esto hace un conflicto con cáncer. Si los datos ya están almacenados en esa forma, lo más sano es colocar a mano, luego buscar, crear listas.Debe conocer los datos y que significan, R no solucionará posibles problemas de nomenclatura médica, pero si los ordenará o desordenará rapidísimo si no tiene un cuidado artesanal, claro, complicado si son miles.</div><div><br></div><div>Javier Rubén Marcuzzi</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">El jue, 11 mar 2021 a las 16:03, juan manuel dias (<<a href="mailto:juamadias@gmail.com">juamadias@gmail.com</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><p class="MsoNormal" style="margin:0cm;line-height:normal;font-size:11pt"><font face="tahoma, sans-serif"><span style="font-size:12pt;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial">Hola
Estimados/as, </span><span style="font-size:12pt"></span></font></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"> </font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif">Hace unos días consulté cómo generar variables dummy cuándo las opciones de respuesta están
cargadas en una misma columna/variable y separadas por una coma “,”.</font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"> </font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif">Tenía esto:</font></span></p><p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt;font-family:Calibri,sans-serif"></p><img src="cid:ii_km58al5o0" alt="image.png" width="284" height="138"><p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt;font-family:Calibri,sans-serif"><span style="font-family:Arial,sans-serif;font-size:12pt"> </span><span style="font-size:12pt;font-family:Arial,sans-serif"><img style="margin-right: 0px;"></span><br></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif">Y debía generar como
primer paso esto:</font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"> </font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif">ab<-base %>%</font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"> separate_rows(enfermedad, sep =
",") %>%</font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"> mutate(enfermedad = str_squish(enfermedad))</font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt;font-family:Calibri,sans-serif"><span style="font-size:12pt;font-family:Arial,sans-serif"> </span></p><p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt;font-family:Calibri,sans-serif"></p><img src="cid:ii_km58ay9g1" alt="image.png" width="289" height="190"><p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt;font-family:Calibri,sans-serif"><br></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif">Y finalmente
obtener como resultado las dummy:</font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"> </font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif">ab<-base %>%</font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"> separate_rows(enfermedad, sep =
",") %>%</font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"> mutate(enfermedad = str_squish(enfermedad), #
Para quitar los espacios en blanco indeseados</font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"> id = 1) %>%</font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"> spread(key = enfermedad, value = id)</font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"> </font></span></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif">ab[<a href="http://is.na" target="_blank">is.na</a>(ab)] <-
0</font></span></p><p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><font face="tahoma, sans-serif"><span style="font-size:12pt"></span></font></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><font face="tahoma, sans-serif"><br></font></p><p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><font face="tahoma, sans-serif">write.csv(ab,file='base_enfermedades_dummy.csv')</font><br></p><p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><font face="tahoma, sans-serif"><br></font></p><p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"></p><img src="cid:ii_km58dere2" alt="image.png" width="303" height="160"><p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><br></p>
<p class="MsoNormal" style="margin:0cm;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt;font-family:Calibri,sans-serif"><span style="font-size:12pt;font-family:Arial,sans-serif"> </span></p>
<p class="MsoNormal" style="margin:0cm;text-align:justify;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif">Actualmente estoy necesitando lo siguiente: conservar las variables
<b>Demencia</b>, <b>Cáncer</b>, <b>Enfermedad Cardíaca</b>, <b>Enfermedad pulmonar</b> y <b>Diabetes</b> y al resto
de las variables/enfermedades agruparlas en una nueva variable “otros”, que sea 1 ó 0 si el caso/paciente tiene 1 en cualquiera de las enfermedades que no son las que
menciono arriba. </font></span></p><p class="MsoNormal" style="margin:0cm;text-align:justify;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"><br></font></span></p><p class="MsoNormal" style="margin:0cm;text-align:justify;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif">Asimismo, necesito generar una nueva variable "<b>Enfermedades_otras</b>" donde figuren cuáles son las enfermedades que mencionó el paciente en otros, y que estén
separadas por una coma.</font></span></p>
<p class="MsoNormal" style="margin:0cm;text-align:justify;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"> </font></span></p>
<p class="MsoNormal" style="margin:0cm;text-align:justify;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial"><span style="font-size:12pt"><font face="tahoma, sans-serif">Adjunto la base en csv (</font></span><b style="font-size:11pt"><font face="tahoma, sans-serif">base_enfermedades_dummy</font>) </b><span style="font-size:12pt"><font face="tahoma, sans-serif">y en el excel (</font></span><b><font face="tahoma, sans-serif">Ejemplo_agrupar_en_otros</font></b>)<span style="font-size:12pt;font-family:tahoma,sans-serif"> dejo un ejemplo de lo que intento hacer.</span></p><p class="MsoNormal" style="margin:0cm;text-align:justify;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif"><br></font></span></p><p class="MsoNormal" style="margin:0cm;text-align:justify;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt"><span style="font-size:12pt"><font face="tahoma, sans-serif">Muchas gracias! Juan.</font></span></p>
<p class="MsoNormal" style="margin:0cm;text-align:justify;line-height:normal;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:11pt;font-family:Calibri,sans-serif"><span style="font-size:12pt;font-family:Arial,sans-serif"> </span></p></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>