Im not able to find the error
1 次查看(过去 30 天)
显示 更早的评论
This is my code , im trying to develop an ANN model for solar radiation prediction , Im getting the error Dimensions of arrays being concatenated are not consistent. I dont know which line the error is help someone . Thanks in advance
G_T=xlsread(fileName, sheetName , 'B3:B39999');
M=xlsread(fileName, sheetName , 'AO3:AO39999');
D=xlsread(fileName, sheetName , 'AN3:AN39999');
H=xlsread(fileName, sheetName , 'A3:A39999');
G_T_Test=xlsread(fileName, sheetName , 'B40000:B44641');
M_Test=xlsread(fileName, sheetName , 'AO40000:AO44641');
D_Test=xlsread(fileName, sheetName , 'AN40000:AN44641');
H_Test=xlsread(fileName, sheetName , 'A40000:A44641');
%------------
inputs = [M,D,H];
I=inputs;
targets= [G_T];
T=targets;
%-------ann Model development and training
net = newff(I,T,5);
Y = sim(net,I);
net.trainParam.epochs = 100;
net = train(net,I,T);
%------------testing the developed model--------
test=[M_Test,D_Test,H_Test];
Test1=test;
G_Mi = sim(net,Test1);
G_M= G_Mi;
%-------------------
G_Tp=[ ];
for i=1:1:length(G_M)
G_Tp=[G_Tp ; G_M(i,1)];
end
G_Tp;
plot (G_T_Test)
hold on
plot(G_Tp,'red')
This is my code
回答(1 个)
KSSV
2020-8-21
Xlsread has become obselete. You should try readtable.
T = readtable(myfile) ;
From T you can pick any column, index you want. This makes your life more easy. You can straight away pick the data you want and you can avoid such errors like joining data.
2 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!