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
Видео Automate Excel with Python Tutorial (2020) канала Davide Merlin
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
Видео Automate Excel with Python Tutorial (2020) канала Davide Merlin
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to Use SQL with Excel using Python](https://i.ytimg.com/vi/71zkSuzkJrw/default.jpg)
![Python Tutorial - Python for Beginners [2020]](https://i.ytimg.com/vi/kqtD5dpn9C8/default.jpg)
![Map two excel worksheets using Python - Five Minute Python Automation Scripts](https://i.ytimg.com/vi/OB_ixIlQbWI/default.jpg)
![I Coded A Trading Bot And Gave It $1000 To Trade!](https://i.ytimg.com/vi/-MHhA-Y3DSk/default.jpg)
![Top 18 Most Useful Python Modules](https://i.ytimg.com/vi/Vi9Y9AL13Rc/default.jpg)
![Automating LIFE with Python](https://i.ytimg.com/vi/eWBXqjG9X0w/default.jpg)
![15 Python Projects in Under 15 Minutes (Code Included)](https://i.ytimg.com/vi/OXi4T58PwdM/default.jpg)
![Automate Multiple Sheet Excel Reporting - Python Automation Tutorial | Full Code Walk Through (2019)](https://i.ytimg.com/vi/1Kcco6koC34/default.jpg)
![Python to Replace VBA in Excel](https://i.ytimg.com/vi/ubqsRcCUcB4/default.jpg)
![Automate Pivot Tables and Charts with Python | Excel Automation Hacks](https://i.ytimg.com/vi/FO1xbO70pnY/default.jpg)
![Complete Python Pandas Data Science Tutorial! (Reading CSV/Excel files, Sorting, Filtering, Groupby)](https://i.ytimg.com/vi/vmEHCJofslg/default.jpg)
![Python As Fast as Possible - Learn Python in ~75 Minutes](https://i.ytimg.com/vi/VchuKL44s6E/default.jpg)
![Learn Python the Right Way in 5 Steps in 2020](https://i.ytimg.com/vi/_5LhYsKpOOA/default.jpg)
![What Can You Do with Python? - The 3 Main Applications](https://i.ytimg.com/vi/kLZuut1fYzQ/default.jpg)
![Intro to Data Analysis / Visualization with Python, Matplotlib and Pandas | Matplotlib Tutorial](https://i.ytimg.com/vi/a9UrKTVEeZA/default.jpg)
![Super quick Python automation ideas](https://i.ytimg.com/vi/qbW6FRbaSl0/default.jpg)
![How To Execute A Python Script From Excel Using VBA | Step-by-Step Tutorial [EASY]](https://i.ytimg.com/vi/MgL9IOCFZ0U/default.jpg)
![Schedule and Automate Your Excel Data Analytics with Python](https://i.ytimg.com/vi/On4bL4tSZzg/default.jpg)
![10 Python Tips and Tricks For Writing Better Code](https://i.ytimg.com/vi/C-gEQdGVXbk/default.jpg)
![Excel vs. Python with Pandas - 5 Transformations You Need to Know | Python Tutorial](https://i.ytimg.com/vi/p42e8NBnrGI/default.jpg)