I think I have got it working, need to run the following at the top of the script prior to installing/running pandas.
import locale
locale.setlocale(locale.LC_ALL, 'en_US')
Thanks for your help @eirannejad , will let you know if we run into anymore issues.