How to import csv file of 200 rows by 4096 columns without truncation?

3 次查看（过去 30 天）
Derrick Tiew
Derrick Tiew 2014-6-2
评论： Derrick Tiew 2014-6-2
I am facing a problem trying to read in a csv file of 200 rows by 4096 columns. I have tried the following commands to read in the file: csvread, xlsread, load However, each time I noticed that I was only able to read in 200 rows by 256 columns to a data array. When I did a preview of the csv file in Matlab, I saw the message 'Preview truncated at twenty thousand characters'. If the number of rows is only 100 rows, then the number of columns that I am able to read in is 2048. It seems that there is a limit to the number of data values that Matlab will be able to read in from a file. May I know if there is a way to extend the memory space of Matlab so that I can read in data values from a csv file with more than 200 rows by 4096 columns?

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

采纳的回答

Niklas Nylén
Niklas Nylén 2014-6-2
  3 个评论
显示 1更早的评论
Niklas Nylén
Niklas Nylén 2014-6-2
编辑：Niklas Nylén 2014-6-2
To me it sounds like it is only the preview that is truncated, not the data itself.
This works for me:
% Write a csv file with random values, size 200*4096
x = rand(200,4096);
csvwrite('test.csv',x)
a = csvread('test.csv');
b = importdata('test.csv');
Except for small rounding errors, x, a and b are identical:
>> max(max(abs(x-a)))
ans =
5.0000e-006
Derrick Tiew
Derrick Tiew 2014-6-2
Thanks for the info. Yup, it works all right now after a second try with the same csv file. All (cvsread, xlsread, load and importdata) can load in 200rows by 4096cols without issue. It was strange that we did fabricate 4096cols before in the csv file and was only able to load it half of the cols. Anyway, it works now.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by