Can not load superstructure file in LCA study

[OliverLyon]

Updating AB

• Yes, I have updated AB and still experience this issue

What happened?

Hi,

I imported and created a superstructure file then tried to upload it in LCA study. But I recieved a syntaxerror: invalid syntax. I pasted the relevant error below.

I used to run other LCA studies using the same approach and process but this time it does not work after I updated.
Could anyone check on this problem?

Thank you
Oliver

Relevant errors

SyntaxError: invalid syntax
21:26:56 | INFO | Loading Scenario file. This may take a while for large files
21:27:01 | INFO | <function ScenarioImportWidget.load_action at 0x0000024C7C3F7740> -- 9.606781482696533
21:27:21 | INFO | <function ScenarioImportWidget.load_action at 0x0000024C7C3F7740> -- 14.62622618675232
21:27:42 | INFO | Loading Scenario file. This may take a while for large files
21:27:44 | ERROR | SyntaxError: invalid syntax (<unknown>, line 0)
Traceback (most recent call last):
  File "C:\Users\10095\anaconda3\envs\activity-browser\Lib\site-packages\activity_browser\bwutils\superstructure\utils.py", line 81, in wrapper
    result = func(*args)
             ^^^^^^^^^^^
  File "C:\Users\10095\anaconda3\envs\activity-browser\Lib\site-packages\activity_browser\layouts\tabs\LCA_setup.py", line 605, in load_action
    df = ABCSVImporter.read_file(path, separator=separator)
         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\10095\anaconda3\envs\activity-browser\Lib\site-packages\activity_browser\bwutils\superstructure\file_imports.py", line 223, in read_file
    df = pd.read_csv(
         ^^^^^^^^^^^^
  File "C:\Users\10095\anaconda3\envs\activity-browser\Lib\site-packages\pandas\io\parsers\readers.py", line 1026, in read_csv
    return _read(filepath_or_buffer, kwds)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\10095\anaconda3\envs\activity-browser\Lib\site-packages\pandas\io\parsers\readers.py", line 626, in _read
    return parser.read(nrows)
           ^^^^^^^^^^^^^^^^^^
  File "C:\Users\10095\anaconda3\envs\activity-browser\Lib\site-packages\pandas\io\parsers\readers.py", line 1923, in read
    ) = self._engine.read(  # type: ignore[attr-defined]
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\10095\anaconda3\envs\activity-browser\Lib\site-packages\pandas\io\parsers\c_parser_wrapper.py", line 234, in read
    chunks = self._reader.read_low_memory(nrows)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "pandas/_libs/parsers.pyx", line 838, in pandas._libs.parsers.TextReader.read_low_memory
  File "pandas/_libs/parsers.pyx", line 921, in pandas._libs.parsers.TextReader._read_rows
  File "pandas/_libs/parsers.pyx", line 1045, in pandas._libs.parsers.TextReader._convert_column_data
  File "pandas/_libs/parsers.pyx", line 2116, in pandas._libs.parsers._apply_converter
  File "C:\Users\10095\anaconda3\envs\activity-browser\Lib\ast.py", line 64, in literal_eval
    node_or_string = parse(node_or_string.lstrip(" \t"), mode='eval')
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\10095\anaconda3\envs\activity-browser\Lib\ast.py", line 50, in parse
    return compile(source, filename, mode, flags,
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<unknown>", line 0

SyntaxError: invalid syntax

Operating system

Windows 11

Conda environment

[bsteubing]

Perhaps these 3 reports (#1622 and #1621) are related to the same underlying issue.

[bsteubing]

Hi @OliverLyon - thanks for reporting this. Could you please do a couple of checks for me:

• what is your pandas version?
• what is the length (rows) of the scenario difference file?
• does the AB still do the scenario calculations as you did with previous files?

[OliverLyon]

Hi @OliverLyon - thanks for reporting this. Could you please do a couple of checks for me:

• what is your pandas version?
• what is the length (rows) of the scenario difference file?
• does the AB still do the scenario calculations as you did with previous files?

Hi, @bsteubing - thank you for replying.
My panda version:

Name Version Build Channel

pandas 2.3.3 py311h11fd7f3_2 conda-forge

Rows of the superstructure file:
261247 rows

I was doing scenario calculation with another file half a year ago using SSP1 PkBudg1150, now I am trying SSP2 and SSP5 Pkbudg 1150 scenarios.

Thank you.
OliverLyon

[bsteubing]

thanks @OliverLyon. Does the problem persist? One thing that came to my mind is whether you are using the right separator in the excel/csv file (e.g. "," instead of ";" oder the other way around). Have you tried that?

[bsteubing]

Closing the issue. We can re-open it if the problem persists.