Free Python Course (Usage 4) - Business Automation (RPA)

Say goodbye to repetitive, monotonous tasks! 🖐
Work smarter with Python RPA.

The topic of this lecture is
It's "business automation."

Are you still manually entering data into an Excel file?
Are you doing simple, repetitive tasks manually and taking a long time?
Here's a course for anyone who wants to break free from the daily grind.
Now let's leave the work to the computer and play!!!

The topic of this tutorial is ‘business automation.’
Just because it's called 'business automation' doesn't mean it's only used for business 😆😆
Anything that uses a computer can be automated as long as the rules are clear.
Of course, game macros or fanatic clicks that repeat the same task countless times, such as clicking here and there, are also possible.

But since it was called 'business automation',
I will explain it with a focus on work.
(I'll try to upload game automation videos more often later 😊😊)

Most office workers go to the office, turn on their computers, and do the same thing every day.
It may be different for each person, but I log into a system, check the emails that come to me,
Things like creating Word or Excel documents, writing reports, and sending completion emails to others.

But in this area, there are definitely things that are 'same or similar, repeated' .

I just received a spam text a while ago that said this:

This means that if you post something on a Naver or Daum cafe or blog, you have to pay a fee.
I don't know how the people who actually do this do it, but with automation, you can write a script once and then just click the 'run' button and you can sit back and make money.
(Of course, this is under the condition that you don't get banned from the cafe, your ID isn't cut off, your IP isn't blocked, and you receive the proper payment as promised.)

For example, something like this.

1. Organize the cafe address and bulletin board name where you will post the article in the Excel file.

2. Write an automation script

This is the end.

If you add a cafe list or change the bulletin board name, you only need to change the contents of one Excel file.
The way so-called 'comment part-timers' work is probably not much different.
※ The above content may have the negative effect of causing people to post spam, so I will not use it as an example in the lecture.

Can you give me another example?
You are preparing a large event for a huge audience of 1,000 people.

And then you have to go through the list and make name tags for all these people and print them out.

If you have a PPT file in the given format and the list is as follows,

You will copy the first person's name and paste it into the name section of the PPT file or type it in directly, and do the same for the affiliation and information sections.
After turning to the next page, copy the name of the second person and again...
After turning to the next page, copy the name of the third person and again...

You only need to do this 1,000 times.

But isn't this too wasteful ?

Even if it takes only 20 seconds to make a name tag for one person, it would take a whopping 20,000 seconds, or about 5 hours and 30 minutes, for 1,000 people.
And that was when everything went very smoothly without even going to the bathroom once.

And you're just sitting there with your left pinky on the left Ctrl key and your index finger going back and forth between C and V, copying and pasting.
Anyone who has tried it knows that after doing this for a little while, your hands will really, really hurt.

_{If you're only doing this kind of thing, then run away right now...}

But what if we could automate this task?

Since there is a list in Excel and a PPT with a set format for name tags, you can import data from Excel one line at a time, insert it into each area of the PPT, move to the next page, and repeat this process until the end of the Excel file.

If the PPT file is too large and you are concerned about memory issues, you can split the file into 100-part chunks. If a problem occurs during the process, you can keep a log and run it again starting from the turn after the person who processed it normally.

I created a simple script and tested it, and the time was reduced by about 1/5.

Now all you have to do is slowly sip a cup of warm Americano and watch it do its job.

Isn't it amazing?

When other people are diligently repeating the same task, you can just take a break and add an exclamation of 'hmm...' or 'sseu...' every now and then.

In my lecture, I selected four topics that I believe are essential for business automation , and the main libraries used for each are as follows.

We've tried to make them unrelated, so you can pick and choose the topics you need.
If you mainly use email to exchange work information and deal with the web, you only need to study 3 and 4.
If you use Excel all day, you only need to study it once.

However, if you learn everything as much as possible, I am sure it will be of great help to you someday.
(And the content is not difficult at all compared to the amount of content. ^^)

Let me briefly explain what you will learn by topic and how you can actually apply it.

1. Excel Automation

You can create an Excel file, enter the desired data (or formula) into the desired location, apply cell styles (width and height, font, background color), merge cells, create charts, add images, and more. You can also import an existing file and check the data by simply selecting the required area.

2. Desktop Automation

You can mimic human actions on a PC using a mouse and keyboard. Automation methods can be used with a mix of coordinates, pixels, and images, and can include keyboard input, key combinations like Ctrl+S, mouse movement, clicks, drag-and-drop, and screenshots. You can also use information about running windows to freely maximize, minimize, or bring them to the front. When automating with images, you'll also learn how to increase the success rate of automation by utilizing grayscale and reliability information.

3. Web Automation

By leveraging the popular Selenium, you can analyze HTML content on a browser and perform tasks like clicking, entering text, selecting checkboxes or radio buttons, scrolling, moving between pages, switching frames, and waiting for loading. If you master this, you'll be able to automate most web tasks without much difficulty.

4. Email Automation

You can search your mailbox for specific emails based on conditions such as the date received, sender, subject or body content, and whether they were received. You can then retrieve their contents or download attachments. You can also send emails to multiple recipients at once, including attachments and your own personal message. This lecture will focus on Gmail, and through a project, you'll learn how to utilize this feature in real-world situations.

How is it?

Can you think of any tasks or tasks you do on your computer that could be automated?
If you try to recall, there are definitely parts that you repeat every day out of habit.

But there is one very important thing here.

Computers are simpler than you might think, and to put it bluntly, they're stupid. They just do what they're told ...
So you have to give the computer tasks that can be clearly explained so that it can do them clearly.
You should never say things like, "No, you know, why are you just saying that over there..." like the boss you see on TV.

We will explain in the video what parts you need to pay attention to for each topic ^^
The highlight of my lectures is the practical project.

The above content alone is quite extensive, so I prepared this project a bit shorter.

Let's assume that we are conducting a virtual coding seminar and prepare a situation where we receive application emails in a set format from applicants. Then, we will automatically send emails to some applicants on a first-come, first-served basis through an automated script, informing them that some applicants have been selected and the rest have been eliminated. We will also create an Excel file with the list of winners and use it as an attendance list on the day of the seminar.

This course will be taught using Visual Studio Code . For environment settings, please check the link below!
Go directly to the Nado Coding Python environment settings

If you've learned the basics of Python and want to build your skills, start learning about task automation now.
This one video is enough.
Plus, Nadocoding is “free”.

Designed by Freepik
https://www.freepik.com