Error: "index in position 2 exceeds array bounds"

1 view (last 30 days)
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 Comments
KALYAN ACHARJYA
KALYAN ACHARJYA on 1 Aug 2020
Edited: KALYAN ACHARJYA on 1 Aug 2020
Please attach mentioned files.
Matthew Warrener
Matthew Warrener on 1 Aug 2020
Thank you for responding, please see attached. These were origially acquired as html files and converted to csv files.

Sign in to comment.

Answers (2)

KALYAN ACHARJYA
KALYAN ACHARJYA on 1 Aug 2020
Edited: KALYAN ACHARJYA on 1 Aug 2020
Temp = DOdata.data(:,3)
DOdata.data have only 2 columns, you are trying to access 3rd column.
  1 Comment
Matthew Warrener
Matthew Warrener on 1 Aug 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.

Sign in to comment.


Walter Roberson
Walter Roberson on 1 Aug 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.

Community Treasure Hunt

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

Start Hunting!