Databricks - Read multiple excel sheets dynamically into a single PySpark Dataframe

Published: 01 November 2024
on channel: Apostolos Athanasiou
1,377
29

In this video we see how to use the openpyxl library to read multiple excel sheets and combine the data into one PySpark dataframe.

You can find the Databricks Notebooks here:
https://github.com/apostolos1927/Read...

Follow me on social media:
LinkedIn: www.linkedin.com/in/apostolos-athanasiou-9a0baa119
GitHub: https://github.com/apostolos1927/

00:00 - Intro
01:10 - Read Excel dynamically


On this page of the site you can watch the video online Databricks - Read multiple excel sheets dynamically into a single PySpark Dataframe with a duration of hours minute second in good quality, which was uploaded by the user Apostolos Athanasiou 01 November 2024, share the link with friends and acquaintances, this video has already been watched 1,377 times on youtube and it was liked by 29 viewers. Enjoy your viewing!