How do I seperate two columns of data into 12 different variables based on the number from the first column?

Question

Marissa Holden 2017-5-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/342445-how-do-i-seperate-two-columns-of-data-into-12-different-variables-based-on-the-number-from-the-first

评论： Star Strider 2017-5-31

I have a variable with two columns, the first column are numbers that correspond to parameters for an experiment (there are 12 unique parameters total called "speed"), the second column is my raw data. I need to seperate the raw data into 12 different variables based on the numbers from the first column.

One of the parameters is a speed of 4... I pretty much want to tell matlab "If Column one = 4, the number next to 4 will go into a variable called speed4" Is there anyway to do this???

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2017-5-30

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/342445-how-do-i-seperate-two-columns-of-data-into-12-different-variables-based-on-the-number-from-the-first#answer_268863

在 MATLAB Online 中打开

One approach that appears to work:

Data = [randi(12, 20, 1)  randi(99, 20, 2)];                        % Create Data
speed = accumarray(Data(:,1), Data(:,2), [], @(x) {cat(2,x)});      % Construct ‘speed’

4 个评论
显示 2更早的评论隐藏 2更早的评论

Star Strider 2017-5-30

Thank you!

My pleasure. The accumarray function is quite useful. It operates on the first argument as the index variable (indices must be integers greater than zero), then takes the second argument and either adds it to the other values (the default) or uses the function in the fourth argument to create the desired output. (The third argument is the size of the output, not used here, so is designated as the empty matrix. Arguments to functions have to appear in the specific order the function expects them.)

The anonymous function, ‘@(x) {cat(2,x)}’ creates a cell array of the elements in ‘Data(:,2)’ by concatenating them along the second (column) dimension. (See the documentation on Anonymous Functions (link) for more information on them.) The cat function performs this. The accumarray function, using the anonymous function, then stores them as a cell array (the curly brackets ‘{}’ denote a cell array, or indexing into a cell array) because cell arrays allow for empty elements and for different sizes of the columns (here), something a numeric array does not allow.

You can access the data in ‘speed’ by using cell array indexing. So you would access the values of the 4th element of ‘speed’ as ‘speed{4}’, the cell element being a double array. See the documentation on Cell Arrays (link) if you are not familiar with them. They are quite useful for storing data, and are usually easy to use in calculations.

If you want any further clarification or explanation, I will do my best to provide it.

Marissa Holden 2017-5-31

Thank you so so much for your help :)!!

Star Strider 2017-5-31

As always, my pleasure!

请先登录，再进行评论。

How do I seperate two columns of data into 12 different variables based on the number from the first column?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

4 个评论
显示 2更早的评论隐藏 2更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

How do I seperate two columns of data into 12 different variables based on the number from the first column?

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

4 个评论 显示 2更早的评论隐藏 2更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

4 个评论
显示 2更早的评论隐藏 2更早的评论