import pandas as pd
import psycopg2

eng_idc = psycopg2.connect(database='data_warehouse_bigtree', user='model', password='model123', host='10.0.54.80')
sql = "select * from udt.model_score_monitor limit 5 offset 0;"
data_df = pd.read_sql(sql=sql, con=eng_idc)
# data_df.to_excel('excel1.xlsx', sheet_name='Sheet1', index=False)  # index false为不写入索引