Readmatrix reading csv files incorrectly by replacing values with NaN and adding a third column

11 次查看（过去 30 天）
Mohid Muneeb
Mohid Muneeb 2024-6-6
编辑： Mohid Muneeb 2024-6-7
Hi all,
I have 10 ".csv" files which I am importing into MATLAB using the readmatrix function. All of these files are identical as follows:
Rows: 1000001 - First row has headers (Time [s], Volts [V]))
Columns: 2
All but two files are not being imported correctly. I have tried opening them in text editors to verify the comma delimiter and it is correct. I do not know what the issue is. For these two files, MATLAB reads the second (Volts) column as NaN and adds a third NaN column to it.
Kindly please help.
The line of code I am using is: variable_x = readmatrix('filename');
A short excript is as follows:
Important to note that I have also tried the 'range' and 'delimiter' options explicitly to no avail. Might be a bug. I am using R2023b

请先登录，再回答此问题。

采纳的回答

Mohid Muneeb
Mohid Muneeb 2024-6-7
编辑：Mohid Muneeb 2024-6-7
Edit: nevermind, I found the issue. There were two cells out of a million with problematic data in the .csv files I had issue with. I used the "csvread" function to locate this since the error it outputs tells the exact cell that has the problem as well as its actual text.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

标签

产品


版本

R2023b

Community Treasure Hunt

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

Start Hunting!

Translated by