why do i get an error in my code?

2022 12 15
2 个回答
更新时间：2022 12 16
8 次查看（30 天）

0 个投票

load("stormData");
stormData.Property_Cost(ismissing(stormData.Property_Cost))=0;
stormData.Crop_Cost(ismissing(stormData.Crop_Cost))=0;
stormData.Total_Cost(ismissing(stormData.Total_Cost))=0;
summaryRegionCosts= groupsummary(stormData, "Region", ["min", "median", "mean", "max"], "Total_Cost")
stormDataPos= stormData(stormData.Total_Cost > 0, :)
summaryRegionPosCosts= groupsummary(stormDataPos, ["min", "median", "mean", "max"], "Total_Cost")

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

回答（2 个）

VBBV
VBBV 2022-12-15

1 个投票

TT = load("stormData");
Load the data into variable nd use it in groupsummary
summaryRegionCosts= groupsummary(TT, "Region", ["min", "median", "mean", "max"], "Total_Cost")

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

Emem
Emem 2022-12-15
移动：VBBV 2022-12-16
load("stormData");
stormData.Property_Cost(ismissing(stormData.Property_Cost))=0;
stormData.Crop_Cost(ismissing(stormData.Crop_Cost))=0;
stormData.Total_Cost(ismissing(stormData.Total_Cost))=0;
summaryRegionCosts= groupsummary(stormData, "Region", ["min", "median", "mean", "max"], "Total_Cost")
stormDataPos= stormData(stormData.Total_Cost > 0, :)
idx= find(stormData.Total_Cost > 0)
postVals= stormData.Total_Cost (idx)
summaryRegionPosCosts= groupsummary(postVals, "Region", ["min", "median", "mean", "max"], "Total_Cost")
%% a new code i wrote but it is still generating an error message
VBBV
VBBV 2022-12-15
移动：VBBV 2022-12-16
if you load the data, do you view it as table array or numeric array ?
load("stormData");
groupsummary takes table or timetable data only as input source
Emem
Emem 2022-12-16
移动：VBBV 2022-12-16
I view it as a table error and attached is the error message i keep getting.
Emem
Emem 2022-12-16
Unfortunately, i am unable to load the data into variable and use it in groupsummary.
load("stormData"); is uneditable in Mathworks external tool.

请先登录，再进行评论。

Walter Roberson
Walter Roberson 2022-12-16
移动：Walter Roberson 2022-12-16

1 个投票

  • before all of this your MATLAB path might be very messed up
  • you might have a variable named "path" in your mat file that is messing everything up (but the message would be different for this case I think)
  • most likely case: either before this you assign to a variable named "find" or else you are loading a variable named "find". The error message is completely compatible with the possibility that you have a variable named "find" stored in the file.

类别

在 帮助中心 和 File Exchange 中查找有关 Data Preprocessing 的更多信息

标签

提问:

Emem
Emem
2022-12-15

移动:

Walter Roberson
Walter Roberson
2022-12-16

Community Treasure Hunt

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

Start Hunting!

Translated by