Combining variable from several m files to one

2014 10 3
1 个回答
更新时间：2014 10 6
34 次查看（30 天）

0 个投票

Hi,
I have data in 1x1 matrices. There are 178 '.mat' files each file contains 36 variables with same names but different values. I want to create a loop so that I could combine them to one file with 36 variables but 178 values, each value in one column.
Is it possible? If yes how?
Kind Regards, Mustahsan

请先登录，再回答此问题。

回答（1 个）

per isakson
per isakson 2014-10-4
编辑：per isakson 2014-10-4

0 个投票

"Is it possible?" &nbsp yes
"If yes how?" &nbsp See example below
Comments:
  • "1x1 matrices" &nbsp that's a scalar
  • "36 variables" &nbsp requires a lot of typing. To save keystrokes I create name with sprintf and use '-regexp', '^p\d{2}'
  • "to one file with 36 variables" &nbsp do you mean mat-file?
  • "each value in one column" &nbsp do you mean that the values of the variables are column vectors?
Example:
nF = 3; % number of files
nV = 4; % number of variables
Create some mat-files
for ii = 1 : nF
for jj = 1 : nV
assign( sprintf( 'p%02d', jj ), ii+jj/100 )
end
save( sprintf( 'mydata%02d', ii ), '-regexp', '^p\d{2}' );
clear( '-regexp', '^p\d{2}' )
end
Read mat-files and concatenate data
p01 = nan( nF, 1 );
p02 = nan( nF, 1 );
p03 = nan( nF, 1 );
p04 = nan( nF, 1 );
for ii = 1 : nF
sas = load( sprintf( 'mydata%02d', ii ), '-regexp', '^p\d{2}' );
p01(ii,1) = sas.p01;
p02(ii,1) = sas.p02;
p03(ii,1) = sas.p03;
p04(ii,1) = sas.p04;
end
Save to one file
save( 'mydata', '-regexp', '^p\d{2}' );
clear( '-regexp', '^p\d{2}' )
where
function assign( Name, Value )
assignin( 'caller', Name, Value );
end
I don't recommend the use of the function assign

2 个评论
显示 无 隐藏 无

Mustahsan Majeed
Mustahsan Majeed 2014-10-6
"1x1 matrices" that's a scalar yes it was a vector and I took average mean value of all and made it a scalar
"36 variables" requires a lot of typing. To save keystrokes I create name with sprintf and use '-regexp', '^p\d{2}' I am unable to use the srint command
"to one file with 36 variables" do you mean mat-file? yes I want to make one .mat file with 36 variables and in each variable I want 1 column with each cell representing one value from each of the 178 files (so every variable will be (1x178) matrice
"each value in one column" do you mean that the values of the variables are column vectors? (1x178) is the end format for each varibale
  • thank you very much for your kind help *
Mustahsan Majeed
Mustahsan Majeed 2014-10-6
BTW I have a list of the variables exactly typed in, so I can use them too. But its better to learn how to do it without typing all of them.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Structures 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by