python-3.x - 熊猫和天蓝色：DataFrame to_csv blob

Question

我想将 python pandas DataFrame 存储到 Azure，但Jay Gong（Python 2.7）的解决方案给了我错误：

from azure.storage.blob import BlockBlobService
service = BlockBlobService(
    account_name=STORAGE_ACCOUNT_NAME,
    account_key=STORAGE_ACCOUNT_KEY
)

with io.StringIO() as stream:
    df.to_csv(stream, encoding="utf-8")
    service.create_blob_from_text('containert', 'example.txt', stream)

回报：

AttributeError：“_io.StringIO”对象没有属性“编码”

• 蟒蛇3.7
• 熊猫 0.23.4
• 天蓝色 blob 存储 1.3.1

标签： python-3.xpandasazureazure-blob-storage

Answer 1

这有效：

with io.StringIO() as streamio:
    df.to_csv(streamio, encoding = "utf-8", index=False)
    streamio.seek(0)
    service.create_blob_from_text('containert', 'example.txt', "".join(streamio.readlines()))