Taking a few columns out of a big array and making a new smaller one

2 views (last 30 days)
I have a data array with 24 columns and a 10k+ rows of data. I want to take 4 of the columns (column 2,4,8,and a constant value of "1900") and make a new array for calculations. How do I do this?

Accepted Answer

Image Analyst
Image Analyst on 3 Feb 2017
Edited: Image Analyst on 3 Feb 2017
Try this:
smallArray = bigArray(:, [2,4,8]); % Extract columns 2, 4, 8.
Actually, I'm not sure what the "and a constant value of "1900"" means for your array of 24 columns. If you want to tack on a column of all values of 1900, do this
smallArray = [smallArray, 1900*ones(size(smallArray, 1), 1)];
  3 Comments
Bennett Torrance
Bennett Torrance on 3 Feb 2017
How would I make it so the 1900 column is the first column instead of the last one?
Image Analyst
Image Analyst on 3 Feb 2017
Just put it in front:
smallArray = [1900*ones(size(smallArray, 1), 1), smallArray];

Sign in to comment.

More Answers (0)

Products

Community Treasure Hunt

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

Start Hunting!