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 commentaires

Stephen23
Stephen23 le 20 Juil 2017
Modifié(e) : Stephen23 le 20 Juil 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 le 20 Juil 2017
I'm using Matlab R2015a. Where do you see semicolons at the and of each line?
Stephen23
Stephen23 le 20 Juil 2017
Modifié(e) : Stephen23 le 20 Juil 2017
@Niko: a CSV file is a text file, so I opened it using Notepad++. How do you look at a text file?

Connectez-vous pour commenter.

 Réponse acceptée

Jan
Jan le 20 Juil 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);

Plus de réponses (1)

Kaelasha Tyler
Kaelasha Tyler le 17 Mar 2018

0 votes

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.

Catégories

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by