How to convert continuous variable into discrete variables?
显示 更早的评论
I am looking for the help !!
I have 5000 rows of data points for three variables (independent variables-X1,x2,x3 and dependent variables Y). The x1 and x2 are discreate variables in fix steps. However, the X3 variables is countinous ranges from 0-0.6. I want to transfrom this varibles in steps of 0.05 upto 0.6 total in 12 steps and corroespoing value of Y variables should be mean of all values correspond between 0- 0.05 and so.
Well, i tried with find(x3<0.05) and got the index of all values which is less than 0.05. but struggling to compute mean(y) for the indices, mostly they are continous.
Plz help me.
采纳的回答
Chetan Badgujar
2020-8-24
0 个投票
2 个评论
Alan Stevens
2020-8-24
Hmm. What about the following:
load('DATA.mat');
X3(1) = []; % the first values for X3 and Y are NaNs, so they are removed here
Y(1) = [];
x3 = (0:0.05:2)';
delta = length(Y)/41;
Ydiscrete = zeros(length(x3),1);
for i = 2:length(x3)
ix = (i-1)*delta:i*delta;
Ydiscrete(i) = mean(Y(ix));
end
subplot(2,1,1)
plot(X3,Y,'.',x3,Ydiscrete,'o')
Y = sort(Y);
X = 1:length(Y);
delta = length(Y)/41;
x = 1:delta:length(Y);
for i = 2:length(x)
ix = (i-1)*delta:i*delta;
Ydiscrete(i) = mean(Y(ix));
end
subplot(2,1,2)
plot(X,Y,'.',x,Ydiscrete,'o')
where the top plot uses X3 and Y, but the bottom plot basically just sorts Y.
:
Chetan Badgujar
2020-8-24
更多回答（3 个）
Alan Stevens
2020-8-23
Does the following do what you want?
X3 = 0:0.05:0.6;
Ydiscrete = zeros(length(X3));
for i = 2:length(X3)
ix = find(X3(i-1)<=x3<X3(i));
Ydiscrete(i) = mean(Y(ix));
end
Untested, as I don't have the data!
Alan Stevens
2020-8-24
How about this
load('DATA.mat');
X3(1) = []; % the first values for X3 and Y are NaNs, so they are removed here
Y(1) = [];
x3 = (0:0.05:0.6)';
Ydiscrete = zeros(length(x3),1);
for i = 2:length(x3)
ix = find(x3(i-1)<=X3<x3(i));
Ydiscrete(i) = mean(Y(ix));
end
plot(x3,Ydiscrete,'o')
Cris LaPierre
2020-8-24
编辑：Cris LaPierre
2020-8-26
0 个投票
类别
在 帮助中心 和 File Exchange 中查找有关 Resampling Techniques 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
