Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
Posted - 06/01/2022 : 04:28:37 AM Hi, I am trying to use Origin to display the data I measured in a column plot. I want to merge some channels of my ADC measurement (meaning that I want to add up the values for a certain number of channels and display them as one column). How can I do that? I also uploaded the data.
Origin Ver. and Service Release: 220.127.116.11 Operating System: Windows 10
8 L A T E S T R E P L I E S (Newest First)
Posted - 06/23/2022 : 4:49:58 PM Hello,
We just released Origin 2022b sr1 which will auto convert , to ; for this case so u don't need to manually change it to ;
Posted - 06/03/2022 : 11:56:58 AM That works! Thank you very much!
Posted - 06/03/2022 : 11:43:43 AM use ; instead,
Looks like your PC is using "," as decimal separator. The Python or Labtalk part will still use comma, but the formula part we need to allow for comma as decimal so must use ; to separator function arguments.
Posted - 06/03/2022 : 04:30:38 AM Hi, thank you very much for your help. I tried using your code but my results are different. It just puts a -- in every cell. What could be the reason for that? In addition Origin changes the , in py.group_sum(A, 5) to a . (py.group_sum(A. 5)) when I close the window and reopen it. Could that be connected?
Posted - 06/02/2022 : 4:26:11 PM You can use Python function in Origin to calculate group sum in col(B). See below:
I found that tool but I couldn't get it to do what I want.
I basically want to have sum of the first 5 values of the data in the first cell, the sum of the second 5 values in the second cell and so on. In the data provided that would work out to 0 0 0 0 0 0 1 1 8 12 and so on.
But not with only with 5 but with an odd variable x. Then I can calculate the middle of each data point with: z = (x+1)/2 + (y-1) * x with y as the current cell.
So then the sum needs to reach from z-(x+1)/2 to z+(x+1)/2.
I also found the total function for calculating a sum, but I total(B[z-(x+1)/2 : z+(x+1)/2]) (with the data in Column B) didn't seem to work.
Edit: Changed column to cell
Posted - 06/02/2022 : 01:55:30 AM Hi RaphBilder,
We didn't see any data in this post. Please upload it again and give us the download link.