Have a table with three prompts per date and want to split it up
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
BA
el 6 de Jul. de 2022
Comentada: Cris LaPierre
el 7 de Jul. de 2022
I have survey data from a table that was sent three times per day so a subject could have anywhere between 1 and 3 responses per day. The issue is that all of these dates are within the same column and I'd like to split it up into three different columns. For the dates
Here is a sample of the data. If you have any advice, please let me know! Thanks
Ideally, this is how I would want it to become.
1 comentario
dpb
el 6 de Jul. de 2022
I would venture it's probably not needed to split the data physically and, in fact, will be harder to analyze/process/code if do, than don't.
Use grouping variable(s) and the various splitapply workflow tools -- with a timetable there are a number of other builtin tools as well...
Respuesta aceptada
Cris LaPierre
el 6 de Jul. de 2022
2 comentarios
Cris LaPierre
el 7 de Jul. de 2022
The way your data has been collected, there is no simple way to do this. Do you have any additional details that could be used to identify/discern between the 3 surveys? Also note that there were 4 surveys on Aug 7.
Even something like a timestamp could be used for this purpose.
Más respuestas (0)
Ver también
Categorías
Más información sobre Dates and Time en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!