how do I create this loop?
显示 更早的评论
I have a timetable that I'm converting to an array. Some of the columns are NaNs so initially, I just changed the columns to zeros before converting it but I don't want to do this since not all values in the column are necessarily NaNs and I don't want to lose that possible data. I was thinking of creating a loop so that if the values are NaNs, it'll be changed to a zero and if the value is something else, it'll be left alone. This is what I tried writing for a column called G
for c = 1:length(TT(:,'G'))
if TT(c,'G')= nan
TT(c,'G') = 0;
else
TT(c,'G') = TT(c,'G');
end
I know i'm calling the if function wrong but i'm not sure how to fix it. if statements always trip me up for some reason
采纳的回答
Star Strider
2018-10-31
0 个投票
It might be easier to use the timetable2table (link) function, then the table2array (link) function.
I have no idea if this would work with your data. You will have to experiment.
6 个评论
Susan Santiago
2018-10-31
Star Strider
2018-10-31
My pleasure.
We would have to see at least a representative sample of your timetable, ideally as a ‘mat’ file, so all the variable types and other relevant information is available.
Susan Santiago
2018-10-31
Star Strider
2018-10-31
It was something of a challenge for me to figure out how to convert your 'NAN' string entries to numeric NaN values. I am still not certain what you want to do.
This will at least get you started (assuming you already have your ‘TT’ table in your workspace):
TT_T = timetable2table(TT); % Convert To Table
TT_C = table2cell(TT_T); % Convert To Cell
TT_L = cellfun(@(x)strcmpi(x, 'NAN'), TT_C); % Find 'NAN' Strings
TT_C(TT_L) = {NaN}; % Convert String 'NAN' To Numeric {NaN}
TT_M = cell2mat(TT_C(:, 3:end)); % Data Without ‘datetime’ Objects
The final version of ‘TT_C’ is a cell array with the string 'NAN' elements replaced with numeric NaN elements. The ‘TT_M’ matrix is an array of the data without the first two columns. If you want to include them, use the datenum function to convert them to numeric values. I would not recommend that, although it could be necessary, depending on how you choose to process your data.
Susan Santiago
2018-10-31
Star Strider
2018-10-31
As always, my pleasure!
更多回答（1 个）
Andrei Bobrov
2018-10-31
编辑：Andrei Bobrov
2018-10-31
zrs = zeros(size(TT,1),1);
TT.G = zrs;
TT.SG = zrs;
3 个评论
Susan Santiago
2018-10-31
Andrei Bobrov
2018-10-31
I am fixed my answer.
Susan Santiago
2018-10-31
类别
在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
