line scans

Troy

I have a number of lines across a sample with standards in between. I want to stitch them together and make one long line of the reduced data. I would like to be able to stack all of the output data for comparison to the sample. I can't see an easy way to do that. Is there a function for this, or do we just have to take the export file, copy and paste the individual lines into one spreadsheet and go from there?

Joe

Hi Troy,

You have a couple of options:

Export the time resolved output channels and stitch them together manually as you suggested.

Use python to put the data together, something like:

import pandas as pd
import numpy as np
from iolite.QtGui import QFileDialog

sg = data.selectionGroup('NameOfGroupToCombine')
channels = data.timeSeriesList(data.Output)

d = {}

for channel in channels:
	sg_channel = np.concatenate([channel.dataForSelection(s) for s in sg.selections()])
	d[channel.name] = sg_channel

df = pd.DataFrame(d)
df.to_excel(QFileDialog.getSaveFileName())

As written it'll concatenate all of the output channels. If you wanted just a few you could do something like:

channels = [data.timeSeries(cn) for cn in ['Sr88', 'Ba138']]

You could also add a column for the time if you wanted, something like:

tick = channels[0].time()[1] - channels[0].time()[0]
df['Time'] = np.arange(0, len(df))*tick
df.set_index('Time', inplace=True)

would go before the last line that writes the data frame to an Excel file.

Let me know if you have any questions or if I misinterpreted the question.

All the best,

Troy

Wow Joe, thanks! This seems perfect. I will try it.

Troy

Hi Joe,

It was easy to come and paste this and it worked after I got the group name in, but I don't think I understand the output. A page comes up for me to name the file but it doesn't have a file type and there is an error that says no engine for filetype. I have python on my computer.

Thanks, Troy

maryandjesse

Troy try naming the file "myStuff.xlsx" instead of "myStuff", and then pandas will know which engine to use. my guess.

Troy

Awesome! It works.

Troy

Actually it worked once, and now I get the error
"ValueError
:
No engine for filetype: ''

Joe

Are you sure you wrote the full file name with the extension? That error seems to occur if you don't include the ".xlsx". If you want to avoid being hassled by the file extension, you could change the last few lines to read as follows:

filename = QFileDialog.getSaveFileName()
if not filename.endswith('.xlsx'):
	filename += '.xlsx'

df.to_excel(filename)

That will check if the name specified ends with ".xlsx" and will add it for you if it is missing.

Troy

😄