Transpose textwave (table)

Share icon

To be able to get a nice figure, I need a table. I already have the data for the table (significance levels of p-values) but I need to transpose the textwave-table.

actually I have:

wave0 wave1 wave2
ROI1 * **
ROI2 n.s. ***
ROI3 ** *
ROI4 * n.s.

and want to have:

wave3 ROI1 ROI2 ROI 3 ROI4
wave4 * n.s. ** *
wave5 ** *** * n.s.


There is a solution by johnweeks for non-textwaves (http://www.igorexchange.com/node/1779#comment-5406), which helped me very much. I tried to adapt the code but it doesn't seem to be that easy.

If someone could tell me how to make a plot whick looks like that, it would also be fine.

(btw: how can I make tabs? multiple space are ignored in the post..)

Thanks in advance
Here it is. But I'm a bit concerned as I think about this- presumably your p values are numbers. Are they really in a text wave? My revision posted here will handle either numeric or text, but not both at the same time.

The posted file is zipped- you must uncompress it before you can use it.

To use the unpacked file, in Igor choose Help->Show Igor Pro Folder. In the resulting Finder or Explorer window, go into the folder WaveMetrics Procedures:Data Manipulation and find the original Transpose Waves In Table.ipf and move it someplace safe (just in case I broke something). Put the new, uncompressed file in Data Manipulation in place of the old one.

John Weeks
WaveMetrics, Inc.
support@wavemetrics.com
Transpose Waves In Table.ipf.zip (3.23 KB)

July 23, 2012 at 01:02 pm - Permalink

johnweeks wrote:
You're right- converting Transpose Waves in Table to work with text waves is not trivial ...


Would it be easier to export the table, run the file through an appropriate OS batch script, and reimport the data?

http://www.unix.com/shell-programming-scripting/18897-row-column-transp…
http://www.computing.net/answers/programming/batch-transpose-a-matrix/1…

--
J. J. Weimer
Chemistry / Chemical & Materials Engineering, UAHuntsville

July 23, 2012 at 01:47 pm - Permalink

johnweeks wrote:
Here it is. But I'm a bit concerned as I think about this- presumably your p values are numbers. Are they really in a text wave? My revision posted here will handle either numeric or text, but not both at the same time.

The posted file is zipped- you must uncompress it before you can use it.

To use the unpacked file, in Igor choose Help->Show Igor Pro Folder. In the resulting Finder or Explorer window, go into the folder WaveMetrics Procedures:Data Manipulation and find the original Transpose Waves In Table.ipf and move it someplace safe (just in case I broke something). Put the new, uncompressed file in Data Manipulation in place of the old one.

John Weeks
WaveMetrics, Inc.
support@wavemetrics.com


This works really good - Thank you!
I will tell you if I find some bugs.


@jjweimer: The idea is not bad but currently I am working with windows 7 and its not that easy for me to do this batch stuff here, like it is on linux. If I get the whole analysis solved in IGOR, it is easier to give it to collegues without many explanations. Thanks anyway.

July 24, 2012 at 01:29 am - Permalink