Import large CSV file

21 vues (au cours des 30 derniers jours)
SM le 18 Jan 2021
Réponse apportée : SM le 19 Jan 2021
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:
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?
  4 commentaires
Walter Roberson
Walter Roberson le 18 Jan 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.

Connectez-vous pour commenter.

Réponses (1)

SM le 19 Jan 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