Create new column based on values of other columns
7 次查看(过去 30 天)
显示 更早的评论
I need to create a new variable column based on values of other variables.
I need to do this for multiple subjects (n=35). Also multiple blocks (8).
I have a matrix of trials, blocks, IV1, IV2, IV3, DV
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1158913/image.png)
回答(1 个)
Vinayak
2023-5-23
Hi Joe,
I am not sure regarding the condition on the basis of which you want to create the new column based off the other columns.
Assuming, you want to create a new column say IV7 (7th column), which is a sum of IV1, IV2 and IV3, (1st 3 columns), you can use the following code snippet.
% Load your data into a matrix called 'data'
load('data.mat')
% Create a new column based on the values of IV1, IV2, and IV3
data(:,7) = data(:,3) + data(:,4) + data(:,5);
% Save the updated matrix to a new file
save('updated_data.mat', 'data')
Thanks,
Vinayak
0 个评论
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!