How to save data in csv format as output data?

13 vues (au cours des 30 derniers jours)
vimal kumar chawda
vimal kumar chawda le 29 Juin 2022
Commenté : Star Strider le 29 Juin 2022
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')

Réponses (2)

KSSV
KSSV le 29 Juin 2022
Read about writetable, csvwrite
  1 commentaire
vimal kumar chawda
vimal kumar chawda le 29 Juin 2022
Sorry, I can read but I want as output. So hope you might know what is the issue with the script.
Can you please read the question again not improt but its all about output?

Connectez-vous pour commenter.


Star Strider
Star Strider le 29 Juin 2022
That is not the appropriate way to do the conversion.
See my Answer to your previous post.
  2 commentaires
vimal kumar chawda
vimal kumar chawda le 29 Juin 2022
Not working as I have mention in the image.
Star Strider
Star Strider le 29 Juin 2022
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.)

Connectez-vous pour commenter.

Catégories

En savoir plus sur Data Type Conversion dans Help Center et File Exchange

Produits


Version

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by