MATLAB Answers

Read string data (date & time) from CSV file

258 views (last 30 days)
amit dhoke
amit dhoke on 6 Aug 2015
Commented: Peter Perkins on 28 Feb 2017
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.

Answers (3)

Azzi Abdelmalek
Azzi Abdelmalek on 6 Aug 2015
Edited: Walter Roberson on 7 Aug 2015
Use
[a,b,c]=xlsread('NovDay.csv')
  2 Comments
Azzi Abdelmalek
Azzi Abdelmalek on 7 Aug 2015
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')

Sign in to comment.


Walter Roberson
Walter Roberson on 6 Aug 2015
Use xlsread(). Or textscan(). csvread() can only read numeric fields.

Mehran Mustafa
Mehran Mustafa on 28 Feb 2017
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?
  2 Comments
Peter Perkins
Peter Perkins on 28 Feb 2017
As Walter says, if possible, use readtable. Even prior to R2016b, back to R2013b, it's usually the best choice.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!