create cell array or matrix based on groups

Ali Sarab

2021 7 7

0 个回答

3 次查看（30 天）

0 个投票

i have 1 to 365 rows of date index for every days of one year and number of infected people by gender in each row and its location(17), here is my data columns

dateindex male female location age

1 1 0 newyork 25

1 0 0 newdehli 35

2 0 1 newyork 22.5

2 1 0 kentucki 15

2 0 1 california 30

3 0 0 newdehli 30

4 1 0 newyork 45

4 1 0 newdehli 52

4 0 1 newyork 71

4 0 0 newyork 65

I want to create 17 cell arrays or matrix according to my 17 different location which contain total number(sum) of male and female infected and mean age of them in each rows and combining duplicates of rows in a specific days and applying count of male and female and average to seprate columns and 17 matrices each for one location

requested columns ie. new york

dateindex totalmale totalfemale meanage

1 calculated calculated calculated

2 calculated calculated calculated

3 calculated calculated calculated

4 calculated calculated calculated

thanks for your solution or solutions