Errors faced when using Pyinstaller

I realized this happens when I use pyinstaller with Pandas module:

PyInstaller Error: RecursionError: maximum recursion depth exceeded 

It works fine with other modules I had. To resolve this,

1) Run the following to create a test.spec file

     pyinstaller -F test.py

 2) Inside test.spec, insert in the following at the top of the file

     import sys
  sys.setrecursionlimit(5000)


3) After that rerun the following command

    pyinstaller filename.spec

or

pyinstaller --paths C:\Python35\Lib\site-packages\PyQt5\Qt\bin test.spec


Source: https://stackoverflow.com/questions/38977929/pyinstaller-creating-exe-runtimeerror-maximum-recursion-depth-exceeded-while-ca

-----------------------------------------------------------------------------------------------
Other errors encountered:


1) pkg_resources.py Module not round

ModuleNotFoundError: No module named 'pkg_resources.py2_warn'
[25405] Failed to execute script pyi_rth_pkgres


Seems like there are some issues with the pyinstaller prod version.
After uninstalling it and installing it with the dev version, it works! :D

pip uninstall pyinstaller
pip install https://github.com/pyinstaller/pyinstaller/archive/develop.zip 

Source: https://stackoverflow.com/questions/60152370/problems-with-excutables-made-on-python


2) Missing dll files when using pyinstaller

After I run test.py I was faced with the python37.dll not found error.
So I rerun the pyinstaller specifying the below parameters:

pyinstaller --paths C:\Python35\Lib\site-packages\PyQt5\Qt\bin test.py


And yay, it works! :)

Source: https://stackoverflow.com/questions/38674400/missing-dll-files-when-using-pyinstaller