Pandas issue on Raspberry Pi

[hesco40]

I have a simple pandas import with a simple script on a raspberry pi. I can run it through the command line and through the editor. However, when I try to double click it to run it, it fails before doing anything. I see the screen flash and then it goes away without running the code.

import time
import pandas as pd
df = pd.read_csv('bar.csv')
print(df.tail())
time.sleep(60)

I ran this little test script because my larger script was having a similar issue so I tried to troubleshoot all of the possible issues. If I comment out all the pandas stuff it runs just fine when you double click it. What has me questioning my sanity is the fact that it does run just fine in the command line but not when I try to double click the file. The csv is in the same file location as the python file.