How can I bin Data
5 ビュー (過去 30 日間)
古いコメントを表示
My problem is the following:
How can I bin the data in this case: I have a matrix with column 1 x with 90 values of price and column 2 y with 90 values of demand. I want to bin the x values for example
x<30 as x1, 30<x<35 as x2,35<x<40 as x3, 40<x<45 as x4,45<x<47 as x5,47<x49 as x6, 49<x<52 as x7 and x>52 as x8. And I want to have for each x1,x2,..,x8 all the replicates of y in a matrix.
Then to find the mean of y-s for each x1,x2,...,x8.
0 件のコメント
回答 (2 件)
Star Strider
2019 年 3 月 14 日
There are probalby several ways.
One approach:
x = randi(90, 90, 1); % Create Data
y = rand(90,1) .* sin(2*pi*x/90); % Create Data
partitions = [0 30; 30 35; 35 40; 40 45; 45 47; 47 49; 49 52; 52 max(x)+1];
for k1 = 1:size(partitions,1)
ypartmean(k1) = mean(y((x >= partitions(k1,1)) & (x < partitions(k1,2))));
end
Experiment to get the result you want.
7 件のコメント
Star Strider
2019 年 3 月 14 日
No worries, and no confusion. It simply would have been easier to have addressed all this at once.
If my Answer helped you solve your problem, please Accept it!
Steven Lord
2019 年 3 月 14 日
If I understand your application correctly use histcounts2 to bin the data. The fourth and fifth output are the indices of the bins into which each element of your x and y data is binned. Use that bin information as the grouping variables in a call to groupsummary. See the "Multiple Grouping Vectors for Vector Input" example on the groupsummary documentation page for an illustration of the latter part of this technique.
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Annotations についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!