Help in importing csv file

good, I have two problems:

1 - The first is that I want to import a csv file to matlab which has the following form:

0000,1,0.142857

0001,0,0

0010,0,0

0011,0,0

0100,0,0

0101,3,0.428571

0110,0,0

0111,0,0

1000,0,0

1001,0,0

1010,2,0.285714

1011,0,0

1100,0,0

The point is that I want to represent me digits according to the first comma are here, but when you import matlab represents me well:

0

1

10

11

100

101

110

111

1000

1001

1010

1011

1100

1101

2 - my second question is how I can do to make each of these numbers represent me in each column:

1101 ------------ | 1 | 1 | 0 | 1 |

thank you very much

[bethel o]

I don't really understand your question. The use of 'me' is confusing. What is it?

Why don't you read the csv file yourself, Read the file line by line and split each line with

C = strsplit(str,',')

[FRANCISCO]

I can not read the csv file from excel because it contains a lot of data in excel file not fully charged. Then load it into Matlab and I intend to make these operations to transform the data as I said above. When I use:

if true

    % code

aaa = ImportData ('data.csv');

end

the file is read as follows:

0

1

10

11

100

101

110

111

1000

1001

1010

1011

1100

1101

and should read:

0000

0001

0010

0011

0100

0101

0110

0111

1000

1001

1010

1011

1100

and then I want is that each of these numbers is represented in a column in matlab:

0000 ----------- | 0 | 0 | 0 | 0 |

Answer 1

[Simon]

Hi!

You may just load your file and process it afterwards like

% load file
fid = fopen('data.csv', 'r');
FC = textscan(fid, '%s', 'Delimiter', '\n');
fclose(fid);
FC = FC{1};

% extract data
for n = 1:length(FC)
    Data{n, 1:3} = sscanf(FC{n}, '%s %d %f');
end

The format string depends on your data. If you use "%s", you will keep your first column as string '0000'. You can split this afterwards in 0|0|0|0.

Answer 2

[bethel o]

OK I was going to tell you what Simon already said. The full instructions can be found here Documentation