Cross section extraction

User Support
1

Hi,

I have generated MG cross section data for 8 energy groups. When I print it out, it Shows me that the calculations did run successfully and the results are displayed like this:

Multi-Group XS
Reaction Type = nu-fission
Domain Type = cell
Domain ID = 1
Nuclide = U235
Cross Sections [barns]:
Group 1 [821000.0 - 20000000.0eV]: 3.30e+00 +/- 1.30e-01%
Group 2 [5530.0 - 821000.0 eV]: 3.97e+00 +/- 8.86e-02%
Group 3 [4.0 - 5530.0 eV]: 5.50e+01 +/- 1.26e-01%
Group 4 [0.625 - 4.0 eV]: 8.84e+01 +/- 1.94e-01%
Group 5 [0.28 - 0.625 eV]: 2.90e+02 +/- 2.66e-01%
Group 6 [0.14 - 0.28 eV]: 4.49e+02 +/- 2.50e-01%
Group 7 [0.058 - 0.14 eV]: 6.87e+02 +/- 1.76e-01%
Group 8 [0.0 - 0.058 eV]: 1.44e+03 +/- 1.62e-01%

Nuclide        =	U238
Cross Sections [barns]:
        Group 1 [821000.0   - 20000000.0eV]:	1.06e+00 +/- 1.57e-01%
        Group 2 [5530.0     - 821000.0  eV]:	1.21e-03 +/- 1.56e-01%
        Group 3 [4.0        - 5530.0    eV]:	5.81e-04 +/- 2.04e+00%
        Group 4 [0.625      - 4.0       eV]:	6.54e-06 +/- 1.72e-01%
        Group 5 [0.28       - 0.625     eV]:	1.07e-05 +/- 2.64e-01%
        Group 6 [0.14       - 0.28      eV]:	1.55e-05 +/- 2.51e-01%
        Group 7 [0.058      - 0.14      eV]:	2.30e-05 +/- 1.76e-01%
        Group 8 [0.0        - 0.058     eV]:	4.24e-05 +/- 1.61e-01%
  • but when I try to extract the data using Pandas DataFrame like this :

nufission = xs_library[fuel_cell.id][‘nu-fission’]
nufission.print_xs(xs_type=‘micro’, nuclides=[‘U235’, ‘U238’])
df = nufission.get_pandas_dataframe(xs_type=‘micro’)
pd.set_option(‘display.float_format’, ‘{:.2e}’.format)
df.head(20)

nothing happens!
I also tried to covnvert it to excel and I not the error below:

Traceback (most recent call last):
File “/dss/dsshome1/0C/ge25kij2/.local/lib/python3.8/site-packages/pandas/io/excel/_base.py”, line 1111, in new
engine = config.get_option(f"io.excel.{ext}.writer", silent=True)
File “/dss/dsshome1/0C/ge25kij2/.local/lib/python3.8/site-packages/pandas/_config/config.py”, line 261, in call
return self.func(*args, **kwds)
File “/dss/dsshome1/0C/ge25kij2/.local/lib/python3.8/site-packages/pandas/_config/config.py”, line 135, in _get_option
key = _get_single_key(pat, silent)
File “/dss/dsshome1/0C/ge25kij2/.local/lib/python3.8/site-packages/pandas/_config/config.py”, line 121, in _get_single_key
raise OptionError(f"No such keys(s): {repr(pat)}")
pandas._config.config.OptionError: “No such keys(s): ‘io.excel.xls.writer’”

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File “mg.py”, line 176, in
nufission.export_xs_data(filename=‘nufission-xs’, format=‘excel’)
File “/dss/dsshome1/0C/ge25kij2/.local/lib/python3.8/site-packages/openmc/mgxs/mgxs.py”, line 2007, in export_xs_data
df.to_excel(filename + ‘.xls’, index=False)
File “/dss/dsshome1/0C/ge25kij2/.local/lib/python3.8/site-packages/pandas/core/generic.py”, line 2252, in to_excel
formatter.write(
File “/dss/dsshome1/0C/ge25kij2/.local/lib/python3.8/site-packages/pandas/io/formats/excel.py”, line 934, in write
writer = ExcelWriter( # type: ignore[abstract]
File “/dss/dsshome1/0C/ge25kij2/.local/lib/python3.8/site-packages/pandas/io/excel/_base.py”, line 1115, in new
raise ValueError(f"No engine for filetype: ‘{ext}’") from err
ValueError: No engine for filetype: ‘xls’

Can someone guide me how to extract my Cross section data and covert it to .xml ?

thank you in advance

Mary