Import large CSV file

12 visualizzazioni (ultimi 30 giorni)
SM
SM il 18 Gen 2021
Risposto: SM il 19 Gen 2021
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 Commenti
Ive J
Ive J il 18 Gen 2021
Modificato: Ive J il 18 Gen 2021
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 il 18 Gen 2021
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.

Accedi per commentare.

Risposte (1)

SM
SM il 19 Gen 2021
Thank you everyone
It seems there was a malfunction in microsoft excel.
It resolved spontaneously.

Community Treasure Hunt

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

Start Hunting!

Translated by