- from sqlalchemy import create_engine
- import pandas as pd
- import numpy as np
- df = 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 np
- import pandas as pd
- df = pd.DataFrame(np.random.randn(3, 4))
- df.to_csv('./a.csv', sep=',', header=True, index=True)
来源: http://www.bubuko.com/infodetail-2883750.html