How to convert a table containing numbers and booleans to a double array?
46 views (last 30 days)
Show older comments
using table2array I get a string array, but I need an array of numbers where the booleans become 0 or 1 respectivly. double(table2array(arr)) results in NaN for every boolean value
2 Comments
the cyclist
on 5 Jul 2024 at 21:29
Edited: the cyclist
on 5 Jul 2024 at 21:30
It would be easier for us to suggest a solution if you uploaded a representative sample of your data. You can use the paper clip icon in the INSERT section of the toolbar.
Answers (1)
Voss
on 5 Jul 2024 at 22:40
Edited: Voss
on 5 Jul 2024 at 23:00
T = load('example.mat').data3
M = [strcmpi(T.var1,'TRUE') T.var2]
3 Comments
Voss
on 5 Jul 2024 at 23:10
Here's one way to do that:
T = table(["FALSE";"TRUE";"FALSE";"FALSE"],[1.1;2.2;3.3;4.4],["TRUE";"TRUE";"FALSE";"TRUE"])
[m,n] = size(T);
M = NaN(m,n);
for ii = 1:n
if isstring(T.(ii))
M(:,ii) = strcmpi(T.(ii),'TRUE');
else
M(:,ii) = T.(ii);
end
end
M
Walter Roberson
on 5 Jul 2024 at 23:19
One approach would be to use
mask = varfunc(@isnumeric, T, OutputFormat = "uniform");
Output = zeros(height(T), width(T));
Output(:,mask) = T{:,mask};
Output(:,~mask) = varfunc(@(V)strcmpi(V, "TRUE"), InputVariables = ~mask, OutputFormat = "uniform");
See Also
Categories
Find more on Data Type Conversion in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!