急救，SyntaxError: invalid syntax

Question

import pandas as pd
import openpyxl
data=  pd.read_excel('123.xlsx',sheet_name='details')
x=len(data)
print(x)
df_bool_multi_and = ((data['Sales Org'] == 2118) & (data['SDV Code'] != 'LP6') & (data['Block Bucket (Aged update)'] != 'Service')&(data['Aged'] == 'Aged order'))
print("百分比为:{:.2f}%".format(df_bool_multi_and.sum()*100/(x*1.0)))
print(data.Sales Order Type.isin(['ZB1S','ZB1B','ZB1A','ZB1O','ZB4S','ZB4B']))

报错信息
print(data.Sales Order Type.isin(['ZB1S','ZB1B','ZB1A','ZB1O','ZB4S','ZB4B']))
^
SyntaxError: invalid syntax
请问这个要怎么解决？

Answer 1

语法错误 data. 这有问题，是否是下边这样呢

print(data['Sales Order Type'].isin(['ZB1S','ZB1B','ZB1A','ZB1O','ZB4S','ZB4B']))