Importing .csv data to matrix

Question

I have a .csv file with the following 'configuration'

'string', 'string', 'string', 'string', 'string'
'string', 'string', 21, 89, 67
'string', 'string', 45, 12, -16
'string', 'string', 78, 56, 45
'string', 'string', 23, 65, 90
'string', 'string', 43, 34, 75

I would like to ignore the first two columns and the first row, and import the numbers to a matrix.

I have tried using textscan, but without luck. Any experts? :-)

score 4 · Answer 1 · answered Jan 20 '15 at 11:56

4

Try dlmread. You can specify the row and column to start the import.

data = dlmread('test.txt',',',1,2)

data =

    21    89    67
    45    12   -16
    78    56    45
    23    65    90
    43    34    75

answered Jan 20 '15 at 11:56

Nemesis

2,324
13
23

This looks simpler than with `importdata` – Luis Mendo Jan 20 '15 at 11:57
Thanks. However, yours might be more flexible. – Nemesis Jan 20 '15 at 11:58

score 3 · Accepted Answer · answered Jan 20 '15 at 11:54

Use importdata:

x = importdata('filename.csv');

This gives an x struct with data and textdata fields:

>> x
x = 
        data: [5x3 double]
    textdata: {6x5 cell}

To get only the numeric values, use

x_numeric = x.data;

In your example, this gives

x_numeric =
    21    89    67
    45    12   -16
    78    56    45
    23    65    90
    43    34    75

Importing .csv data to matrix

2 Answers2