Assign a "double-column" to a "cell-coloumn"

Question

alphabetacharly 2018-6-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406152-assign-a-double-column-to-a-cell-coloumn

评论： alphabetacharly 2018-7-9

I imported some data into a (time-) table. Because of an error-message when receiving the data, few columns are cells with 'error...' as entry in the top row and '' in all other rows, while all other columns contain only doubles. I wrote some code to detect these few "error-columns" and I would like to replace them by a column full of NaNs. However, it is not possible to simply replace the column since the original column is type cell and the new one is type double and conversion from cell to double is not possible.

I hope one can understand what my Problem is and I am deeply grateful for every help.

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

请先登录，再进行评论。

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

Answer 1

Greg 2018-6-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406152-assign-a-double-column-to-a-cell-coloumn#answer_325218

在 MATLAB Online 中打开

You can replace one entire column with NaN very simply:

tableVariable.VarWithErrors = NaN(height(tableVariable),1);

To do multiple variables, put the above in a loop. There might be a one-liner solution, but I'm not seeing it right now.

If you are trying to do partial columns, let me know and I'll draw up an example for that (it's a little more involved).

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

alphabetacharly 2018-7-9

在 MATLAB Online 中打开

Thanks Greg. You're absolutely right. I didn't use the table.var accessing method because I didn't know that one can use numbers instead of the varnames (which I actually not know), too. For example: