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
VS code
- (.venv) workspace-vs % python -V
- zsh: command not found: python
- add "python.experiments.optOutFrom": ["pythonTerminalEnvVarActivation"] to settings.json