convert double array in array string in table

26 views (last 30 days)
aldo
aldo on 21 Oct 2023
Answered: Samar on 23 Jan 2025 at 11:20
it's possible to convert double array in array string in table ?
T.Strategy=[Sis.Sistema].';
data=[Sis.data];%[Eq.data]; % N x size(Sis,2) array datetimes
T.DateF=data(1,:)'; % start date is first each
T.DateL=data(end,:)'; % last date is end each
[r1]=arrayfun(@(s)find(s.dailyprof,1),Sis); %trovo il primo trade
[r2]=arrayfun(@(s)find(s.dailyprof,1,'last'),Sis); %trovo ultimo trade
T.TradeF=arrayfun(@(s,i)s.data(i),Sis,r1)';
T.TradeL=arrayfun(@(s,i)s.data(i),Sis,r2)';
T.Strategy is array string.
T.DateF is array datetime
T.DateL is array datetime
T.TradeF is double array
T.TradeL is double array
  2 Comments
Stephen23
Stephen23 on 21 Oct 2023
"it's possible to convert double array in array string in table ?"
Of course:
T = array2table(rand(5,2))
T = 5×2 table
Var1 Var2 ________ ________ 0.51938 0.79195 0.016597 0.088964 0.79159 0.34445 0.24275 0.62235 0.9195 0.90204
T = convertvars(T,'Var1','string')
T = 5×2 table
Var1 Var2 __________ ________ "0.51938" 0.79195 "0.016597" 0.088964 "0.79159" 0.34445 "0.24275" 0.62235 "0.9195" 0.90204

Sign in to comment.

Answers (1)

Samar
Samar on 23 Jan 2025 at 11:20
As @Stephen23 rightly mentioned we can use the functions “array2table” and “convertvars” to convert double array and string array to a table. The links to the Documentation (assuming MATLAB R2023b release is being used) explaining the above functions is given below:
  1. www.mathworks.com/help/releases/R2023b/matlab/ref/array2table.html (Function: array2table)
  2. www.mathworks.com/help/releases/R2023b/matlab/ref/table.convertvars.html (Function: convertvars)

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!