清空筛选条件
清空筛选条件

How can I clear an entire table column without deleting the variable?

28 次查看（过去 30 天）
s.h.m_89
s.h.m_89 2018-5-23
评论： s.h.m_89 2018-6-13
I have the following table and want to clear the variable P without deleting the variable. Is there a way how I can do that or should I just delete the variable by using removevars and add new data by 'new' variable P.
P Type Date
0,43008 'Feeder' '21.05.2018'
0,03786 'Feeder' '21.05.2018'
0,37238 'Loader' '21.05.2018'
...
(288x4 table)
Thanks in advance!

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

采纳的回答

Peter Perkins
Peter Perkins 2018-6-4
The short answer is to just overwrite the entire variable:
t.P = NaN(size(T.P))
You could also overwrite every element
t.P(:) = NaN
but there's not much advantage. In recent versions of MATLAB, you can assign missing:
t.P(:) = missing
but if you know the var is numeric, NaN is just as good. But missing works on other data types too, like categorical, datetime, ... . If you need to clear out variables of different types, using missing avoids a switch on the type.
By the way, you should consider making Type a categorical, and making Date a datetime. You may have already done that.

更多回答（1 个）

sloppydisk
sloppydisk 2018-5-23
You can simply overwrite the values by indexing with curly braces if that is what you want
t = table(rand(6, 1), rand(6, 1), rand(6, 1))
t{:, 1} = (1:6)';
  4 个评论
显示 2更早的评论
s.h.m_89
s.h.m_89 2018-5-28
编辑：s.h.m_89 2018-5-28
Thanks everyone for your quick responses. @Jeff I did as you recommended. Many thanks!

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by