How to convert cell char array in Table With Column
10 ビュー (過去 30 日間)
古いコメントを表示
Hello. I hope you are doing Well. I have import Data from website. I need to convert the Char array in Table with Values in Each Column
For Example In the following data I have 2x2 cell. The first Cell Predicted Class is the Column name and Airplane is the Value.
The second Cell will be Column name Maximum Amp and Time Value corresponding to there Values.
The C1 is the first Class and C2 is the Second Class so it should be in loop to save the data for multiple classes.
Can anybody help me with that.
2 件のコメント
Dyuman Joshi
2023 年 2 月 2 日
y=load('Data.mat').Datawebsite
It's not clear how you want to store this data in Table. What is supposed to be the format of the Table? Direct conversion column wise?
out=cell2table(y)
Please give a sample output.
採用された回答
KSSV
2023 年 2 月 2 日
load('Data.mat')
[m,n] = size(Datawebsite) ;
predictedClass = cell(m,1) ;
maximumAmp = zeros(m,1) ;
time = zeros(m,1) ;
expression1 = ':\s*(\w+)';
expression2 = '-?\d+\.\d+';
for i = 1:m
string1 = Datawebsite{i,1} ;
tokens = regexp(string1,expression1,'tokens');
predictedClass{i} = tokens{1}{1};
string2 = Datawebsite{i,2} ;
tokens = regexp(string2,expression2,'match');
maximumAmp(i) = str2double(tokens{1});
time(i) = str2double(tokens{2});
end
T = table(predictedClass,maximumAmp,time)
4 件のコメント
KSSV
2023 年 2 月 3 日
You have the code for your asked case...you can extends the same to your case. It is straight forward.
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Data Type Conversion についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!