| T O P I C R E V I E W |
| Kassandra |
Posted - 12/03/2014 : 05:25:48 AM
Origin Ver. and Service Release (Select Help-->About Origin): Origin9.1G
Operating System: Windows
Hi everybody,
I use Origin to analyse minute data of power and massflow of a heatflow meter. Until now I have data over the last half year, that means I have more than 250000 data points for each measuring tool in one sheet.
Now I want to calculate the daily mean value of power, respectively the emitted daily heat. How can I do this? It is necessary to write a script with labtalk to sum up the values or does exist a special function, which I do not know until know? Could it be a problem, that every day some minute values are missing?
Who can give me an advice? Thanks a lot in advance! |
| 6 L A T E S T R E P L I E S (Newest First) |
| Micz14 |
Posted - 08/30/2022 : 09:02:11 AM
Thank you very much Snow, it helps me a lot
|
| snowli |
Posted - 08/29/2022 : 09:24:29 AM
Yes, you can choose Analysis: Data Manipulation: Reduce by Group...
E.g. Set the sampling interval to be 60min or 1hour
Set the hour:minute:second part of "X Start" to be whole hour.
Also set Merge X by Subgroup Beginning.
Thanks, Snow |
| Micz14 |
Posted - 08/29/2022 : 08:49:41 AM
Hi all,
Is it possible to get hourly average values from minutes values in the same way that Hideo Fujii did? |
| Kassandra |
Posted - 12/04/2014 : 10:11:30 AM
Hi,
thanks a lot for your answers. It was helpful for me.
Greetings from Kassandra |
| Hideo Fujii |
Posted - 12/03/2014 : 5:15:30 PM
Hi Kassandra,
As Zheng wrote, the internal value of the Date column is the Julian date. Therefore, the decimal part represents
within 24 hours, and taking the integer can neglects the time differences. You can do this by
Set Column Values tool easily.
Then, you can aggregate in most flexible way by script, if you have a simple data format, you can choose
"Worksheet> Remove/Combine Duplicated Rows" menu with "Average" option to get the average of each day:
The result of this sample would be:
Hope this helps.
--Hideo Fujii
OriginLab
|
| lkb0221 |
Posted - 12/03/2014 : 1:25:55 PM
Hi,
Origin uses Julian date to represent time and date data, which is a double value. So you can loop through the whole dataset, and take average on those that share the same integer part.
This needs to be done by script, I'm afraid.
Zheng
Origin |
