Creating copy of column in table

Question

BA ，2022-7-18

0
链接

Direct link to this question

https://ww2.mathworks.cn/matlabcentral/answers/1763060-creating-copy-of-column-in-table

评论： BA ，2022-7-18

exampledataset.xlsx

So far, I've tried to do it with addvars, but I'm having troubles with addvars. I have attached my code and the associated dataset that I'm working on. It keeps telling me "Unrecognized function or variable 'General_Prompt_SurveyStartedDate'." but I've checked 5 times and the variable name matches exactly what I have in the table.

exampledataset = addvars(exampledataset, General_Prompt_SurveyStartedDate, 'Before', 'General_Prompt_SurveyStartedTime');

I'm not sure why its doing it but if someone can take a look, that would be great.

Thanks

0 个评论
显示 -1更早的评论隐藏 -1更早的评论

请先登录，再进行评论。

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

Answer 1

Image Analyst 2022-7-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1763060-creating-copy-of-column-in-table#answer_1010185

There is no General_Prompt_SurveyStartedDate variable. There is a COLUMN/FIELD of a table called that but that is different than being its own variable.

Try this:

fileName = 'exampledataset.xlsx'
exampledataset = readtable(fileName)
newColumnValues = exampledataset.General_Prompt_SurveyStartedDate; % Extract one column.
newColumnName = 'CopiedDate' % Give it a new name - whatever you want.
exampledataset = addvars(exampledataset, newColumnValues, 'Before', 'General_Prompt_SurveyStartedTime', 'NewVariableNames', newColumnName);