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
