Reading CSV files with MATLAB?

by

csvread can only read doubles, so it’s choking on the date field. Use textscan.

fid = fopen('out2.csv');
out = textscan(fid,'%s%f%f','delimiter',',');
fclose(fid);

date = datevec(out{1});
col1 = out{2};
col2 = out{3};

Update (8/31/2017)

Since this was written back in 2013, MATLAB’s textscan function has been updated to directly read dates and times. Now the code would look like this:

fid = fopen('out2.csv');
out = textscan(fid, '%{MM/dd/uu HH:mm:ss}D%f%f', 'delimiter', ',');
fclose(fid)

[date, col1, col2] = deal(out{:});

An alternative as mentioned by @Victor Hugo below (and currently my personal go-to for this type of situation) would be to use readtable which will accept the same formatting string as textscan but assemble the results directly into a table object:

dataTable = readtable('out2.csv', 'Format', '%{MM/dd/uu HH:mm:ss}D%f%f')
dataTable.Properties.VariableNames = {'date', 'col1', 'col2'};

dataTable =

  3×3 table

           date             col1      col2 
    ___________________    ______    ______

    03/09/2013 23:55:12    129.32    129.33
    03/09/2013 23:55:52    129.32    129.33
    03/09/2013 23:56:02    129.32    129.33

More Related Contents:

  1. Loop through files in a folder in matlab
  2. find unknown value in matrix using MATLAB [closed]
  3. Subscript indices must either be real positive integers or logicals, generic solution
  4. Finding islands of zeros in a sequence
  5. Weighted random numbers in MATLAB
  6. Using GCC (MinGW) as MATLAB’s MEX compiler
  7. Approaches to create a video in matlab
  8. Suppress Output
  9. How do I set default values for functions parameters in MATLAB?
  10. How to select a submatrix (not in any particular pattern) in Matlab
  11. Matlab ode solvers: changing state and specified time
  12. Generate a random number in a certain range in MATLAB
  13. Access m-files in a subfolder without permanently adding it to the path
  14. What does operator “dot” (.) mean?
  15. Suppress exponential formatting in figure ticks
  16. Declaring a global variable in MATLAB
  17. How can I find the maximum value and its index in array in MATLAB?
  18. Vectorizing the Notion of Colon (:) – values between two vectors in MATLAB
  19. Shading an area boundered by a curve
  20. How to find all permutations (with repetition) in MATLAB?
  21. How can I change the color of bars in bar graph?
  22. Change color of 2D plot line depending on 3rd value
  23. How do I retrieve the names of function parameters in matlab?
  24. Producing subplots and then combine them into a figure later in MATLAB
  25. How do you use the LaTeX blackboard font in MATLAB?
  26. MATLAB find and apply function to values of repeated indices
  27. Control colorbar scale in MATLAB
  28. Indexing of unknown dimensional matrix
  29. Implementing anonymous functions in Fortran
  30. How to apply a low-pass or high-pass filter to an array in Matlab?

Leave a Comment