Have a table with three prompts per date and want to split it up

1 次查看（过去 30 天）
BA
BA 2022-7-6
评论： Cris LaPierre 2022-7-7
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 个评论
dpb
dpb 2022-7-6
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...

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Cris LaPierre
Cris LaPierre 2022-7-6
I would look into stack and unstack functions. Share your data, and we might be able to provide more help. You can save it to a mat file and attach it using the paperclip icon.
  2 个评论
BA
BA 2022-7-7
编辑：BA 2022-7-7
i=[3:53];
Survey_Prompt_Unstack = unstack(Survey_Prompt, 3, i);
Thanks for mentioning the function to me. I'm unfortunately unable to figure out a way to get it to work with my data set. I have attached the data. Each time I try to run the command above, I get this message:
%Error using tabular/unstack
%The indicator variable must be specified as a single variable.
Cris LaPierre
Cris LaPierre 2022-7-7
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

产品


版本

R2022a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by