The Origin Forum - Clustering data from a graph

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum

Clustering data from a graph

New Topic

Reply to Topic

Printer Friendly

Author

Topic

carmi

9 Posts

Posted - 05/06/2014 : 11:02:33 AM

Origin Ver 9.0 and Service Release (Select Help-->About Origin):
Operating System:win 8.1 64 bit

Hi
I have a set of data that can be classify quite easily only by using the graph results.
My question is:
How can I color or cluster the data into 3 or more groups and having them on a different color directly from the graph?
Best

carmi

lkb0221

China
497 Posts

Posted - 05/06/2014 : 11:40:24 AM

Hi,

You can hold Ctrl to select multiple data point and then use the tool bar to set their color. The idea is to treat them as special points. But it will not label your data in worksheet for further analysis. And it will mess up your Plot Details dialog because in the end, almost all of your data points will become special points.

BTW, graph is just a visual way to represent your data, so the better way is still try to build a new column to mark data by your criteria. After that, you can set color index easily.

Zheng
OriginLab

Edited by - lkb0221 on 05/06/2014 11:40:55 AM

carmi

9 Posts

Posted - 05/06/2014 : 12:25:39 PM

Hi
First, thanks for your reply
Your suggestion is good for a little amount of data, using the ctrl means to pick them one by one.
My case is different, I have huge amount of dots, picking them like that is not practical, is there any other way?
thanks again

carmi

lkb0221

China
497 Posts

Posted - 05/06/2014 : 4:06:51 PM

Hi,

Well... Sorry but currently there is no way to do this on graph.
You might have to create a new column for color info in the worksheet data side.

We will see what we can do to improve this in the future.
I created https://originlab.jira.com/browse/ORG-11102

Zheng
OriginLab

snowli

USA
1395 Posts

Posted - 05/06/2014 : 4:49:05 PM

Since you have to classify data in graph, here is one workaround:
1. With graph window active, use the regional data selector to select each region.
2. Do Ctrl+C to copy the data in that region and go to another worksheet to paste it in. The X Y datasets will be pasted. Make sure the columns are set as X and Y respectively.
3. You can use this method to copy all regions and paste to the same worksheets. Then highlight all these XYXYXY columns and plot a new graph.

Thanks, Snow

Edited by - snowli on 05/06/2014 4:50:10 PM

Hideo Fujii

USA
1582 Posts

Posted - 05/07/2014 : 12:14:24 PM

Hi carmi,

If you are using OriginPro, you can try the following procedure to use the Cluster gadget: (Let's assume the worksheet hasA(X), B(Y), and you made a scatter plot from it.)

1) Add a column (C) for the color indexing to the worksheet.
2) Double-click the plot, and in Plot Details dialog, set the Symbol Color to Index:Col(C)
3) Using Cluster tool, mask the area of a group (as many times as you like to cover all desired regions).
  (You can press "Change Mask Color" button to choose the masking color to distinguish.)
4) Use Set Column Values tool for this new 3rd column with the formula: 
   col(2)<i>==1?<color#>:col(3)[i]  with the Recalculation Mode=None
   (See the list of colors at http://wiki.originlab.com/~originla/ltwiki/index.php?title=LabTalk:List_of_Colors )
5) Right-click the Y column, and choose "Mask>Remove" flyout to clear the mask
6) Repeat 3)-5) to cover all groups.

Hope this also helps.

--Hideo Fujii
OriginLab

Edited by - Hideo Fujii on 05/07/2014 12:14:57 PM

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000