Appending Values (string and variable) to a Table

Share icon

After I have generated ratio value from lambda, I would like to append the values to a table for category plotting. I found a similar thread in IgorExchange, and
I successfully added the code into mine, but I would like to also add a text column corresponding to the value. How do I add another column to the table? If there is a better way to perform category plotting from the graph without use of table, the suggestion is also welcomed.
(currently, I used the function print to display the value of "tracename" and "ratioValue", then perform copy-past function to the table for category plotting. )


Menu "Ratiometric",dynamic
	TraceNameList ("",";",1), donor_acceptor()
"Ratio all",   donor_acceptorAll()
End


Function donor_acceptor()
 	variable donor
	variable acceptor
	prompt acceptor,"Acceptor peak"
	Prompt donor,"Donor peak"
	Doprompt "Enter values", acceptor,donor
	if (V_flag == 0)
		ratiometric(donor, acceptor)
	endif
end

Function ratiometric(donor,acceptor)
variable donor,acceptor
	GetLastUserMenuInfo		// sets S_value, V_value, etc.
	ratiometric_value(S_value,donor,acceptor)
end

Function ratiometric_value(tracename,donor,acceptor)
string tracename
variable donor,acceptor
wave w= traceNametowaveRef("",traceName)
	wavestats/q w
	variable xPeak = V_maxloc
	VARIABLE ratioValue = w(acceptor)/w(donor)  //scale value indexing
  //   VARIABLE ratioValue = w[acceptor]/w[donor]   // point value indexing  
	String TextItRatio
	sprintf TextItRatio, "\\Z09 \\K(0,65280,0)\\ON  \rRatio=%g",ratioValue
		Tag /F=2/S=3/A=MT/B=(0,0,0)  $tracename,xPeak, TextItRatio

//Appending values to a table, found in igorexchange.com/node/4857

Wave/Z/D ratioValueTable	// Look for ratioValue wave in current data folder
if (!WaveExists(ratioValueTable))
	Make/O/D/N=0 ratioValueTable
endif
Wave ratioValueTable
Variable numPoints = numpnts(ratioValueTable)
ratioValueTable[numPoints] = {ratioValue}	// Add new point to integrals

print tracename, ratioValue

End
 
Function donor_acceptorAll()
 	variable donor
	variable acceptor
	variable ratioValue
	prompt acceptor,"Acceptor peak"
	Prompt donor,"Donor peak"
	Doprompt "Enter values", acceptor,donor
	if (V_flag == 0)
		ratiometricall(donor, acceptor)
	endif
end
Function ratiometricall(donor,acceptor)
variable donor,acceptor
variable ratioValue
	String list = TraceNameList("", ";", 1)
	String tracename

	Variable index = 0
	do
		traceName = StringFromList(index, list)
		if (strlen(traceName) == 0)
			break // No more traces.
		endif
	 ratiometric_value(tracename,donor,acceptor)
		index += 1
	while(1)
	
wave ratioValueTable
edit ratioValueTable		
end

Thank you!
I don't fully get your request.
Do you want a second column containing the ratios? That would work with 
Edit LabelWave, ValueWave

or
Edit LabelWave
AppendToTable ValueWave


If you want to concatenate both properties use 
num2str
and "+"
Labels=LabelWave+" "+num2str(ValueWave)


For testing:
Make /N=2 /T LabelWave={"test1", "test2"}, Labels
Make /N=2 ValueWave={42,95}


Hope it covers your concern,
HJ

July 13, 2015 at 11:40 am - Permalink
About the "make" operation, how do I input the variables and string to the make operation? I have a set of variables and strings from a plot.
I tried the following and I only get the first set of data.

string tracename
variable ratiovalue
.....

Make /N=2 /T NameofTrace={traceName}
Make /N=2 ratioTabe={ratiovalue}
edit nameofTrace,ratioTable

Any suggestions?

Thank you!

HJDrescher wrote: I don't fully get your request.
Do you want a second column containing the ratios? That would work with 
Edit LabelWave, ValueWave

or
Edit LabelWave
AppendToTable ValueWave


If you want to concatenate both properties use 
num2str
and "+"
Labels=LabelWave+" "+num2str(ValueWave)


For testing:
Make /N=2 /T LabelWave={"test1", "test2"}, Labels
Make /N=2 ValueWave={42,95}


Hope it covers your concern,
HJ

July 13, 2015 at 03:14 pm - Permalink
Note the comma in the curly brackets in my test example. I separates entries. You also get a wave with one row although /N=2 creates a wave with 2 rows: "{...}" overwrites the original size.

print tracename, ratioValue make me think you want one string for one pair of tracename and ratio combined in one text label.

create a text wave (Make /T) called "ratioValueLables" and change
ratioValueTable[numPoints] = {ratioValue}

to

ratioValueTable[numPoints] = {ratioValue}
ratioValueLables[numPoints] = {tracename +" " + num2str(ratioValue)}

There are more elegant ways to do something like this, but it is still not clear what you are about to do.
HJ

July 13, 2015 at 03:48 pm - Permalink
Thank you very much, I cannot make it to work. Here, I attached a figure to show you what I want to do.
A. Obtaining ratio by B/A
B. Making table Name(a) <---> Ratio(a)
C. Plotting with category

I can obtain ratio value (ratioVAlue) and their name (tracename), but I struggled to plot them with one or two steps.

Can you point me to that direction?

Thank you!



HJDrescher wrote: Note the comma in the curly brackets in my test example. I separates entries. You also get a wave with one row although /N=2 creates a wave with 2 rows: "{...}" overwrites the original size.

print tracename, ratioValue make me think you want one string for one pair of tracename and ratio combined in one text label.

create a text wave (Make /T) called "ratioValueLables" and change
ratioValueTable[numPoints] = {ratioValue}

to

ratioValueTable[numPoints] = {ratioValue}
ratioValueLables[numPoints] = {tracename +" " + num2str(ratioValue)}

There are more elegant ways to do something like this, but it is still not clear what you are about to do.
HJ
thestory.png (252.79 KB)

July 14, 2015 at 09:46 am - Permalink
Try (in the command line)

duplicate /O /T Name LabelText
LabelText =Name+"\r"+num2str(Ratio)
Display Ratio vs LabelText

but I'm still not sure if this is what you want. Maybe you also want to have a look at
displayhelptopic "Tag"


HJ

July 14, 2015 at 10:44 am - Permalink
That helps, but I want to do more than that.

The detail:
First, what I want to do is to create a functions to measure a ratio from a lambda plot (a raw data format : intensity vs. wavelength).
To do this, I have to measure the ratio between lambda position at 580nm / 483 nm.
After obtaining the ratio (RatioValue in this case) by presenting in the same plot with tag operation.

Then I would like to create the bar chart with category plot. This is the step I struggle to transfer the values into category plot automatically.

Ultimately, I want to build a function to do the task with one step.
First, obtaining ratio value from raw lambda data
Second, automatically plot into category bar chart.

Does it clear to you? I really appreciate your helps.




HJDrescher wrote: Try (in the command line)

duplicate /O /T Name LabelText
LabelText =Name+"\r"+num2str(Ratio)
Display Ratio vs LabelText

but I'm still not sure if this is what you want. Maybe you also want to have a look at
displayhelptopic "Tag"


HJ

July 14, 2015 at 01:04 pm - Permalink
You can simply copy this fragment into your code (with the WAVE and WAVE /T references) at the end of your procedure generating the Name and Ratio waves (the display command is most likely to be omitted or at least it is necessary to check if this window is already displayed) to update your categories.
It is ok that the LabelText wave gets overwritten each time.

HJ

July 14, 2015 at 02:21 pm - Permalink
Good idea! i did not see that. Thank you again!
HJDrescher wrote: You can simply copy this fragment into your code (with the WAVE and WAVE /T references) at the end of your procedure generating the Name and Ratio waves (the display command is most likely to be omitted or at least it is necessary to check if this window is already displayed) to update your categories.
It is ok that the LabelText wave gets overwritten each time.

HJ

July 14, 2015 at 02:53 pm - Permalink