3 Dimension wave from multiple files
Anonymous
Wed, 01/30/2013 - 07:40 am
I have approximately 89 csv files that I would like to import into Igor as a 3 component wave. Each file has x and y components, and I would like each one to be the third component. My ultimate goal is to make a series of image plots from the data, but I will also extract graphs from the data. Any ideas, other than inputing each of the files by copy and pasting? Thanks.
Since you want to make a 3D plot, I am going to assume the x-waves for each csv file are the same (things will get ugly if not).
Make a 2D wave with dimensions equal to the number of files and the number of x points (say 89 x 400, or however many x values you have). Scale the larger dimension so it's values are that of the x-wave in your csv files. Now simply paste the Y values into the matrix.
You can scale the second dimension as well, if the 89 csv files represent some changing measurement parameter (lets say temperature for a simplistic example).
So you'll end up with 89 rows by X columns (where X is the number of points in your XY data sets) and the 2D matrix will be filled by the Y values from your CSV files.
Making a Triplet wave is also possible, but I find a 2D matrix easier to work with.
January 30, 2013 at 08:06 am - Permalink
A.G.
WaveMetrics, Inc.
January 30, 2013 at 09:41 am - Permalink
January 30, 2013 at 10:35 am - Permalink
You would need to use XLLoadWave with the appropriate parameters instead of LoadWave. To determine the appropriate XLLoadWave parameters, first determine the cells you want to load (e.g., C3 through J10) and then choose Data->Load Waves->Load Excel File.
If you get stuck, post a sample file with an explanation of what you want to load from it.
January 30, 2013 at 12:08 pm - Permalink