How to convert xls file to mat file in appdesigner?
2 次查看(过去 30 天)
显示 更早的评论
Hello, I am new in Matlab, I want to run nntool regression prediction in appdesigner, when i read excel files, it can't run the program. it shoes errors, so i am guessing because the xls files neeed to be converted into mat file maybe.
Below shown are the codes.
X = readtable('Fypinputdata.xlsx','Sheet',2);
app.UITable3.Data = X;
T = readtable('FypTargetdata.xlsx','Sheet',2);
app.UITable3_2.Data = T;
[net,tr] = train(net,X,T);
nntraintool
nntraintool('close')
plotperform(tr)
testX = X(:,tr.testInd);
testT = T(:,tr.testInd);
testY = net(testX);
perf = mse(net,testT,testY)
Y = net(X);
plotregression(T,Y)
e = T - Y;
ploterrhist(e)
Thanking you in advance
1 个评论
dpb
2021-11-16
Read the documentation more carefully and look at the examples -- I don't have the toolbox, but
shows you need to have defined the NN net object first, then the input variables are arrays or vectors; you've passed table objects, not the data in the tables.
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Monte Carlo Analysis 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!