XAS spectra import

Compare XAS import modes, check the energy axis, and verify samples, omitted values, and curve families.

acq.xas · Version 1.0.1

Queue famiglia-xas.csv with processed_family. Set Header to present, Energy column to 1, and Energy unit to eV. Column one contains energy. Columns two and three contain spectra on the same grid. Set First processed spectrum column to 2 and Last processed spectrum column to 0 to read both spectra. The family Dataset should contain two responses over 7690 to 7720 eV.

Understand the five modes

  • processed_family reads several already processed curves from the specified column range.
  • processed_single reads only the Processed mu(E) column column.
  • raw_transmission calculates the natural logarithm of the I₀/Iₜ ratio. In xas-grezzo.csv uses numerator 2 and denominator 3. At 7690 eV the expected value is ln(100/80) ≈ 0.223144.
  • raw_fluorescence normalizes the fluorescence channel by the incident monitor. Use numerator 4 and denominator 2 for an expected ratio of 0.2 at the first point.
  • raw_ratio produces the direct ratio of the declared columns. The parser sums the channels of each list to get the numerator and the denominator.

Energy unit declares a unit. Choosing eV or keV leaves the source values unchanged. Use auto only when the source identifies the unit unambiguously. omit_samples drops invalid samples for the affected branch, while error requires correction before publication. Check for enough finite points in each curve and for duplicate axis values.

Check axes and samples

In xas-invalido.csv, energy decreases. The tested auto setting could not resolve the unit, while an explicit declaration allowed the series. With keV, the first value remains 7720. For scientific work with the example, use eV, the unit indicated by the column name. With omit_samples, the second spectrum keeps two points and the first keeps four. The file is rejected under error. xas-un-solo-punto.csv demonstrates rejection when a member has fewer than two finite values. xas-duplicata.csv repeats an energy and is rejected.

Exercise files

Sources, licenses, and SHA-256

Screenshots

Open a screenshot to view it at full size.

famiglia-xas.csv added in Acquisition with Dataset ID famiglia_xas. The row shows the import settings.
famiglia-xas.csv added in Acquisition with Dataset ID famiglia_xas. The row shows the import settings.
Pending Preview of famiglia-xas.csv with processed_family profile, energy in eV and two response columns.
Pending Preview of famiglia-xas.csv with processed_family profile, energy in eV and two response columns.
After Import, the browser shows Active Dataset: famiglia_xas. The Metadata tab describes the recorded result.
After Import, the browser shows Active Dataset: famiglia_xas. The Metadata tab describes the recorded result.
Canonical table of famiglia_xas. The member_id column distinguishes the responses on the same energy grid.
Canonical table of famiglia_xas. The member_id column distinguishes the responses on the same energy grid.
Canonical table published for the transmission profile.
Canonical table published for the transmission profile.
Canonical table for the family using omit_samples. The second member retains two finite points.
Canonical table for the family using omit_samples. The second member retains two finite points.
Failed detail under the error policy. The member spectrum_002 contains NaN or infinity.
Failed detail under the error policy. The member spectrum_002 contains NaN or infinity.

Controls and settings

XAS source layout

Choose how many responses to read and whether to calculate μ(E). processed_family uses several y-columns, processed_single one. raw_transmission calculates the natural logarithm of the ratio, raw_fluorescence and raw_ratio the ratio of the selected channel sums.

Default value in the basic configuration processed_family.

  • processed_family · Choose how many responses to read and whether to calculate μ(E). processed_family uses several y-columns, processed_single one. raw_transmission calculates the natural logarithm of the ratio, raw_fluorescence and raw_ratio the ratio of the selected channel sums.
  • processed_single · Choose how many responses to read and whether to calculate μ(E). processed_family uses several y-columns, processed_single one. raw_transmission calculates the natural logarithm of the ratio, raw_fluorescence and raw_ratio the ratio of the selected channel sums.
  • raw_transmission · Choose how many responses to read and whether to calculate μ(E). processed_family uses several y-columns, processed_single one. raw_transmission calculates the natural logarithm of the ratio, raw_fluorescence and raw_ratio the ratio of the selected channel sums.
  • raw_fluorescence · Choose how many responses to read and whether to calculate μ(E). processed_family uses several y-columns, processed_single one. raw_transmission calculates the natural logarithm of the ratio, raw_fluorescence and raw_ratio the ratio of the selected channel sums.
  • raw_ratio · Choose how many responses to read and whether to calculate μ(E). processed_family uses several y-columns, processed_single one. raw_transmission calculates the natural logarithm of the ratio, raw_fluorescence and raw_ratio the ratio of the selected channel sums.

Text delimiter

Choose the separator actually used in the source. auto estimates it from a sample. comma uses comma, semicolon semicolon, tab tab, and whitespace whitespace where available. Check that Preview returns the expected number of columns.

Default value in the basic configuration auto.

  • auto · Choose the separator actually used in the source. auto estimates it from a sample. comma uses comma, semicolon semicolon, tab tab, and whitespace whitespace where available. Check that Preview returns the expected number of columns.
  • comma · Choose the separator actually used in the source. auto estimates it from a sample. comma uses comma, semicolon semicolon, tab tab, and whitespace whitespace where available. Check that Preview returns the expected number of columns.
  • semicolon · Choose the separator actually used in the source. auto estimates it from a sample. comma uses comma, semicolon semicolon, tab tab, and whitespace whitespace where available. Check that Preview returns the expected number of columns.
  • tab · Choose the separator actually used in the source. auto estimates it from a sample. comma uses comma, semicolon semicolon, tab tab, and whitespace whitespace where available. Check that Preview returns the expected number of columns.
  • whitespace · Choose the separator actually used in the source. auto estimates it from a sample. comma uses comma, semicolon semicolon, tab tab, and whitespace whitespace where available. Check that Preview returns the expected number of columns.

Header

present uses a header row, absent starts from the data rows after any preamble.

Default value in the basic configuration absent.

  • absent · present uses a header row, absent starts from the data rows after any preamble.
  • present · present uses a header row, absent starts from the data rows after any preamble.

Header row

Header position among the rows processed by the parser, 1-based. Check in Preview which row is used together with the initial skip.

Default value in the basic configuration 1.

Physical rows before header/data

Number of physical preamble rows to skip before interpreting the header or data.

Default value in the basic configuration 0.

Energy column

1-based position of the energy column. It must differ from the detector columns.

Default value in the basic configuration 1.

Energy unit

With auto the unit is resolved from the source where the conditions allow it. eV or keV declare the unit. The input values remain unchanged.

Default value in the basic configuration auto.

  • auto · With auto the unit is resolved from the source where the conditions allow it. eV or keV declare the unit. The input values remain unchanged.
  • eV · With auto the unit is resolved from the source where the conditions allow it. eV or keV declare the unit. The input values remain unchanged.
  • keV · With auto the unit is resolved from the source where the conditions allow it. eV or keV declare the unit. The input values remain unchanged.

First processed spectrum column

First column included in the family, starting from 1.

Default value in the basic configuration 2.

Last processed spectrum column (0 = final column)

Last column included in the family. 0 uses the last available one.

Default value in the basic configuration 0.

Processed mu(E) column

Position of the μ(E) column when reading an already processed spectrum.

Default value in the basic configuration 2.

Raw numerator columns (semicolon separated)

Positions of the numerator channels, separated by semicolons. With several channels, the raw branch sums their values for each sample.

The field is initially blank.

Raw denominator columns (semicolon separated)

Positions of the denominator channels, separated by semicolons. The two sets must not overlap and must not include the energy column.

The field is initially blank.

Invalid/non-finite samples

omit_samples excludes samples that fail the branch’s numeric criteria and records how many were excluded. error stops the import when an invalid sample is detected.

Default value in the basic configuration omit_samples.

  • omit_samples · omit_samples excludes samples that fail the branch’s numeric criteria and records how many were excluded. error stops the import when an invalid sample is detected.
  • error · omit_samples excludes samples that fail the branch’s numeric criteria and records how many were excluded. error stops the import when an invalid sample is detected.

Parser rows per block

Read block size in rows. Partitioning affects reading only; the scientific comparison concerns the published channels and samples.

Default value in the basic configuration 2048.

Scrollbar

Use the horizontal or vertical scrollbar to reach fields, entries, or text outside the visible area.

Scrollbar

Use the horizontal or vertical scrollbar to reach fields, entries, or text outside the visible area.