Convert table and obtain column values

1 visualización (últimos 30 días)
Collegue
Collegue el 13 de Sept. de 2019
Respondida: Steven Lord el 18 de Sept. de 2019
Hello, I have this table
Captura.PNG
How can I first generate an array of string and numbers and then replace the '---' with NaN. Finally I would need to get the values of the Var4 and Var 7.
  2 comentarios
KALYAN ACHARJYA
KALYAN ACHARJYA el 13 de Sept. de 2019
Have you check here readtable?
Collegue
Collegue el 13 de Sept. de 2019
Yes I have conberted to table and that is the table that i have obtained.

Iniciar sesión para comentar.

Respuesta aceptada

Jalaj Gambhir
Jalaj Gambhir el 16 de Sept. de 2019
Hi,
For the particular task one possible solution could be by first converting the table to cell array using table2cell. And then traversing through the structure to search for ‘- -’ and replacing it with NaN
T = cell(CellArray);
for i=1:length(CellArray)
for j= 1:length(CellArray{1})
if ~isequal(CellArray{i,j},'--')
T{i,j} = CellArray{i,j};
else
T{i,j} = NaN;
end
end
end
R = cell2table(T);
And finally access the 4th and 7th column from the table by:
R(:,[4,7])

Más respuestas (1)

Steven Lord
Steven Lord el 18 de Sept. de 2019
Use ismissing to locate the missing values (you can tell ismissing what it should consider as a missing value) then use the logical array output to replace the missing values with whatever value you want.
The fact that you're changing the data type (potentially for some but not all of the values of a table variable) could complicate things a bit, but if that's the case show a larger sample of your table (maybe two or three rows that have a missing value and two or three that don't) and we may be able to help you determine how to handle that situation.

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by