Kindly help me solve this problem...
1 回表示 (過去 30 日間)
古いコメントを表示
load("stormData");
summaryRegionCosts = groupsummary(stormData, 'Region',{"min","max","median","mean"} , 'Total_Cost');
stormDataPos = stormData.Total_Cost> 0 ;
summaryRegionPosCosts = groupsummary(stormData, 'Region', {"min","max","median","mean"},'stormDataPos');
0 件のコメント
回答 (2 件)
Sailesh Kalyanapu
2022 年 9 月 8 日
As per my understanding you are trying to use 'groupsummary' function to create a table to show the min, max, median and mean total cost by region for the subset of data which has total cost greater than zero.
It seems that the input arguments are being passed incorrectly in the (line 4) of your solution
% This modification would solve the issue
summaryRegionPosCosts = groupsummary(stormDataPos, 'Region', {"min","max","median","mean"},'Total_Cost');
For more information on ‘groupsummary’, please refer to the below link to its documentation:
Ronny Jimenez
2024 年 5 月 17 日
Here's the code.
summaryRegionCosts = groupsummary(stormData, 'Region',{"min","median","median","mean","max"},'Total_Cost');
stormDataPos = stormData(stormData.Total_Cost > 0,:);
summaryRegionPosCosts = groupsummary(stormDataPos, 'Region',{"min","median","median","mean","max"},'Total_Cost')
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Database Toolbox についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!