Borrar filtros
Borrar filtros

remove the empty values

2 visualizaciones (últimos 30 días)
PA
PA el 14 de Jul. de 2023
Editada: Florian Bidaud el 14 de Jul. de 2023
I want to remove the empty values so that each value has its own variable names
  3 comentarios
PA
PA el 14 de Jul. de 2023
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 el 14 de Jul. de 2023
So you want to get the 1st and 3rd row from the excel sheet?

Iniciar sesión para comentar.

Respuestas (2)

NAVNEET NAYAN
NAVNEET NAYAN el 14 de Jul. de 2023

Florian Bidaud
Florian Bidaud el 14 de Jul. de 2023
Editada: Florian Bidaud el 14 de Jul. de 2023
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),:)

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by