Create new column based on values of other columns
10 views (last 30 days)
Show older comments
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)
Answers (1)
Vinayak
on 23 May 2023
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 Comments
See Also
Categories
Find more on Get Started with MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!