basedosdados / pipelines

🔀 Orquestrador de fluxos de captura, ingestão e tratamento de dados da BD
https://basedosdados.github.io/pipelines/
34 stars 13 forks source link

[bugfix]: Update `openpyxl` and add upper limit for `setuptools` #884

Closed aspeddro closed 3 weeks ago

aspeddro commented 3 weeks ago

Pandas requer openpyxl 3.1.0 ou maior para ler arquivos xlsx.

Erro na pipeline br_mp_pep.cargos_funcoes

Task 'clean_data': Exception encountered during task execution!
Traceback (most recent call last):
  File "/opt/venv/lib/python3.10/site-packages/prefect/engine/task_runner.py", line 876, in get_task_run_state
    value = prefect.utilities.executors.run_task_with_timeout(
  File "/opt/venv/lib/python3.10/site-packages/prefect/utilities/executors.py", line 454, in run_task_with_timeout
    return task.run(*args, **kwargs)  # type: ignore
  File "/home/runner/work/pipelines/pipelines/pipelines/datasets/br_mp_pep_cargos_funcoes/tasks.py", line 344, in clean_data
  File "/home/runner/work/pipelines/pipelines/pipelines/datasets/br_mp_pep_cargos_funcoes/tasks.py", line 345, in <listcomp>
  File "/opt/venv/lib/python3.10/site-packages/pandas/io/excel/_base.py", line 495, in read_excel
    io = ExcelFile(
  File "/opt/venv/lib/python3.10/site-packages/pandas/io/excel/_base.py", line 1567, in __init__
    self._reader = self._engines[engine](
  File "/opt/venv/lib/python3.10/site-packages/pandas/io/excel/_openpyxl.py", line 552, in __init__
    import_optional_dependency("openpyxl")
  File "/opt/venv/lib/python3.10/site-packages/pandas/compat/_optional.py", line 164, in import_optional_dependency
    raise ImportError(msg)
ImportError: Pandas requires version '3.1.0' or newer of 'openpyxl' (version '3.0.9' currently installed).
github-actions[bot] commented 3 weeks ago

Coverage

Tests Skipped Failures Errors Time
8 7 :zzz: 0 :x: 0 :fire: 9.216s :stopwatch: