Create new column based on values of other columns

24 views (last 30 days)
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

Answers (1)

Vinayak
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

Categories

Find more on Get Started with MATLAB in Help Center and File Exchange

Tags

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!