Error using load Number of columns on line 2 of ASCII file
62 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hamza Ali
am 16 Jan. 2017
Bearbeitet: Hamza Ali
am 17 Jan. 2017
Hello everybody !
I want to make a prediction by using Extreme learning Machine (ELM), but i encountered a problem when reading data from my file excel. My data are in the following form:
Column 1: contains the date format (dd / mm / yyyy hh: mm)
Column 2: contains numeric values.
Here is the code :
train_data=load(TrainingData_File);
T=train_data(:,1)';
P=train_data(:,2:size(train_data,2))';
clear train_data;
Here is the error :
Error using load
Number of columns on line 2 of ASCII file SolarData_training.xlsx must be the same as previous lines.
I use Matlab R2014 a.
Thank you so much !
0 Kommentare
Akzeptierte Antwort
Star Strider
am 16 Jan. 2017
It is best to not use the load function with Excel files. Use xlsread to import your data. Use the datenum function to convert your date and time strings to date numbers and other formats.
0 Kommentare
Weitere Antworten (4)
Niels
am 16 Jan. 2017
Bearbeitet: Niels
am 16 Jan. 2017
matlab tries to create a matrix with 2 rows. obviously your second row has more or less colums than the first row, so your matrix looks like
A =
1 0 2
3 4
such a matrix does not exist, thats why an error returns
use xlsread and the missing colums will be filled with NaNs
0 Kommentare
Walter Roberson
am 16 Jan. 2017
I would suggest readtable() for this purpose. As you are using R2014a, the times will not be converted to datetime objects; they will either show up as excel date numbers or as strings, depending on your operating system.
If you end up with an excel date number, then if you have the Finance toolbox you can use https://www.mathworks.com/help/finance/x2mdate.html
If you do not have that toolbox, then you can add datenum() of Dec 31 1899 to the date. But you have to be careful; see https://www.mathworks.com/matlabcentral/answers/254-converting-excel-serial-number-of-time-to-hh-mm-ss-format#answer_353
0 Kommentare
Hamza Ali
am 16 Jan. 2017
3 Kommentare
per isakson
am 17 Jan. 2017
Bearbeitet: per isakson
am 17 Jan. 2017
"However, I get only one column that the numeric values, but the one containing the date is unrecoverable."   I guess, your problem is related to the difference between the default reference dates of Excel and Matlab.
MATLAB serial date number January 0, 0000
Excel for Windows January 1, 1900
Excel for the Macintosh January 2, 1904
Walter Roberson
am 17 Jan. 2017
It is worse than that, Excel for Windows thinks Feb 29 1900 was a leap year but it was not, so the adjustment depends on whether your dates refer to dates after Feb 28 1900.
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!