Combine non integer time steps into daily values
Dear Experts,
I have the following data, which have time and volume (.mat file attached).
time (Days) Volume (L)
0 0
30.6741806 0
1.168E-05 0.006798073
2.2995E-05 0.047292948
4.4165E-05 0.223091253
7.7015E-05 0.833100076
9.636E-05 2.066383935
0.00012045 4.343111658
0.000150745 8.336749383
0.000187975 14.55932459
0.000289445 22.84538025
0.00036135 32.30381193
Unfortunately, the time steps are not consistent, and I would like to group them into values of one day. As volume is linked to those time steps, I can not add the time steps, as they don’t sum 1.
With some effort in Excel I could group the values, with their respective proportional volume:
time (Days) Volume (L)
0.97022767 70827.51996
0.02977233 1854.371465
0.07209406 4490.383105
0.889726556 1.41894918
0.038179384 2757.485994
0.139366106 10065.64395
If I sum the bold and underlined ones, I get tha volume values for 1 day (integer)
time (Days) Volume (L)
1 72681.89142
1 7249.288049
0.139366106 10065.64395
As there are so many values (more than 900), Is it possible to do it on a propper way in MATLAB?
Thank you!Dear Experts,
I have the following data, which have time and volume (.mat file attached).
time (Days) Volume (L)
0 0
30.6741806 0
1.168E-05 0.006798073
2.2995E-05 0.047292948
4.4165E-05 0.223091253
7.7015E-05 0.833100076
9.636E-05 2.066383935
0.00012045 4.343111658
0.000150745 8.336749383
0.000187975 14.55932459
0.000289445 22.84538025
0.00036135 32.30381193
Unfortunately, the time steps are not consistent, and I would like to group them into values of one day. As volume is linked to those time steps, I can not add the time steps, as they don’t sum 1.
With some effort in Excel I could group the values, with their respective proportional volume:
time (Days) Volume (L)
0.97022767 70827.51996
0.02977233 1854.371465
0.07209406 4490.383105
0.889726556 1.41894918
0.038179384 2757.485994
0.139366106 10065.64395
If I sum the bold and underlined ones, I get tha volume values for 1 day (integer)
time (Days) Volume (L)
1 72681.89142
1 7249.288049
0.139366106 10065.64395
As there are so many values (more than 900), Is it possible to do it on a propper way in MATLAB?
Thank you! Dear Experts,
I have the following data, which have time and volume (.mat file attached).
time (Days) Volume (L)
0 0
30.6741806 0
1.168E-05 0.006798073
2.2995E-05 0.047292948
4.4165E-05 0.223091253
7.7015E-05 0.833100076
9.636E-05 2.066383935
0.00012045 4.343111658
0.000150745 8.336749383
0.000187975 14.55932459
0.000289445 22.84538025
0.00036135 32.30381193
Unfortunately, the time steps are not consistent, and I would like to group them into values of one day. As volume is linked to those time steps, I can not add the time steps, as they don’t sum 1.
With some effort in Excel I could group the values, with their respective proportional volume:
time (Days) Volume (L)
0.97022767 70827.51996
0.02977233 1854.371465
0.07209406 4490.383105
0.889726556 1.41894918
0.038179384 2757.485994
0.139366106 10065.64395
If I sum the bold and underlined ones, I get tha volume values for 1 day (integer)
time (Days) Volume (L)
1 72681.89142
1 7249.288049
0.139366106 10065.64395
As there are so many values (more than 900), Is it possible to do it on a propper way in MATLAB?
Thank you! sort timesteps MATLAB Answers — New Questions