Excel to Python

Automation is the ultimate solution to break free from the tedium of repetitive data processing tasks. With a plethora of tools to automate almost all the possible operations related to Excel, this tutorial will explore the capabilities of Python that makes it a powerful tool when working with Excel files or data in general.

Python libraries and frameworks give data scientists a foundation on which they can create data analysis workflows, build apps, and develop machine learning systems that support enterprise data strategies at scale. We’ve curated the top Python tools data scientists can use to power the projects that have a lasting impact on their organization.

Plotly Community Manager, Adam Schroeder, transforms historical data into a powerful dashboard using only one Python file, without updating code whenever new data comes in.

Learn how the hours you’ve spent learning Excel may be more helpful than you ever imagined in learning Python. Plotly Community member and founder of DiKayo Data, Danielle Oberdier, starts with an xlsx file from The City of New Orleans and uses openpyxl to seamlessly link to Python code.

Watch this recorded technical workshop with Mingo Sanchez, Senior Sales Engineer at Plotly, to learn how to take your reporting workflows to the next level with Python and Dash.