主页 / 问题 / 1181815
Accepted
user357670
Asked:2020-09-24 14:34:35 +0000 UTC2020-09-24 14:34:35 +0000 UTC

将 Pandas 时间戳转换为字符串

  • 772

有一个解析器代码：

import io
from zipfile import ZipFile
import pandas as pd
def read_zip(zip_fn, extract_fn=None):
    zf = ZipFile(zip_fn)
    if extract_fn:
        return zf.read(extract_fn)
    else:
        return {name:zf.read(name) for name in zf.namelist()}
df = pd.read_excel(io.BytesIO(read_zip(r'C:\download\test.xlsx.zip', 'test.xlsx')))
tuples = [tuple(x) for x in df.values]

转换为元组以写入数据库。

但Timestamp它没有正确写入数据库，因此我将不得不转换为string.

python

1 个回答

  1. Best Answer

    试试这样：

    import cx_Oracle
from cx_Oracle import makedsn
from sqlalchemy import create_engine


usr = "test"
pwd = "my_oracle_password"
dsn = makedsn("ora_scan_or_hostname", 1521, service_name="my_service_name")

df = pd.read_excel(io.BytesIO(read_zip(r'C:\download\test.xlsx.zip', 'test.xlsx')), 
                   parse_dates=['your_date_column_name'])

engine = create_engine(f'oracle+cx_oracle://{usr}:{pwd}@{dsn}')

df.to_sql('table_name', engine, if_exists='append')
    • 1

相关问题