readtable command for csv file

10 次查看（过去 30 天）
Waqas Siddique
Waqas Siddique 2021-2-12
回答： Jeremy Hughes 2021-2-12
Hi,
I am having an issue while reading the csv file into MATLAB. The size of the csv file is greater than 100000KB. When I try to read it through the readtable command in MATLAB, it starts skipping some rows in the csv file and gives the following error
Error using readtable (line 223)
Reading failed at line 15473. All lines of a text file must have the same number of
delimiters. Line 15473 has 1 delimiters, while preceding lines have 515.
Note: readtable detected the following parameters:
'Delimiter', ',', 'ReadVariableNames', false, 'Format',

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

回答（3 个）

Cris LaPierre
Cris LaPierre 2021-2-12
Without seeing what lines 15473 looks like compared to, say, line 1, it's really hard to add to what the error message is already telling you. It would appear the format of your data changes.
You could try looking into some of the options in detectImportOptions. Perhaps "MissingRule","omitRow"? Or "ImportErrorRule","omitRow"?
Waqas Siddique
Waqas Siddique 2021-2-12
Line 1 is a row with data enteries in each column. Line 15473 has become a blank row and the corresponding data enteries have moved to the next line which is 15474.
  7 个评论
显示 5更早的评论
Walter Roberson
Walter Roberson 2021-2-12
See Cris's suggestion to use import options to see the error handling.

请先登录，再进行评论。

Jeremy Hughes
Jeremy Hughes 2021-2-12
Try this,
opts = detectImportOptions(filename)
T = readtable(filename,opts)
I think the import options based default reading behavior will work for you. (R2016b or later)
If you're in a MATLAB earlier than R2016b readtable won't be able to handle this file. You will need to read line by line, and parse each line separately.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by