Thursday, June 9, 2022

Help 4 Other

 Google Sheets

  • IMPORTRANGE does not support importing data from a connected sheet
    • Use Pivot table or Extract first
    • Then use the function on these data

Python
  • sqlalchemy.exc.ObjectNotExecutableError
    • Check the version
    • sqlalchemy==1.4.42
  • TypeError: Casting to unit-less dtype 'datetime64' is not supported. Pass e.g. 'datetime64[ns]' instead.
    • Check the version
    • pandas==1.3.5
  • __init__() got multiple values for argument 'schema'
    • pip install sqlalchemy==1.4.46