Export time series data as csv

101 views (last 30 days)
Ross Thompson
Ross Thompson on 4 May 2021
Commented: Ross Thompson on 4 May 2021
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.

Answers (2)

EmirBeg
EmirBeg on 4 May 2021
data = [timestamps movavgval]; %or however your arrays are called
writematrix(data,'data.csv');
  2 Comments
Ross Thompson
Ross Thompson on 4 May 2021
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
Ross Thompson on 4 May 2021
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

Sign in to comment.


KSSV
KSSV on 4 May 2021
Read about writetable

Community Treasure Hunt

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

Start Hunting!