pandas and azure: DataFrame to_csv blob

Question

I want to store a python pandas DataFrame to Azure, but the solution by Jay Gong (Python 2.7) gives me errors:

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)

Returns:

AttributeError: '_io.StringIO' object has no attribute 'encode'

python 3.7
pandas 0.23.4
azure-blob-storage 1.3.1

Joost Döbken · Accepted Answer · 2021-07-12 13:03:02Z

1

This works:

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()))

edited Jul 12, 2021 at 13:03

answered Oct 30, 2018 at 15:28

Joost Döbken

4,1476 gold badges50 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

pandas and azure: DataFrame to_csv blob

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related