remove the empty values

3 次查看（过去 30 天）
PA
PA 2023-7-14
编辑： Florian Bidaud 2023-7-14
I want to remove the empty values so that each value has its own variable names
  3 个评论
显示 1更早的评论
PA
PA 2023-7-14
This is the excel file and the output i need is L and T but i get this output as shown in the image
Dyuman Joshi
Dyuman Joshi 2023-7-14
So you want to get the 1st and 3rd row from the excel sheet?

请先登录，再进行评论。

请先登录，再回答此问题。

回答（2 个）

NAVNEET NAYAN
NAVNEET NAYAN 2023-7-14
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),:)

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by