写入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)
Python DataFrame导出CSV、数据库
标签：div pytho port acl dex .data dom ring bsp
Python DataFrame导出CSV、数据库
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)