Home Machine learning ARTIFICIAL INTELLIGENCE Automate Excel with Python Tutorial (2020)

Automate Excel with Python Tutorial (2020)


In this video, I will show you some ways through which you can automate your excel workbooks. Python is known to be an excellent programming language for automation. It has many libraries that can help you manipulate data very easily. Two of my favorites are openpyxl and pandas. I will show you how we can effectively use them to retrieve information, merge, search and filter data, and compute operations in excel. Let me know if you’d like to see any automation ideas in the next videos.

Github repository: https://github.com/DavideMerlin/Excel_Automation

Automate the boring stuff with Python: https://automatetheboringstuff.com/chapter12/

More about Pandas Dataframes: https://pandas.pydata.org/pandas-docs/stable/user_guide/dsintro.html#dataframe

Automating Life in Python: https://www.youtube.com/watch?v=eWBXqjG9X0w&t=126s

#Python #Automation

00:00 Intro
00:57 Get values from different workbooks
2:52 Merge workbooks
4:39 Search and filter data in workbooks
6:02 Apply formulas across workbooks
7:00 Outro

Useful Links:
▶ Github: https://github.com/DavideMerlin
▶ Instagram: https://www.instagram.com/davidemerlin97
▶ Twitter: https://twitter.com/merlin_davide



Please enter your comment!
Please enter your name here