pandas使用笔记----读取数据库、写入数据库

import pandas as pd

def pandas_read_sql(sql):
    """
    :return:dataframe
    """
    import pymysql
    conn = pymysql.connect(host='192.168.1.152',
                           user='stardata',
                           password='Tianhu2016',
                           db='stardata',
                           charset='utf8',
                           port=int(3306))
    conn.close()
    data_df = pd.read_sql(sql, con=conn)
    data = data_df.to_dict()
    return data['id'].values()


def pandas_to_sql(data_df):
    from sqlalchemy import create_engine
    engine = create_engine(
        'mysql+pymysql://{user}:{passwd}@{host}:{port}/{db}'.format(
            user="",
            passwd="",
            host="",
            port=int(),
            db="",
    ))
    table_name ="abc"
    #检查表是否存在
    check = engine.has_table(table_name)
    if not check:
        raise ValueError("表名:{},在数据库中不存在".format(table_name))
    data_df.to_sql(name=table_name, con=engine, if_exists='append', index=False)
    return

附官方文档地址https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_sql.html