How do you perform moving average with given data?

2 views (last 30 days)
I was given a csv file to download and I used this code below to read it.
clear;
fclose all;
fileID = fopen('accidents_2017.csv');
text1 = textscan(fileID,'%s%s%s%s%s%s%d%d%s%d%d%d%d%f%f','HeaderLines',1,'Delimiter',{','},'EmptyValue',NaN);
fclose(fileID);
I also used str2double(text1) to change all the strings to numbers.
I was asked to perform the moving average of the data and then plot it. How do i do so? Is there a function to do so with lots of data points?
  2 Comments
Walter Roberson
Walter Roberson on 22 Feb 2021
Your text1 would be a cell array of arrays, not a cell array of character vectors. str2double only works on character vectors or cell array of character vectors, or string objects. You would need to extract parts of text1 such as str2double(text1{1})
But what is the purpose of reading with a %s format and then str2double when you could just use a %f format directly?
Sarah Mullin
Sarah Mullin on 22 Feb 2021
Thats how my teacher told us to do it when we used textscan. He then asked us to do the following in order:
Download the dataset, Use "textscan" to read in data, Convert data into numbers, Count how many "NaN"s, Remove the "NaN"s, plot the data, De-trend and re-plot the data, and Perform moving average and replot the data.

Sign in to comment.

Accepted Answer

Image Analyst
Image Analyst on 22 Feb 2021
Try readmatrix()
data = readmatrix(filename);
data(isnan(data)) = [];

More Answers (0)

Community Treasure Hunt

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

Start Hunting!