Pandas+Numpy
import pandas as pd
import numpy as np
import os
import warnings
warnings.filterwarnings('ignore')
pd.set_option('display.max_rows', 600) # 设置最大行数
pd.set_option('display.max_columns', 100) # 设置最大列数
Jupyter多任务输出
from IPython.core.interactiveshell import InteractiveShell
InteractiveShell.ast_node_interactivity = 'all'
Pymysql
def get_df_from_mysql(sql):
import pymysql
conn = pymysql.connect(
host="host_id",
port=3306,
user="xxxxx",
passwd="xxxxx",
db="db_name",
charset='utf8'
)
df = pd.read_sql(sql,conn)
return df