pandas mysql conflict_pandas操作mysql从放弃到入门

相关帮助文档

一、如何读取数据库-read_sql

示例代码如下

from sqlalchemy import create_engine

import pandas as pd

username = '用户名'

password = '密码'

host = '连接地址'

db = '数据库'

port = 端口号

link = f'''mysql+pymysql://{username}:{password}@{host}:{port}/{db}?charset=utf8'''

engine = create_engine(link, pool_recycle=3600)

核心方法read_sql

log:pd.DataFrame = pd.read_sql("SELECT * FROM log ORDER BY id DESC ",engine)

执行结果如下

二、如何筛选数据

筛选创建时间大于某个时间点的记录

import datetime

log[log['create_time'] > '2020-01-15 16:14:22']