how to calculate how many rows are having numeric values in a particular cell of an excel sheet data.

1 visualización (últimos 30 días)
pranati pradhan
pranati pradhan el 21 de Nov. de 2019
Respondida: Bob Thompson el 21 de Nov. de 2019
I have an excel sheet,there are 9 columns are there.In column no 6,some values are numeric values and some are NaN.So how to calculate how many rows contain numeric values.Please help me with this.

Iniciar sesión para responder a esta pregunta.

Respuesta aceptada

Bob Thompson
Bob Thompson el 21 de Nov. de 2019
Read the file with xlsread, filter the NaN values, then determine the number of the remaining values.
numnumerics = sum(~isnan(data(:,6)));

Más respuestas (0)

Categorías

Más información sobre Spreadsheets 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