Reading and calculations with a csv file with a pair of numbers in each cell

 I was wondering if anyone could help me with the following problem :

I need to read data from a .csv file into MATLAB so that I can work with it and perform calculations . The numbers in each cell are in the following format : {0.003336 , 0.023000}. I'm working with 128 x 128 cells in a spreadsheet . Functions such as csvread aren't working for me possibly because there are curly brackets as well as numbers in each cell ?

Ideally I would like to store the first number of each pair as the (1,1) element of a 2x2 matrix M and the second number as the (2,2) element in M . But I need the data to be read first !

Any help and advice would be much appreciated !

Saba

Answer 1

[Jan]

Would this work:

fid = fopen(FileName, 'r');
if fid == -1, error('Cannot open file: %s', FileName); end
Data = fscanf(fid, '{%g, %g}', 128*128);  % Edited: fid inserted
fclose(fid);

The wanted output format is not clear: What should the other 2 elements of M contain and how do you want to store the 128*128 M's?

If you append an example file or at least some lines of the file as text, testing a suggestion would be easier.

[Saba Malik]

thanks for the reply . For some reason the above code doesn't work for me - I get this error message : Error using fscanf Invalid file identifier. Use fopen to generate a valid file identifier.

Sorry for the lack of clarity . What I have is a csv file containing data in the format described earlier (attached file)

I want my program to set the first value of each pair as the (1,1) element of a matrix M and the second value as the (2,2) element of the matrix M , with the other elements being 0 ( diagonal matrix) . So like this :

M =  0.03   0
     0    0.002

a program I've written successfully calculates the eigenvalues of this matrix (2 eigenvalues per matrix) . I would like to store these eigenvalues in exactly the same way as the attached data file: as a csv file in the {number , number} format .

I hope that's clear

[Saba Malik]

sorry i realise the file i attached before was the excel version ; here's the csv

[Jan]

I forgot the fid in the fscanf call. The code ist fixed. My question about the M-matrix: You get 128*128 M-matrices, when I understand it correctly. How do you want to store them? As a {128 x 128} cell matrix?

There is no attached csv file.