How can I split an array into different arrays defined by an index?

Question

0 个投票

Hello all,

I have a large array of household income data and an index for the spatial unit the household is located in.

A= [AT1,24566;
    AT1,40521;
    AT2,32512;
    BE1,66542;
    .
    .
    .]

I would like to transform that array into arrays according to the spatial index so I can compute GINI coefficients in a next step.

Thank you Dragos

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

请先登录，再进行评论。

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

Follow Question

Answer 1

Mohammad Abouali 2015-10-15

在 MATLAB Online 中打开

0 个投票

Is AT1 a variable storing a number? or did you mean

A={'AT1',24566;
   'AT1',40521;
   'AT2',32512;
   'BE1',66542 ...}

if A is stored as above than to extract AT1 household incomes you could do:

AT1_HouseHoldIncome=cell2mat(A(strcmpi(A(:,1),'AT1'),2))
AT1_HouseHoldIncome =
         24566
         40521

2 个评论
显示无隐藏无

Dr.Agos 2015-10-16

I can think of another workaround. I assign to every region code a number (AT1 then becomes 1) and define my data as matrix. how would the code change?

Thanks a lot

Mohammad Abouali 2015-10-16

在 MATLAB Online 中打开

If A is matrix like:

A=[1,24566;
   1,40521;
   2,32512;
   3,66542 ...]

then

AT1_HouseHoldIncome=A( A(:,1)==1 ,2);

so A(:,1)==1 pretty much masks all those rows in first column that are storing 1 and then A( A(:,1)==1, 2) returns the second column for those rows.

Refer to Logical Indexing for more info on these type of indexing in MATLAB.

请先登录，再进行评论。

How can I split an array into different arrays defined by an index?

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

采纳的回答

2 个评论
显示无隐藏无

更多回答（0 个）

类别

标签

Community Treasure Hunt

How can I split an array into different arrays defined by an index?

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

采纳的回答

2 个评论 显示 无 隐藏 无

更多回答（0 个）

类别

标签

另请参阅

Community Treasure Hunt

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

2 个评论
显示无隐藏无