To create a virtual environment, go to the root of your project and run
python -m venv venv
It will create a virtual environment called venv
.\venv\Scripts\activate
pip install pandas pyodbc
pip freeze > requirements.txt
pip install -r requirements.txt