Author |
Topic |
|
Breadfan
14 Posts |
Posted - 05/06/2020 : 08:56:38 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): Operating System: 8.5.1, win10
Hello there, I do have a Problem regarding date related data. My data look like the following and I would like to get the mean of every day. My datasets are like 60.000 rows with nearly 100 rows for each day, but every day doesnt have the same amount of data points.
Thank you very much in advise
Time_PeriodStart VoltageMax 2016-11-30 23:36:26 4,20 2016-11-30 23:51:11 4,20 2016-12-01 00:04:11 4,18 2016-12-01 00:17:56 4,18 |
Edited by - Breadfan on 05/06/2020 10:05:57 AM |
|
YimingChen
1592 Posts |
Posted - 05/06/2020 : 10:39:54 AM
|
Hi,
One solution is to extract the date text from the date column.
Then perform Statistics on Column (menu Statistics->Descriptive Statistics-> Statistics on Columns..)with the newly created text date column as group.
If you can upgrade to latest Origin version, There is a nice app for this: https://www.originlab.com/FileExchange/details.aspx?fid=489
James
|
Edited by - YimingChen on 05/06/2020 10:41:14 AM |
|
|
YimingChen
1592 Posts |
Posted - 05/06/2020 : 4:52:27 PM
|
Hi,
Here is another method: 1. Extract the date from the first column by simply putting int(A) in F(x) column header. You need to set column type to date to show the Julian date properly.
2. Go to menu Worksheet->Remove/Combine Duplicated Rows, set col(B) as reference column and merge duplicate by average.
3. The result worksheet will show as below:
James |
Edited by - YimingChen on 05/06/2020 4:52:53 PM |
|
|
Breadfan
14 Posts |
Posted - 05/07/2020 : 3:11:37 PM
|
Thank you so much, that works perfectly for me. <3 |
|
|
|
Topic |
|
|
|