Reading and calculations with a csv file with a pair of numbers in each cell
3 次查看(过去 30 天)
显示 更早的评论
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
0 个评论
采纳的回答
Jan
2016-2-18
编辑:Jan
2016-2-18
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.
3 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!