Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,559 questions
pandas df write to adls as excel file
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 59%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mohammedsadamusean
6
Reputation points
How to insert the pandas dataframe into adls as excel file from the azure databricks , while trying it i could see the error as protocol not known abfss
Azure Data Lake Storage
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,495 questions
{count} vote
-
PRADEEPCHEEKATLA 90,626 Reputation points Moderator2023-01-03T05:58:33.513+00:00 Hello @Mohammedsadamusean ,
Could you please share the code snippet which you are using along with the error message which you are experiencing?
-
Mohammedsadamusean 6 Reputation points
2023-01-04T09:09:15.34+00:00 import pandas as pd
from openpyxl.workbook import workbook
writer=pd.ExcelWriter('abfss://******@adls02datahubqa01.dfs.core.windows.net/result/final.csvpandasdf.to_excel(writer,"marks")
-
PRADEEPCHEEKATLA 90,626 Reputation points Moderator
2023-01-05T06:28:37.237+00:00 Hello @Mohammedsadamusean ,
Thanks for sharing the code. Kindly share the stack trace of the error message which you are experiencing or screenshot?
-
Mohammedsadamusean 6 Reputation points
2023-01-05T07:30:55.843+00:00 Protocol not known abfss
-
PRADEEPCHEEKATLA 90,626 Reputation points Moderator
2023-01-10T06:20:41.68+00:00 Hello @Mohammedsadamusean ,
Kindly share the stack trace of the error message which you are experiencing or screenshot?
Sign in to comment
Sign in to answer