写入Oracle

from sqlalchemy import create_engineimport pandas as pdimport numpy as npdf = pd.DataFrame(np.random.randn(3, 4))conn_string='oracle+cx_oracle://scott:tiger@127.0.0.1:1521/orcl'engine = create_engine(conn_string, echo=False)df.to_sql('Output', con=engine)

写入csv

import numpy as npimport pandas as pddf = pd.DataFrame(np.random.randn(3, 4))df.to_csv('./a.csv', sep=',', header=True, index=True)