Create and upload csv file to azure blob storage using python

Question

I am trying to create csv file using python and than to upload that file to azure blob storage. I am able to create csv file, that part works fine, but when I try to upload the file to blob:

blob.upload_blob(data=df.to_csv("capacity.csv",index=False))

I get error message:

Traceback (most recent call last):
  File ".\blob.py", line 94, in <module>
    blob.upload_blob(data=df.to_csv("data.csv",index=False))
  File "C:\Python38\lib\site-packages\azure\core\tracing\decorator.py", line 83, in wrapper_use_tracer    return func(*args, **kwargs)
  File "C:\Python38\lib\site-packages\azure\storage\blob\_blob_client.py", line 489, in upload_blob   
    options = self._upload_blob_options(
  File "C:\Python38\lib\site-packages\azure\storage\blob\_blob_client.py", line 332, in _upload_blob_options
    raise TypeError("Unsupported data type: {}".format(type(data)))
TypeError: Unsupported data type: <class 'NoneType'>

After that I tried to upload some local csv file, just to test if it is working:

with open(path_to_file, "rb") as data:
   blob.upload_blob( data=data)

And it worked. I am not sure what is causing this error, I spent some time looking for solution, but nothing is working for me.

Jonas · Accepted Answer · 2020-07-15 08:08:13Z

2

You are converting a .csv-File to csv again:

blob.upload_blob(data=df.to_csv("capacity.csv",index=False))
                                 ^

But you should convert your DataFrame to csv:

blob.upload_blob(data=df.to_csv(index=False))

edited Jul 15, 2020 at 8:08

answered Jul 13, 2020 at 17:03

Jonas

1,7691 gold badge12 silver badges18 bronze badges

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

2 Comments

Nenad Over a year ago

Thank you bro, you helped me a lot. Your suggestion did not fixed my problem, but you forced me to look again at documentation and than I figured out. Correct approach is: blob.upload_blob(data=df.to_csv(index=False))

Jonas Over a year ago

Good to hear! I fixed it in the solution above.

Collectives™ on Stack Overflow

Create and upload csv file to azure blob storage using python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related