Kindly help me solve this problem...

1 次查看（过去 30 天）
Umair Ejaz
Umair Ejaz 2022-9-5
回答： Ronny Jimenez 2024-5-17
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');

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

回答（2 个）

Sailesh Kalyanapu
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:
Group summary computations - MATLAB groupsummary - MathWorks India
Ronny Jimenez
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')

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2022a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by