| Author |
 Topic  |
|
|
JuLCAR
5 Posts |
 Posted - 11/26/2019 : 09:38:36 AM
|
Hi,
I would like to extract data from a heat map. Something like the "worksheet query" but for matrix. Is it possible ? I would like it to be recalculate if I change datas.
Thank you very much!
|
|
|
YimingChen
1669 Posts |
Posted - 11/26/2019 : 10:27:25 AM
|
Hi,
You can convert the matrix to worksheet(Matrix->Convert to Worksheet), run worksheet query and convert the result back to matrix. Set the recalculation mode in each tool dialog to Auto that any change in the initial matrix will trigger the recalculation and update the result.
Thank you
James |
 |
|
|
JuLCAR
5 Posts |
Posted - 11/26/2019 : 10:37:44 AM
|
quote:
Originally posted by YimingChen
Hi,
You can convert the matrix to worksheet(Matrix->Convert to Worksheet), run worksheet query and convert the result back to matrix. Set the recalculation mode in each tool dialog to Auto that any change in the initial matrix will trigger the recalculation and update the result.
Thank you
James
Yes I found this solution just after posting the question ! This should get the job done. Actually, I would like to select an area in my heat map, but not a squared one, an area I circle by hand on the map and extract the data from this area but I don't think it is possible with Origin. |
|
|
|
YimingChen
1669 Posts |
Posted - 11/26/2019 : 2:16:57 PM
|
No, Origin doesn't support selecting data from heatmap. This may not help you but if you have XYZ data plotted as contour plot, you can use data highlighter to extract data. But data highlighter doesn't work for plot generated from matrix. Thanks.
James |
|
|
|
JuLCAR
5 Posts |
Posted - 11/27/2019 : 10:24:08 AM
|
Thank you for your help James but I can't find the highlighter tool on my Origin (Origin Pro 2018). It should be with the data reader one but there is only data cursor. Anyway, I found a trick : I just apply a rotation of pi/4 to my datas so that the areas I want to extract now correspond to rectangles and I can use a worksheet query or a filter. (Only works if the area of interest is initially a rotated rectangle...)
quote:
Originally posted by YimingChen
No, Origin doesn't support selecting data from heatmap. This may not help you but if you have XYZ data plotted as contour plot, you can use data highlighter to extract data. But data highlighter doesn't work for plot generated from matrix. Thanks.
James
|
|
|
|
YimingChen
1669 Posts |
Posted - 11/27/2019 : 1:31:13 PM
|
Data highlighter is introduced in Origin 2019. Thanks.
James |
|
|
|
minimax
360 Posts |
Posted - 11/28/2019 : 04:14:19 AM
|
Hi JuLCAR,
If your heatmap data is from matrix window, you may take a look at following unsatisfactory workaround?
1. Activate matrix window, select View - Image Mode.
2. Click the green rectangle toolbar to draw a rectangle on the matrix.
3. Move the rect to the desirable region, right click to select "Create New".
--> It will extract the data.
Is it OK?
Of course it does not support circle etc. shape yet.
And do you need circle only, or some irregular shape?
PS1: There is an App "Plot Sub Matrix":
https://www.originlab.com/FileExchange/details.aspx?fid=228
You may also try it.
PS2: It is appreciated that you can send to tech@originlab.com some sample project (with the "rotated rect") so that we can take a further check? |
|
|
|
JuLCAR
5 Posts |
Posted - 11/28/2019 : 09:20:54 AM
|
quote:
Originally posted by minimax
Hi JuLCAR,
If your heatmap data is from matrix window, you may take a look at following unsatisfactory workaround?
1. Activate matrix window, select View - Image Mode.
2. Click the green rectangle toolbar to draw a rectangle on the matrix.
3. Move the rect to the desirable region, right click to select "Create New".
--> It will extract the data.
Is it OK?
Of course it does not support circle etc. shape yet.
And do you need circle only, or some irregular shape?
PS1: There is an App "Plot Sub Matrix":
https://www.originlab.com/FileExchange/details.aspx?fid=228
You may also try it.
PS2: It is appreciated that you can send to tech@originlab.com some sample project (with the "rotated rect") so that we can take a further check?
Thank you minimax, the solution with Image Mode is interesting and usefull but it only does "straight" rectangles. I am able to rotate the rectangle to select an area of interest but the matrix created from this rotated selection is a "straight" rectangle wich include my rotated selection...
I send an image of my heat map, with the two area I want to extract (basicaly, I want the total intensity in those areas).
Thank you again for helping
 |
|
|
|
lkb0221
China
497 Posts |
Posted - 12/05/2019 : 10:59:06 AM
|
| Maybe you can try contour/image profile with an arbitrary profiling line. Set the width and Sum mode, then after getting the profile, cut of the head and tail. |
|
|
| |
Topic |
|
Extract data from heat map