Average of 5 locations for each time

1 次查看（过去 30 天）
FIONA HOTCHKISS
FIONA HOTCHKISS 2021-12-9
评论： Star Strider 2021-12-9
%Point Barrow, Alaska
PB=readtable('monthly_flask_co2_ptb.csv');
%create time and CO2 variable
%time
PBdailyt=PB(:,4);
%CO2
PBdailyCO2=PB(:,7);
%take data out of table and put into array
PBt=table2array(PBdailyt);
PBCO2=table2array(PBdailyCO2);
%index to extract outliers
idx = PBCO2 >=500 | PBCO2 <=300 ;
%set outliers equal to NaN
PBCO2(idx) = NaN;
I have 5 different locations, above I have included one of them. I am trying to calcuate the average of all 5 locations to plot against time. My goal is to have the 5 locations combined and plotted against time, and then to extrapolate it.

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

回答（1 个）

Star Strider
Star Strider 2021-12-9
This is all a bit arcane. See if the movmean function will produce the desired result.
.
  1 个评论
Star Strider
Star Strider 2021-12-9
Ran in:
Try this —
T1 = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/828030/monthly_flask_co2_ptb.csv', 'VariableNamingRule','preserve', 'HeaderLines',56)
T1 = 552×10 table
Var1 Var2 Excel Var4 [ppm] [ppm]_1 [ppm]_2 [ppm]_3 [ppm]_4 [ppm]_5 ____ ____ _____ ______ ______ _______ _______ _______ _______ _______ 1974 1 27044 1974 336.15 332.46 336.24 332.54 336.15 332.46 1974 2 27075 1974.1 -99.99 -99.99 336.8 332.57 336.8 332.57 1974 3 27103 1974.2 337.16 332.71 337.05 332.6 337.16 332.71 1974 4 27134 1974.3 336.37 332.05 336.95 332.63 336.37 332.05 1974 5 27164 1974.4 336.99 332.35 337.31 332.66 336.99 332.35 1974 6 27195 1974.5 336.42 334.01 335.01 332.69 336.42 334.01 1974 7 27225 1974.5 330.8 335.4 327.99 332.72 330.8 335.4 1974 8 27256 1974.6 323.1 333.02 322.8 332.74 323.1 333.02 1974 9 27287 1974.7 323.96 331.96 324.84 332.77 323.96 331.96 1974 10 27317 1974.8 327.82 331.36 329.33 332.8 327.82 331.36 1974 11 27348 1974.9 332.55 332.45 332.99 332.84 332.55 332.45 1974 12 27378 1975 335.14 332.56 335.49 332.88 335.14 332.56 1975 1 27409 1975 337.14 333.43 336.65 332.92 337.14 333.43 1975 2 27440 1975.1 338.72 334.47 337.23 332.97 338.72 334.47 1975 3 27468 1975.2 336.62 332.13 337.5 333.02 336.62 332.13 1975 4 27499 1975.3 337.34 332.99 337.42 333.07 337.34 332.99
DTV = table(datetime(T1{:,1},T1{:,2},ones(size(T1{:,1}))), 'VariableNames',{'Date'});
T2 = [DTV, T1(:,5:end)]
T2 = 552×7 table
Date [ppm] [ppm]_1 [ppm]_2 [ppm]_3 [ppm]_4 [ppm]_5 ___________ ______ _______ _______ _______ _______ _______ 01-Jan-1974 336.15 332.46 336.24 332.54 336.15 332.46 01-Feb-1974 -99.99 -99.99 336.8 332.57 336.8 332.57 01-Mar-1974 337.16 332.71 337.05 332.6 337.16 332.71 01-Apr-1974 336.37 332.05 336.95 332.63 336.37 332.05 01-May-1974 336.99 332.35 337.31 332.66 336.99 332.35 01-Jun-1974 336.42 334.01 335.01 332.69 336.42 334.01 01-Jul-1974 330.8 335.4 327.99 332.72 330.8 335.4 01-Aug-1974 323.1 333.02 322.8 332.74 323.1 333.02 01-Sep-1974 323.96 331.96 324.84 332.77 323.96 331.96 01-Oct-1974 327.82 331.36 329.33 332.8 327.82 331.36 01-Nov-1974 332.55 332.45 332.99 332.84 332.55 332.45 01-Dec-1974 335.14 332.56 335.49 332.88 335.14 332.56 01-Jan-1975 337.14 333.43 336.65 332.92 337.14 333.43 01-Feb-1975 338.72 334.47 337.23 332.97 338.72 334.47 01-Mar-1975 336.62 332.13 337.5 333.02 336.62 332.13 01-Apr-1975 337.34 332.99 337.42 333.07 337.34 332.99
T2.('Site Monthly Mean') = mean(T2{:,2:end},2)
T2 = 552×8 table
Date [ppm] [ppm]_1 [ppm]_2 [ppm]_3 [ppm]_4 [ppm]_5 Site Monthly Mean ___________ ______ _______ _______ _______ _______ _______ _________________ 01-Jan-1974 336.15 332.46 336.24 332.54 336.15 332.46 334.33 01-Feb-1974 -99.99 -99.99 336.8 332.57 336.8 332.57 189.79 01-Mar-1974 337.16 332.71 337.05 332.6 337.16 332.71 334.9 01-Apr-1974 336.37 332.05 336.95 332.63 336.37 332.05 334.4 01-May-1974 336.99 332.35 337.31 332.66 336.99 332.35 334.78 01-Jun-1974 336.42 334.01 335.01 332.69 336.42 334.01 334.76 01-Jul-1974 330.8 335.4 327.99 332.72 330.8 335.4 332.19 01-Aug-1974 323.1 333.02 322.8 332.74 323.1 333.02 327.96 01-Sep-1974 323.96 331.96 324.84 332.77 323.96 331.96 328.24 01-Oct-1974 327.82 331.36 329.33 332.8 327.82 331.36 330.08 01-Nov-1974 332.55 332.45 332.99 332.84 332.55 332.45 332.64 01-Dec-1974 335.14 332.56 335.49 332.88 335.14 332.56 333.96 01-Jan-1975 337.14 333.43 336.65 332.92 337.14 333.43 335.12 01-Feb-1975 338.72 334.47 337.23 332.97 338.72 334.47 336.1 01-Mar-1975 336.62 332.13 337.5 333.02 336.62 332.13 334.67 01-Apr-1975 337.34 332.99 337.42 333.07 337.34 332.99 335.19
Please be specific about what the desired result is, if this is not the desired result.
.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Preprocessing 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by