table 转view dual python 代码

最新推荐文章于 2025-04-23 11:50:25 发布

tang_xin_cs

最新推荐文章于 2025-04-23 11:50:25 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： python 文章标签： python 转换工具

本文链接：https://blog.youkuaiyun.com/weixin_43531940/article/details/124759157

python 专栏收录该内容

10 篇文章

订阅专栏

这段代码展示了如何在Python中导入Pandas库和BytesIO对象，然后读取一个内含CSV数据的BytesIO流。接着，它填充了DataFrame中的空值，并遍历每一行生成SQL SELECT查询。查询的列名和对应的值被转化为带有单引号的格式，最后将所有查询用'union all'连接起来。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import pandas
import io



s =  io.BytesIO(b""""CATEGORY_ID","CATEGORY_NAME","DESCRIPTION","PICTURE"
1,"Beverages","Soft drinks, coffees, teas, beers, and ales","beverages.gif"
2,"Condiments","Sweet and savory sauces, relishes, spreads, and seasonings","condiments.gif"
3,"Confections","Desserts, candies, and sweet breads","confections.gif"
4,"Dairy Products","Cheeses","diary.gif"
5,"Grains/Cereals","Breads, crackers, pasta, and cereal","cereals.gif"
6,"Meat/Poultry","","meat.gif"
7,"Produce","Dried fruit and bean curd","produce.gif"
8,"Seafood","Seaweed and fish","seafood.gif"
9,"9","9","9"
10,"8","","8"
""")
df = pandas.read_csv(s)

col = df.columns
result = []
df = df.fillna('')
for key, item in df.iterrows():
    x = item.tolist()
    s_sql =' select '+ ','.join (list(map(lambda y,z : f" '{y}' {z} " , x, col))) + ' from dual '
    result.append(s_sql)
print(' union all \n'.join(result))