Analysis error with input timetables
显示 更早的评论
Why I am getting error:
Error using timetable/retime
All variables in input timetables must be numeric, datetime, or duration when synchronizing using 'mean'.
Error in ko - 1h avg to new channel (line 10)
avgdata=retime(data,'regular','mean','TimeStep',hours(hourz));
DATA EXPORT CSV LOOKS LIKE:
2023-01-21T23:47:13+02:00 45161 533 23.187 29.27 18.23 18.61 -8.5 93 -10
CODE ko - 1h avg:
dayz=1;
hourz=1;
rc=1234;
rk='KEY';
wc=5678;
wk='KEY';
data=thingSpeakRead(rc,'ReadKey',rk,'OutputFormat','timetable','numDays',dayz);
avgdata=retime(data,'regular','mean','TimeStep',hours(hourz));
thingSpeakWrite(wc,avgdata,'WriteKey',wk);
3 个评论
Christopher Stapels
2023-1-22
Perhaps look at the datetime. MATLAB might not know the format if you arent telling it.
try
datetime('2023-01-21T23:47:13+02:00')
and see if you get a date time object back. I think you will have to reformat that column in your data and tell MATLAB the format you are using.
Walter Roberson
2023-1-22
编辑：Walter Roberson
2023-1-28
The T is the main problem. The default formats do not support the time zone offset field but you can specify XXX as an input format to code for that. There is no direct code for the T however. You have to code 'T' for that where the apostrophes are part of the syntax. For example "uuuu-MM-dd'T'HH:mm:ssxxx"
Notice the use of " to make it easier to code the literal ' characters
回答（0 个）
社区
更多回答在 ThingSpeak Community
类别
在 帮助中心 和 File Exchange 中查找有关 Time Series Collections 的更多信息
2023-1-29
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
