Sorting matrices into different categories

Hello,
I am really struggling to figure out the following problem so would really appreciate any advice!
I have a excel file that has 5 columns and 18000 rows which follows the sample data attached above.
The fifth column identifies the position the person plays in and I need the data to be sorted so that the two different positions are in two tables/matrices which can then be individually manipulated.
Then, I need to sort column 4 (names) so that the same names are grouped together in the separate matrices.
I have tried to represent this in the sample.
I hope this makes sense.

2 个评论

Jan
Jan 2018-4-15
编辑:Jan 2018-4-15
"The fifth column identifies the position the person plays in and I need the data to be sorted so that the two different positions..."
The 5th column contains one position, e.g. "forward". So which "two different" positions are meant?
What does "individually manipulate" mean? What are "separate matrices"?
The two different positions are forwards and back. I need to split the data into two tables. Which can then be separately run through another function so their results can be compared.

请先登录,再进行评论。

回答(0 个)

类别

帮助中心File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息

产品

提问:

2018-4-14

评论:

2018-4-16

Community Treasure Hunt

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

Start Hunting!

Translated by