Python通过EXCEL生成SQL语句

最新推荐文章于 2024-08-31 16:44:47 发布

MetalTrader

最新推荐文章于 2024-08-31 16:44:47 发布

阅读量819

点赞数

CC 4.0 BY-SA版权

分类专栏： SoftwareTechnology 文章标签： pandas python 开发语言

本文链接：https://blog.youkuaiyun.com/m0_55389447/article/details/125649024

SoftwareTechnology 专栏收录该内容

141 篇文章 ¥99.90 ¥299.90

订阅专栏

超级会员免费看

本文介绍如何利用Python的pandas库将数据处理后的DataFrame转换为SQL插入语句，适用于快速将数据导入数据库。

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

import pandas as pd


class SqlTest(object):

    def __init__(self):
        self.a = f"with a1 as ( "
        self.b = f")select count(*) from a1"
        self.df = pd.read_csv(r'D:\sql.csv', encoding='gb18030')
        self.text = " "

    def sqltest(self):
        df = self.df
        print(self.a)
        for index, row in df.iterrows():
            if index != df.index[-1]:
                text = f"{self.text}select '{row[0]}.{row[1]}' as table_name,count(*) as count from '{row[0]}.{row[1]}' where dt ='{row[2]}'union on"
                print(text)
            else:
                text = f"{self.text}select '{row[0]}.{row[1]}' as table_name,count(*) as count from '{row[0]}.{row[1]}' where dt ='{row[2]}'  "
        print(text)

        print(self.b

了解本专栏