Why doesn't csvread read properly?

Hello,
I'm using csvread() to read my stored data from oscilloscope. Original file is 5000 rows long, but when I read .csv file it only reads to half of the file and every second value is 0. In the end vector is still 5000 row long but it's only half of the original. Why it does that and should I rather use textscan()?

3 comentarios

Stephen23
Stephen23 el 20 de Jul. de 2017
Editada: Stephen23 el 20 de Jul. de 2017
>> M = csvread('U_I_MS.csv');
>> size(M)
ans =
5001 3
>> M(1:5,:)
ans =
0.00000 0.00000 0.00000
0.00000 6.00313 60.00390
0.00048 55.20310 20.50390
0.00096 65.60310 29.00390
0.00144 25.60310 2.50391
Two questions:
  1. What version of MATLAB are you using?
  2. Why does the CSV file have semicolons at the end of each line?
Niko
Niko el 20 de Jul. de 2017
I'm using Matlab R2015a. Where do you see semicolons at the and of each line?
Stephen23
Stephen23 el 20 de Jul. de 2017
Editada: Stephen23 el 20 de Jul. de 2017
@Niko: a CSV file is a text file, so I opened it using Notepad++. How do you look at a text file?

Iniciar sesión para comentar.

 Respuesta aceptada

Jan
Jan el 20 de Jul. de 2017
I cannot imagine why your CSVREAD does not work. Perhaps you are reading the wrong file? The 2 semicolons at the end of the line are not nice, but the import should work inspite of this. Nevertheless, it is easy to import the file manually:
fid = fopen(FileName, 'r');
if fid == -1, error('Cannoten read file: %s', FileName); end
fgetl(fid); % Skip first line
Data = fscanf(fid, '%g, %g, %g ;;', [3, inf]).';
fclose(fid);

Más respuestas (1)

Kaelasha Tyler
Kaelasha Tyler el 17 de Mzo. de 2018

0 votos

I have had exactly the same problem as Niko. While it is possible to manually import the file as Jan says, it would be nice to know why the csvread command is not working as it should, and what to do about it. Any further suggestions, much appreciated.

Categorías

Etiquetas

Preguntada:

el 20 de Jul. de 2017

Respondida:

el 17 de Mzo. de 2018

Community Treasure Hunt

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

Start Hunting!

Translated by