How to save data in csv format as output data?
28 次查看(过去 30 天)
显示 更早的评论
clc;
close all;
clear all;
num = xlsread("SensorsAP_example.csv");
Split the cell into format of date
timestamp = num(:,3);
date.days = floor(timestamp/(10^6));
date.hours = floor(mod(timestamp,10^6)/(10^4));
date.mins = floor(mod(timestamp,10^4)/(10^2));
date.secs = mod(timestamp,10^2);
save('data.csv','date')
0 个评论
回答(2 个)
Star Strider
2022-6-29
That is not the appropriate way to do the conversion.
2 个评论
Star Strider
2022-6-29
What does ‘not working’ mean?
It works when I run it, producing what appears to me to be an appropriate result. As I mentioned, if the conversion routine is something different that POSIX (I experimented with Excel dates and that failed), we need to know what the conversion is.
For example, if you know the correct dates and times for at least two ‘timestamp’ values (preferably not immediately adjacent to each other), and assuming linearity, it would be possible to perform a linear regression to convert them into something meaningful, for example to MATLAB datenum values that could then be converted to datetime arrays. .
As I mentioned, 37 hour days and 61 minute hours make no sense, at least in terrestrial time. (Maybe on other planets, time is different.)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!