The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Converting from XYZ data sheet to sparse matrix
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

ssv68

Spain
Posts

Posted - 07/07/2005 :  04:49:07 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version (Select Help-->About Origin): 7.0
Operating System: WinXP

Hi everybody!
I have a data (Z) depending on two parameters (X,Y).
X and Y are the same length, but not uniform!
Another words, steps by X and Y are different and not regular.
I need to represent this data in 2D plot Z(X,Y).
I have tried the option "Convert to matrix -> Random XYZ", but Origin fills ALL fields in matrix, equating these fields to some data from Z!! But I need the sparse matrix to show direct evolution of Z in (X,Y).
Who has ideas?

Thanks in advance

Leo_Li

China
Posts

Posted - 07/07/2005 :  04:58:48 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Try this:
When Z column is highlighted, select menu: Edit -> Convert to Matrix -> Sparse XYZ.
Go to Top of Page

ssv68

Spain
Posts

Posted - 07/07/2005 :  09:26:13 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:

Try this:
When Z column is highlighted, select menu: Edit -> Convert to Matrix -> Sparse XYZ.


I did it already. Origin hangs the message "Incompatible values." The reason - Sparse matrix can be created only for uniform X,Y
Go to Top of Page

easwar

USA
1965 Posts

Posted - 07/07/2005 :  09:46:13 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi ssv68,

The Sparse conversion method works only for datasets where X, Y are regularly spaced, but not all possible X,Y pairs are present. Then the resulting matrix will have missing values for Z for all missing X,Y pairs.

In your case the X, Y values are not regularly spaced and so you need to use one of the Random XYZ conversion methods. These methods take the irregular data and perform grid computation to generate regularly spaced X, Y values and find the corresponding Z values from the grid computation. The original X, Y, Z values in your raw data therefore will not be present in the gridded result.

Easwar
OriginLab

Go to Top of Page

ssv68

Spain
Posts

Posted - 07/11/2005 :  12:43:37 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thaks all for replies!!

Really I have found more simple solution for representation such data.
Just mark Z data as Y, than plot (XYY) as 'Color Mapped'.
One has evolution of Z in X,Y shown as color symbols, and color of symbols changes according to Z scale.
Thats it!
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000