此Python脚本的目标是为所输入的任何状态找到相应的URL。在脚本的“查找”部分中，我不断收到这些错误。输入的名称为“状态”。

请参见下面的代码并进行追溯。

df =pd.read_excel(r'C:/Users/user.name/Desktop/PythonScript_Data_medverify.xlsx',sheet_name='STATE_URL_MAP')
df = df.to_excel(r'C:/Users/user.name/Desktop/PythonScript_Data_medverify.xlsx')
stateurl = df[df['State']==state]['URL']

这是错误/回溯

Traceback (most recent call last):

  File "<ipython-input-26-df1e8ca01184>",line 1,in <module>
    runfile('C:/Users/user.name/.spyder-py3/CREDverifyscript.py',wdir='C:/Users/user.name/.spyder-py3')

  File "C:\Users\user.name\AppData\Local\Continuum\anaconda3\lib\site-packages\spyder_kernels\customize\spydercustomize.py",line 668,in runfile
    execfile(filename,namespace)

  File "C:\Users\user.name\AppData\Local\Continuum\anaconda3\lib\site-packages\spyder_kernels\customize\spydercustomize.py",line 108,in execfile
    exec(compile(f.read(),filename,'exec'),namespace)

  File "C:/Users/user.name/.spyder-py3/CREDverifyscript.py",line 23,in <module>
    stateurl = df[df['State']==state]['URL']

TypeError: 'NoneType' object is not subscriptable