Pandas getting error during installation with Python3.13/Win11

[cesarcabrera]

Problem: Win11, using PyCharm. The app creates a local virtual environment with python 3.13 by default, then I clone the project and try to install with the following command in the PyCharm terminal tab: py -m pip install taskAutom getting the following message:

PS C:\Users\cecabrer\PycharmProjects\taskAutom> python -m pip install taskAutom
Python was not found; run without arguments to install from the Microsoft Store, or disable this shortcut from Settings > Apps > Advanced app settings > App execution aliases.
PS C:\Users\cecabrer\PycharmProjects\taskAutom> py -m pip install taskAutom
Collecting taskAutom
  Downloading taskautom-8.4.3-py3-none-any.whl.metadata (964 bytes)
Collecting sshtunnel==0.4.0 (from taskAutom)
  Using cached sshtunnel-0.4.0-py2.py3-none-any.whl.metadata (19 kB)
Collecting netmiko==4.6.0 (from taskAutom)
  Using cached netmiko-4.6.0-py3-none-any.whl.metadata (8.2 kB)
Collecting pandas==2.2.2 (from taskAutom)
  Using cached pandas-2.2.2.tar.gz (4.4 MB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Installing backend dependencies ... done
  Preparing metadata (pyproject.toml) ... error
  error: subprocess-exited-with-error
  
  × Preparing metadata (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [12 lines of output]
      + meson setup C:\Users\cecabrer\AppData\Local\Temp\pip-install-31ifzjvb\pandas_826199c0633a4e04843117b90395710d C:\Users\cecabrer\AppData\Local\Temp\pip-install-31ifzjvb\pandas_826199c0633a4e04843117b90395710d\.mesonpy-ccoa4i0n\build -Dbuildtype=release -Db_ndebug=if-release -Db_vscrt=md --vsenv --native-file=C:\Users\cecabrer\AppData\Local\Temp\pip-install-31ifzjvb\pandas_826199c0633a4e04843117b90395710d\.mesonpy-ccoa4i0n\build\meson-python-native-file.ini
      The Meson build system
      Version: 1.2.1
      Source dir: C:\Users\cecabrer\AppData\Local\Temp\pip-install-31ifzjvb\pandas_826199c0633a4e04843117b90395710d
      Build dir: C:\Users\cecabrer\AppData\Local\Temp\pip-install-31ifzjvb\pandas_826199c0633a4e04843117b90395710d\.mesonpy-ccoa4i0n\build
      Build type: native build
      Project name: pandas
      Project version: 2.2.2
      
      ..\..\meson.build:2:0: ERROR: Could not find C:\Program Files (x86)\Microsoft Visual Studio\Installer\vswhere.exe
      
      A full log can be found at C:\Users\cecabrer\AppData\Local\Temp\pip-install-31ifzjvb\pandas_826199c0633a4e04843117b90395710d\.mesonpy-ccoa4i0n\build\meson-logs\meson-log.txt
      [end of output]
  
  note: This error originates from a subprocess, and is likely not a problem with pip.

[notice] A new release of pip is available: 25.1.1 -> 25.3
[notice] To update, run: C:\Users\cecabrer\AppData\Local\Programs\Python\Python313\python.exe -m pip install --upgrade pip
error: metadata-generation-failed

× Encountered error while generating package metadata.
╰─> See above for output.

note: This is an issue with the package mentioned above, not pip.
hint: See above for details.
PS C:\Users\cecabrer\PycharmProjects\taskAutom> python -m pip install taskAutom^C
PS C:\Users\cecabrer\PycharmProjects\taskAutom> python -m pip pandas==2.2.2
Python was not found; run without arguments to install from the Microsoft Store, or disable this shortcut from Settings > Apps > Advanced app settings > App execution aliases.