# How to hadle NAN data of csv file

11 visualizaciones (últimos 30 días)
Tahir el 3 de Nov. de 2014
Respondida: Chad Greene el 3 de Nov. de 2014
Hi, I read an excel file...now i want to one by one take the x values and y values from that excel file.....The x values are at the first column,and y value are in the second column..and similrly again x value at 3rd column and y value at fourth column.here is the code...but problem is the NAN data in file.
how to skip NAN data of file.i am also attaching the file here. there are 25 files so the loop.
for i=1:25
clear file;
file = xlsread(strcat('TrainingDataset\', num2str(i) , '.csv'));
x=file(:,1:2:end)
y=file(:,2:2:end)
average_x=mean(x(:))
average_y=mean(y(:))
end
##### 0 comentariosMostrar -2 comentarios más antiguosOcultar -2 comentarios más antiguos

Iniciar sesión para comentar.

### Respuestas (1)

Chad Greene el 3 de Nov. de 2014
Three possible solutions:
1. If you have the Statistics Toolbox,
average_x = nanmean(x(:));
average_x = nanmean(x(:));
3. If you prefer to ignore the NaNs yourself,
average_x = mean(x(isfinite(x(:))));
##### 0 comentariosMostrar -2 comentarios más antiguosOcultar -2 comentarios más antiguos

Iniciar sesión para comentar.

### Categorías

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

### Community Treasure Hunt

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

Start Hunting!

Translated by