remove the empty values

I want to remove the empty values so that each value has its own variable names

3 个评论

Hi,
Remove the empty values from what ?
What do you mean by 'each value has it own variable names' ?
Can you share your code ?
This is the excel file and the output i need is L and T but i get this output as shown in the image
So you want to get the 1st and 3rd row from the excel sheet?

请先登录,再进行评论。

回答(2 个)

Florian Bidaud
Florian Bidaud 2023-7-14
编辑:Florian Bidaud 2023-7-14
A = readtable("Book2.xlsx")
L1 = A.Value1([A.Parameters{:}] == 'L')
L2 = A.Value2([A.Parameters{:}] == 'L')
T1 = A.Value1([A.Parameters{:}] == 'T')
T2 = A.Value2([A.Parameters{:}] == 'T')
If you want to keep a table :
B = A(~isnan(A.Value1),:)

类别

帮助中心File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

提问:

PA
2023-7-14

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by