Missing optional dependency 'xlrd'. Install xlrd = 1.0.0 for Excel support Use pip or conda

Read csv file in python:
In this video tutorial I will show you how to solve the following problem "Missing optional dependency 'xlrd'. Install xlrd= 1.0.0 for Excel support Use pip or conda to install xlrd." in python.

[chipmunk]

Traceback (most recent call last):
File "C:\Software\Python\lib\runpy.py", line 197, in _run_module_as_main
return _run_code(code, main_globals, None,
File "C:\Software\Python\lib\runpy.py", line 87, in _run_code
exec(code, run_globals)
File "C:\Software\Python\Scripts\pip.exe\__main__.py", line 4, in <module>
ModuleNotFoundError: No module named 'pip'