| 1234567 |
- 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为不写入索引
|
