Export time series data as csv

Question

Ross Thompson 2021-5-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/821215-export-time-series-data-as-csv

评论： Ross Thompson 2021-5-4

I have a csv with 2 columns in, the first is the timestamp (2021-02-27 12:00:00), and the 2nd is heartrates. Ive calculated a moving average of the heartrate coulmn and wish to export the moving average values along with the timestamps as a new csv. Everything uve tried doesnt seem to work so any help would be much apprecieted.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

EmirBeg 2021-5-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/821215-export-time-series-data-as-csv#answer_691510

在 MATLAB Online 中打开

data = [timestamps movavgval]; %or however your arrays are called
writematrix(data,'data.csv');

https://de.mathworks.com/help/matlab/ref/writematrix.html

2 个评论
显示无隐藏无

Ross Thompson 2021-5-4

在 MATLAB Online 中打开

I get the following error when i tried this

Error using datetime/horzcat (line 1387)
All inputs must be datetimes or date/time character vectors or date/time strings.
Error in movingaverage (line 11)
data1 = [data.Timestamp timeseriesmoving_average]

Ross Thompson 2021-5-4

在 MATLAB Online 中打开

data = readtable('2021-02-01.csv');
timeseriesmoving_average = movmean(data.HeartRate, minutes(20), 'SamplePoints', data.Timestamp);
data1 = [data.Timestamp, timeseriesmoving_average] 
writematrix(data1,'data.csv');

Heres the code i used

请先登录，再进行评论。