Feb 10 • Technical
Load Excel file to Files area of lakehouse
I am using a notebook to load an Excel file (downloaded from a website) into a folder in the Files area of a lakehouse - I thought this would be pretty straightforward, but I must be missing something:
from datetime import datetime
import pandas as pd
url = "https://<url_of_excel_file"
output_path = "Files/sales_targets/" + datetime.now().strftime("%Y%m%d")
# load Excel file from URL and replace spaces in column names
df = pd.read_excel(url)
df.columns = df.columns.str.replace(' ','')
# create directory if it doesn't exist
mssparkutils.fs.mkdirs(output_path)
df.to_excel(output_path + "/targets.xlsx")
Is df.to_excel the correct method here, or should I be using PySpark instead?
3
7 comments
Load Excel file to Files area of lakehouse
skool.com/microsoft-fabric
Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.
Leaderboard (30-day)
1
+33
2
+24
3
+19
4
+15
5
+13
Powered by