How can i add a main line and main column for my table?
2 次查看(过去 30 天)
显示 更早的评论
my table :
'L1' 'B'
'L2' 'B'
'L3' 'A'
'L4' 'C'
'L5' 'B'
'L6' 'C'
'L7' 'C'
'L8' 'A'
How i'd like my table to be :
Line1 Line2
Col1 'L1' 'B'
Col2 'L2' 'B'
Col3 'L3' 'A'
Col4 'L4' 'C'
Col5 'L5' 'B'
Col6 'L6' 'C'
Col7 'L7' 'C'
Col8 'L8' 'A'
Then how can i find all lines with B as column, would something like b_values = table( 'B' == table(:,2))
expected output:
Line1 Line2
Col1 'L1' 'B'
Col2 'L2' 'B'
Col5 'L5' 'B'
0 个评论
采纳的回答
dpb
2018-7-22
Given c is a cell array of your initial data, then
t=cell2table(c,'VariableNames',{'Line1','Line2'},'RowNames',cellstr(num2str([1:size(c,1)].','Col%d')))
t =
8×2 table
Line1 Line2
_____ _____
Col1 'L1' 'B'
Col2 'L2' 'B'
Col3 'L3' 'A'
Col4 'L4' 'C'
Col5 'L5' 'B'
Col6 'L6' 'C'
Col7 'L7' 'C'
Col8 'L8' 'A'
>>
For such data, however, I'd strong recommend using categorical
>> t=table(categorical(c(:,1)),categorical(c(:,2)),'VariableNames',{'Line1','Line2'},'RowNames',cellstr(num2str([1:size(c,1)].','Col%d')))
t =
8×2 table
Line1 Line2
_____ _____
Col1 L1 B
Col2 L2 B
Col3 L3 A
Col4 L4 C
Col5 L5 B
Col6 L6 C
Col7 L7 C
Col8 L8 A
>>
0 个评论
更多回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!