Error: "index in position 2 exceeds array bounds"

2 vues (au cours des 30 derniers jours)
Matthew Warrener
Matthew Warrener le 1 Août 2020
I am trying to set up a basic loop for importing/processing csv files. When I run my code I get the error "index in position 2 exceeds array bounds". Can anyone tell me why this is happening?
clear all
%Insert Loop
for i=1:2
%Set file to load
if i==1
filename = 'DOaerationJuly.csv';
end
if i==2
filename = 'DOoutfallJuly.csv';
end
%Load data
delimiterIn = ',';
headerlinesIn = 1;
DOdata = importdata(filename,delimiterIn,headerlinesIn);
%Name Variables: Distance, Time, [DO]
Time = DOdata.data(:,1);
DO = DOdata.data(:,2);
Temp = DOdata.data(:,3)
plot(Time,Temp)
end
  2 commentaires
KALYAN ACHARJYA
KALYAN ACHARJYA le 1 Août 2020
Modifié(e) : KALYAN ACHARJYA le 1 Août 2020
Please attach mentioned files.
Matthew Warrener
Matthew Warrener le 1 Août 2020
Thank you for responding, please see attached. These were origially acquired as html files and converted to csv files.

Connectez-vous pour commenter.

Réponses (2)

KALYAN ACHARJYA
KALYAN ACHARJYA le 1 Août 2020
Modifié(e) : KALYAN ACHARJYA le 1 Août 2020
Temp = DOdata.data(:,3)
DOdata.data have only 2 columns, you are trying to access 3rd column.
  1 commentaire
Matthew Warrener
Matthew Warrener le 1 Août 2020
Thank you, can you tell me how to add a column to this? I figured it would add one by default since my imported data has three columns.

Connectez-vous pour commenter.


Walter Roberson
Walter Roberson le 1 Août 2020
Use readtable() instead of importdata()
The difficulty you are encountering is that the first column is not considered numeric, and so is not being returned as .data by importdata(), so the .data that importdata() returns has column 1 corresponding to DO and column 2 corresponding to Temp . If you use readtable() for a version within the last few years, then it will automatically detect and convert the time to datetime() and will return a total of three columns.

Catégories

En savoir plus sur Loops and Conditional Statements dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by