2024-10-27 –, CLASS #3 - 4C
Language: English
We all love python. But not all of us is fortunate enough to land a job as a python programmer or developer. Maybe some of us currently doing some office jobs that is not using python and doesn't need programming language at all. But it doesn't make our python skill useless. As an open-source programming language python has a lot of library that can make our life easier. In this talk we will explore some of python library and try to use it to do our office job faster and give more time for us to rest.
In this talk we will learn about python library that are available and can help us to do our job faster as an office worker. For each topic there will be some explanation about the library, how to use, and some example of their implementation. I will mainly introduce three topics/libraries we can do using our python skill:
- GUI Automation using PyAutoGUI
In this topic we will learn how to manipulate mouse and keyboard input so we can complete repetitive task involving GUI program. - Web Scraping using BeautifulSoup or Selenium
In this topic we will learn how to scrape or gather information from webpages in a fast way. - Excel Manipulation using Openpyxl or Pandas
Lastly, in this topic we will learn how to process data in excel especially in large data that needs complex formula.
Hopefully after attending this session we can still love and use our python skill even though we are not working as a programmer.
Text