MATLAB: Cannot Load CSV file

csvdata importimport csv

I am trying to load a csv file using the import tool.

It takes forever (like a weekend was not enough…).

I've included the screenshot of what I am doing.

The file has numbers from H2 to AEQ639774. From A1 to AEQ1 I have headers. From A2 to G639774 I have identifiers.

I was trying to first load the numbers into a numeric matrix, and then repeat the process for headers and identifiers separately. But not even this works.

The file is 1.28 GB.. so big but not that big.

My machine has 16gb ram so that should be enough.

I am probably doing something wrong!

Thanks in advance!

Best Answer

That sounds fishy. What version of matlab are you using? I assume the problem persists after exiting and rebooting Matlab.

You could try rehashing the toolbox cache in case 3rd party toolboxes are interfering.

You could use an alternative method of importing the data such as xlsread() which bypasses some of the processing done by the import tool.

Related Solutions

MATLAB: Importdata misses some of the data in the file

This is not enough information to suggest an improvement. Please post the code and the attach the file, or better find out the part of the file, whcih cannot be imported successfully. Perhaps there are some unexpected characters, commas instead of decimal points or such details.

While importdata is really smart, the file format looks easy. Perhaps a dumb approach would be sufficient already:

function [Header, Data] = YourImport(FileName)
fid = fopen(FileName, 'r');
if fid == -1
  error('Cannot open file: %s', FileName);
end 
Header = cell(1, 3);
for k = 1:3
  Header{k} = fgetl(fid);
end
Data = fscanf(fid, '%g %g', [2, inf]).';  % Or however your "cloumns" are separated
fclose(fid);
end

Perhaps this helps already.

MATLAB: Read data from CSV and Excel

Learning how to use fread, fgetl and such functions solved my issue.

Best Answer

Related Solutions

MATLAB: Importdata misses some of the data in the file

MATLAB: Read data from CSV and Excel

Related Question