CODEWITHSUNDEEP
csvoctave
Shreya
Shreya

Reputation: 151

Reading Date from CSV file in Octave

I want to read a CSV file in Octave which has a date column and 4 columns which are integers. I have used.

[num,txt,raw] = dlmread('Mitteilungen_data.csv');
ID = num(:,1) ;
DATE = datestr (date, yyyy-mm-dd) ;
FK_OBSERVERS= num(:,2) ;
GROUPS = num(:,3) ;
SUNSPOTS = num(:,4) ;
WOLF = num(:,5) ;
dn=datenum(DATE,'YYYY-MM-DD');
plot(dn,WOLF)

Sample Data:

ID  DATE     FK_OBSERVERS GROUPS SUNSPOTS   WOLF

4939    1612-01-17  11  5   11  61
83855   1612-01-18  85  2   2   22
4940    1612-01-20  11  4   5   45
4941    1612-01-21  11  4   7   47
4942    1612-01-23  11  3   5   35
4943    1612-01-24  11  3   6   36
4944    1612-01-25  11  6   13  73
4945    1612-01-27  11  3   6   36
83856   1612-01-28  85  NULL    NULL    NULL
4946    1612-01-29  11  3   6   36
4947    1612-01-30  11  4   8   48
4948    1612-02-02  11  5   8   58
4949    1612-02-05  11  4   7   47
4950    1612-02-06  11  3   7   37
4951    1612-02-10  11  5   7   57
4952    1612-02-12  11  3   4   34
4953    1612-02-13  11  2   2   22
4954    1612-02-14  11  3   3   33

The Date column is showing an error: element number 2 undefined in return list. How can I fix this?

Upvotes: 1

Views: 3762

Answers (1)

Tasos Papastylianou
Tasos Papastylianou

Reputation: 22245

You are using

[num, txt, raw] = dlmread( %...

but dlmread does not return three outputs. Type help dlmread in your console to see the syntax.

What does seem to return these three arguments is the xlsread command. Perhaps you copied code that used xlsread?

However, even so, I would still use csv2cell. Type csv2cell('data.csv') (where data.csv is the name of your file) to see what kind of output it gives

Before you can use any of the commands defined in the io package, you need to load it on your workspace.

pkg load io

Upvotes: 1

Related Questions