Convert variable to numeric in TimeTable

Question

Eric Escoto 2020-9-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/597400-convert-variable-to-numeric-in-timetable

评论： Eric Escoto 2020-9-21

采纳的回答： Adam Danz

tt1_example.mat

在 MATLAB Online 中打开

I have a timetable with some values that are not in the correct format for further computations using 'retime'.

The portions in question seem to be designated by apostrophes surrounding the variable value.

Note the "NaN" values in Var1 of the attached file compared with 'NAN' in Var2 (ideally, 'NAN' within the timetable should be changed to NaN). Similarly in Var2, or Var6, values that should be numeric are bounded by the apostrophes (e.g. '0', '28'). Those should only be the numeric value.

Do the apostrophes mean anything and are they the problem here? Designating a differnt type of format?

How can I modify this timetable to create something I can work with?

% Compute Daily values for variables.
    TT2_sta_Pin = TT1_sta(:,{'Var2'});
    TT2_sta_Pisum = retime(TT2_sta_Pin, 'daily', 'sum');

Will return,

Error using timetable/retime (line 140)
All variables in input timetables must be numeric or duration when synchronizing using 'sum'.

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

请先登录，再进行评论。

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

Answer 1

Adam Danz 2020-9-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/597400-convert-variable-to-numeric-in-timetable#answer_498091

编辑：Adam Danz 2020-9-21

在 MATLAB Online 中打开

Convert your columns containing cellstrings to numeric vectors.

Example:

TT1_sta.Var2 = str2double(TT1_sta.Var2);

repeat for the other cellstr columns.

If that table is produced by reading in data, instead of fixing the cellstr columns, change how you're reading in the data so that you're reading in numeric values rather than strings. Then you won't have the problem in the first place.