Export time series data as csv

117 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

Categories

Find more on Creating and Concatenating Matrices in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!