Grouping age data into 5 year bins

Question

chiefjia 2021-5-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/828080-grouping-age-data-into-5-year-bins

评论： DGM 2021-5-12

Dear MATLAB experts,

I'm trying to create a new column in a table, which contains the age binned into 5 years intervals per row. This column should create the age bins according to another column in the same table, which specifies the age of the individual per row. In order to make what I'm looking for more clear, here a few examples:

If the age of the individual in a certain row were 25.92 (in the age column), the binned age column should display the following value: (25.0, 30.0]

If the age of the individual in a certain row were 42.53 (in the age column), the binned age column should display the following value: (40.0, 45.0]

If the age of the individual in a certain row were 33 (in the age column), the binned age column should display the following value: (30.0, 35.0]

... and so on

Thank you in advance

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

请先登录，再进行评论。

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

Answer 1

DGM 2021-5-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/828080-grouping-age-data-into-5-year-bins#answer_698070

编辑：DGM 2021-5-12

在 MATLAB Online 中打开

I'm going to just do this example starting with a numeric vector, but you can adapt it to use your table if you want.

age = rand(10,1)*50+15; % random pretend data
bs = 5;
agebin = ceil(age/bs)*bs; 
agebin = [agebin-bs agebin]
agetable = table(age,agebin) % make a table

gives

agetable =
  10×2 table
     age       agebin 
    ______    ________
211    25    30
016    40    45
641    60    65
78    40    45
965    15    20
753    50    55
554    40    45
962    25    30
771    30    35
543    45    50

If it's instead desired to have that field as a char/string with the brackets as shown:

age = rand(10,1)*50+15; % random pretend data
bs = 5;
agebin = ceil(age/bs)*bs; 
agebin = [agebin-bs agebin]
agebin = sprintfc('(%d %d]',agebin); % reformat it
agetable = table(age,agebin) % make a table

gives

agetable =
  10×2 table
     age        agebin   
    ______    ___________
402    {'(30 35]'}
001    {'(50 55]'}
773    {'(15 20]'}
628    {'(30 35]'}
063    {'(20 25]'}
851    {'(20 25]'}
988    {'(35 40]'}
377    {'(45 50]'}
798    {'(15 20]'}
282    {'(45 50]'}

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

chiefjia 2021-5-12

Thanks for your answers! This has helped me a lot, I understand how you've done it, but I wouldn't be able to come up with the answer on my own.

DGM 2021-5-12

No worries. There are plenty of code examples around here that make me feel the same way.

请先登录，再进行评论。

Answer 2

J. Alex Lee 2021-5-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/828080-grouping-age-data-into-5-year-bins#answer_698085

编辑：J. Alex Lee 2021-5-12

在 MATLAB Online 中打开

Interesting, this could be useful for me too! You can use "discretize" to bin the data. Below is a quick and dirty class to implement this idea.

BinEdges = 20:5:45
Data = [25.92;42.53;33;30]
% make sure discretize does what i want
[BData,E] = discretize(Data,BinEdges,"IncludedEdge","right")
LeftEdges = BinEdges(BData)
RightEdges = BinEdges(BData+1)

Using the class below results in:

>> db = DataBins(BinEdges,Data)
db = 
    "[25,30)"
    "[40,45)"
    "[30,35)"
    "[30,35)"
>> db.IncludedEdge = "right"
db = 
    "(25,30]"
    "(40,45]"
    "(30,35]"
    "(25,30]"

The class

classdef DataBins < handle & matlab.mixin.CustomDisplay
	
	properties
		BinEdges
		IncludedEdge
		Value
		
		BinIDs
		LeftEdges
		RightEdges
	end
	
	methods
		
		function this = DataBins(BinEdges,Value,IncludedEdge)
			
			arguments
				BinEdges (1,:)
				Value
				IncludedEdge (1,1) string {mustBeMember(IncludedEdge,["left","right"])} = "left"
			end
			
			this.BinEdges = BinEdges;
			this.Value = Value;
			this.IncludedEdge = IncludedEdge;
			
			this.update();
			
		end
		
		function update(this)
			try % lazy way to only do when all data are set
				V = this.Value(:);
				S = size(this.Value);
				
				BIDs = discretize(V,this.BinEdges,"IncludedEdge",this.IncludedEdge);
				
				this.BinIDs     = reshape(BIDs,S);
				this.LeftEdges  = reshape(this.BinEdges(BIDs  ),S);
				this.RightEdges = reshape(this.BinEdges(BIDs+1),S);
			end
		end
		function set.BinEdges(this,val)
			this.BinEdges = val;
			this.update();
		end
		function set.Value(this,val)
			this.Value = val;
			this.update();
		end
		function set.IncludedEdge(this,val)
			this.IncludedEdge = val;
			this.update();
		end
	end
	
	methods (Access = protected)
		function displayScalarObject(this)
			switch this.IncludedEdge
				case "left"
					lb = "[";
					rb = ")";
				case "right"
					lb = "(";
					rb = "]";
			end
			disp(...
				compose("%s%d,%d%s",lb,this.LeftEdges,this.RightEdges,rb) ...
				);
		end
	end
end