Import large CSV file

SM
2021 1 18
1 个回答
更新时间：2021 1 19
3 次查看（30 天）

0 个投票

Hello
I have a CSV file that has 239615 rows and 24 columns with 85 Mb size.
the first row is headers and the rest of it are numbers.
I tried the following methods:
1-readmatrix
2-readtable
3-Matlab import
all of them only read up to 238491 and ignored rest of it.
Does anyone have any idea how to read the whole file?
Cheers

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Rik
Rik 2021-1-18
Did you try reading it as text and parsing it yourself? I am not aware of any documented limit in the number of lines Matlab can read. Are you sure there are no empty lines?
Mathieu NOE
Mathieu NOE 2021-1-18
hi
I tested readcell without a problem (from a csv file created with 239615 x 24 random matrix values)
R2020b
Ive J
Ive J 2021-1-18
编辑：Ive J 2021-1-18
Unless you have some specific issues with your machine, your file is not even close to being large. Manually inspect your file (Notepad++ for instance) or just read it entirely by fileread and splitlines to see what's really going on with your file.
Walter Roberson
Walter Roberson 2021-1-18
xls files have a maximum of 65535 rows, but cvs files should not have that limitation.
As an experiment, try readmatrix with the 'Encoding', 'UTF-8' option.

请先登录，再进行评论。

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

回答（1 个）

SM
SM 2021-1-19

0 个投票

Thank you everyone
It seems there was a malfunction in microsoft excel.
It resolved spontaneously.

类别

在 帮助中心 和 File Exchange 中查找有关 Text Files 的更多信息

标签

提问:

SM
SM
2021-1-18

回答：

SM
SM
2021-1-19

Community Treasure Hunt

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

Start Hunting!

Translated by