Read string data (date & time) from CSV file

I have a following data into the'NovDay.csv' file

datetime     airtemp insolation  windspeed winddirection  power (W) energy (Wh)
5/01/2015 5:00  20.3  3.3  1.5  208  0  0
5/01/2015 5:01  20.3  5  2.6  191  0  0
5/01/2015 5:02  20.3  6.5  1.8  166  0  0
5/01/2015 5:03  20.3  7.9  2  225  0  0
5/01/2015 5:04  20.3  7.9  1.1  198  0  0
5/01/2015 5:05  20.3  11.1  2  211  0  0
5/01/2015 5:06  20.3  15.6  1.8  199  0  0
5/01/2015 5:07  20.3  17.7  1.8  189  84  1

I am using the below command to read the csv file

Nov=csvread('NovDay.csv',2,1);

but I am getting only the below data

20.3000000000000 5 2.60000000000000 191 0 0
20.3000000000000 6.50000000000000 1.80000000000000 166 0 0
20.3000000000000 7.90000000000000 2 225 0 0
20.3000000000000 7.90000000000000 1.10000000000000 198 0 0
20.3000000000000 11.1000000000000 2 211 0 0
20.3000000000000 15.6000000000000 1.80000000000000 199 0 0
20.3000000000000 17.7000000000000 1.80000000000000 189 84 1

here the date and time is missing.

I want to read the date and time data.

[Mohammad Ali Miri]

use readtable()

Answer 1

[Azzi Abdelmalek]

Use

[a,b,c]=xlsread('NovDay.csv')

[amit dhoke]

Thanks Azzi I tried to use this command, it separating string and number in a,b,c. But I have to plot the time from this array with my results. If you could explain me, how to separate date and time from first coulumn and then read that time into an array. Then it can be easy to plot that time against any results.

[Azzi Abdelmalek]

Suppose the first column looks like:

c1={'01/01/2015 00:00:00';'02/01/2015 00:20:10';'03/01/2015 12:00:02'}
s=datenum(c1,'dd/mm/yyyy HH:MM:SS')
date=datestr(s,'dd/mm/yyyy'),
time=datestr(s,'HH:MM:SS')

Answer 2

[Walter Roberson]

Use xlsread(). Or textscan(). csvread() can only read numeric fields.

Answer 3

[Mehran Mustafa]

Hello

I have date, time and wind speed data in three columns. The data is 1 min average. I want to convert it to hourly average by using a loop. How do I read the date and time and then use is in for loop?

[Walter Roberson]

If you have a new enough MATLAB, you can read the data using readtable() and convert the resulting table() object to a timetable() object which then has direct functions to group by time.

Otherwise, the easiest way to read the date and time depends on which MATLAB release you have?

[Peter Perkins]

As Walter says, if possible, use readtable. Even prior to R2016b, back to R2013b, it's usually the best choice.