Error using datenum (line 201) DATENUM failed.
1 view (last 30 days)
Show older comments
Help me!
I have this error, and I don't know why.
Error using datenum (line 201)
DATENUM failed.
Caused by:
Error using dtstr2dtnummx
Failed to convert from text to date number.
My script is this:
[ndata, text, alldata]=xlsread('positive_read_Copia.xlsx'); % inside there are data (dd/mm/yyyy hh:mm:ss) and coordinates
date=date.';
tmp=char(date);
tmp_date=datenum(tmp,'dd/mm/yyyy HH:MM');
DateVector = datevec(tmp_date);
Date_minute=(tmp_date-tmp_date(1))*24*60; % Time, in minutes compared to the 1st georeferenced tweet
clear tmp;
2 Comments
Cris LaPierre
on 18 Nov 2021
Please share your spreadsheet. You can attach it using the paperclip icon.
Answers (1)
Stephen23
on 18 Nov 2021
Edited: Stephen23
on 18 Nov 2021
Do not use outdated, discouraged, deprecated DATENUM (or for that matter DATEVEC or DATESTR).
Import your data using READTABLE, which automatically identifies the dates and imports them as DATETIME objects:
T = readtable('positive_read_Copia.xlsx')
D = T.tweet_created_at - T.tweet_created_at(1)
M = minutes(D)
4 Comments
Sean de Wolski
on 18 Nov 2021
You'll also want to look at https://www.mathworks.com/help/releases/R2021b/stats/dbscan.html and either geobubble or geoplot https://www.mathworks.com/help/releases/R2021b/matlab/ref/geoplot.html.
See Also
Categories
Find more on Time Series Objects in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!