Python For Look with条件

Question

我正在寻找创建一个文件夹与excel的每一个，并希望隔离数据的具体电子邮件地址为基础的行。如何使用SQL语句和/或使用for循环（条件/where子句）将excel创建到不同的文件夹中

orc_con = cx_Oracle.connect('xxx/xxx@xxxx.world')
SQL_Statement = 'select * from PYTHON_TEST' 
df_ora = pd.read_sql(SQL_Statement, con=orc_con)
for i in df_ora.itertuples():
    print(i)
writer = pd.ExcelWriter('XXXXX_Monthly_Claims.xlsx', engine='xlsxwriter')
df_ora.to_excel(writer, sheet_name='CCBHC',index=False)
# Get the xlsxwriter objects from the dataframe writer object.
workbook  = writer.book
worksheet = writer.sheets['Data']
# Close the Pandas Excel writer and output the Excel file.
writer.save()