How do you perform moving average with given data?

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?

[Walter Roberson]

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]

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.

Answer 1

[Image Analyst]

Try readmatrix()

data = readmatrix(filename);
data(isnan(data)) = [];