python pandas 读取postgresql中的数据

最新推荐文章于 2024-09-02 11:50:21 发布

_____miss

最新推荐文章于 2024-09-02 11:50:21 发布

阅读量7.6k

点赞数 1

分类专栏： pandas Python

本文链接：https://blog.csdn.net/u011412768/article/details/100430080

版权

Python 同时被 2 个专栏收录

24 篇文章 0 订阅

订阅专栏

pandas

10 篇文章 2 订阅

订阅专栏

    import psycopg2
    import pandas as pd
    
    # postgres config
    postgres_host = ""               # 数据库地址
    postgres_port = "5432"       # 数据库端口
    postgres_user = ""              # 数据库用户名
    postgres_password = ""      # 数据库密码
    postgres_datebase = ""      # 数据库名字
    postgres_table1 = ""           #数据库中的表的名字

    # connection string
    conn_string = "host=" + postgres_host + " port=" + postgres_port + " dbname=" + postgres_datebase + \
                  " user=" + postgres_user + " password=" + postgres_password
    conn = psycopg2.connect(conn_string)

    sql_command1 = "select * from" .format(postgres_table1)

    try:
        data1 = pd.read_sql(sql_command1, conn)
    except:
        print("load data from postgres failure !")
        exit()

    if data1.shape[0] == 0:
        print("there is no data in !")

import psycopg2

pg_host = ""
pg_port = "5433"
pg_user = ""
pg_password = ""
pg_database = ""
pg_table = ""

conn_string = "host=" + pg_host + " port=" + pg_port + " dbname=" + pg_database + " user=" + pg_user + " password=" + pg_password
conn = psycopg2.connect(conn_string)
curs = conn.cursor()

sql_command = "select {} from {} where "
curs.execute(sql_command)
data = pd.DataFrame(curs.fetchall(), columns=select_columns)