World's Best AI Learning Platform with profoundly Demanding Certification Programs
Designed by IITians, only for AI Learners.
Download our e-book of Introduction To Python
Related Blog
Top Discussion
+256704300651- Psychic lost love Spell Caster // Divorce Spell // Marriage Proposal +256704300651 == WASHINGTON DC// TOP DEATH SPELLS @POWERFUL REVENGE DEATH SPELL CASTER IN USA,CANADA, UK, CALIFONIA, MEXICO, IRELAND, NY, CANADA, LONDON, SWEDEN, BOTSWANA Exception Type: JSONDecodeError at /update/ Exception Value: Expecting value: line 1 column 1 (char 0) How can I write Python code to change a date string from "mm/dd/yy hh: mm" format to "YYYY-MM-DD HH: mm" format? ((+256704300651}} INSTANT DEATH SPELL CASTER / REVENGE SPELL/ VOODOO A SPELL CASTER/╬ ₩௹]+256704300651₩௹]╬MAMA ZAMIE A TRADITIONAL HEALER /SANGOMA AND A SPIRITUAL HEALER in BELGIUM, +256704300651.. === Revenge Death spells caster In Denmark / Sweden / Germany / spell caster, revenge spell, spell caster review, witchcraft, psychic, magic forum. ↩⁜↪ +91-9352799565↩⁜↪ Divorce Problem Solution IN mumbai Join Discussion
Top Courses
Master's In Artificial Intelligence Job Guarantee Program
4.5 (1,292 Ratings)
559 Learners
Webinars
Why You Should Learn Data Science in 2023?
Jun 8th (7:00 PM) 289 Registered
How to create CSV file in azure blob using python.
Shashank Shanu
3 years ago
Many times,
you want your data to be saved in CSV format for future use. But working on
some cloud platform such AWS, Azure and GCP you may don’t know how you can save
your data into CSV file so that you may use it locally. Today in this article,
I will try to explain to you how we can create a CSV file in azure blob using
python. So, let’s start.
# Import Library
from azure.storage.blob import BlockBlobService
import pandas as pd
import tables
In the above
code, we are importing the required libraries. In the first line of code, we are
importing BlockBlobService from azure storage blob. And then we are import
pandas which are used for data manipulation works and tables to create a table.
with BytesIO() as input_blob:
with BytesIO() as output_blob:
block_blob_service = BlockBlobService(account_name='STORAGEACCOUNTNAME', account_key='STORAGEACCOUNTKEY')
In the above
code, we are creating BlockBlobService object which takes account_name and
account_key as a parameter and then we are saving it to a variable name
block_blob_service.
# Download as a stream
block_blob_service.get_blob_to_stream('STORAGEACCOUNTNAME', 'History.csv', input_blob)
With the
above piece of code, we are downloading the previously created blob object as a
stream with the azure .get_blob_to_stream() function. It takes storage
account name, dataset and input blob.
# Do whatever you want to do - here I am just copying the input stream to the output stream
df=pd.read_csv('blobstorageurl/swxbotcontainer/History.csv')
df=df.append(pd.DataFrame([["How to update password","john@gmail.com","John"]],columns=['User Query','Email','User Name']))
df.to_csv('History.csv',index=false)
#df_b = df.to_string()
In the above
code, here we are just copying the input stream to the output stream with the help of pandas library.
First, we
are reading the data using .read_csv() function of pandas library. In the next
step, we are appending some data in the data frame. For saving the data frame into
a CSV file we use .to_csv() function of python which saves data frame into a CSV
file format.
#block_blob_service.create_blob_from_csv('STORAGEACCOUNTNAME', 'History.csv', df)
block_blob_service.create_blob_from_path('STORAGEACCOUNTNAME','History.csv','History.csv',content_settings=ContentSettings(content_type='application/CSV'))
In the above code, with the help of .create_blob_from_path() which is used to
creates a new blob from a file path, or updates the content of an existing
blob, with automatic chunking and progress notifications.
I hope after you enjoyed reading this article and finally,
you came to know about How to create CSV file in azure blob using python.
For more such blogs/courses on data science, machine
learning, artificial intelligence and emerging new technologies do visit us at InsideAIML.
Thanks for reading…
Happy Programming…