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
[quote=johnweeks]You're right- converting Transpose Waves in Table to work with text waves is not trivial ...[/quote]

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
[quote=johnweeks]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[/quote]

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