According to the OP in the comments:

The macs I was working on had python 2.7 installed; I wrote the program on a windows machine using python 3.7. To solve the problem, I installed python3, used pip3 install pandas numpy (since pip by itself was installing the modules to 2.7), and then pip3 install xlrd.