遍历pd pandas dataframe oracle查询语句

最新推荐文章于 2024-09-19 20:18:46 发布

nongcunqq

最新推荐文章于 2024-09-19 20:18:46 发布

阅读量115

点赞数

分类专栏： python

本文链接：https://blog.csdn.net/nongcunqq/article/details/116533443

版权

python 专栏收录该内容

339 篇文章 0 订阅

订阅专栏

for index, row in df.iterrows():

  print(index, row)

在这里插入图片描述
sql = ‘’‘select * from “mail” WHERE “name”= ‘CESBG’ order by “seq” ‘’’
l = getOracleData(sql)

print(l['name'][0])
mail_list = []
for index, row in l[:5].iterrows():
    dic = {}
    name = row['name']
    mail_to = row['mail_to']
    cc = row['cc']
    bcc = row['bcc']
    url = row['url']
    dic['name'] = name
    dic['to'] = mail_to
    dic['cc'] = cc
    dic['bcc'] = bcc
    dic['url'] = url
    print(name)
    print(mail_to)
    mail_list.append(dic)
print(mail_list)