import pip
# List of packages to install
packages = ['pdfplumber', 'pandas']
# Install each package while bypassing the proxy
for package in packages:
pip.main([
'install', package,
'--trusted-host', 'pypi.org',
'--trusted-host', 'files.pythonhosted.org'
])
# Import the installed packages
import openpyxl
import xlrd
import lxml