• Post category:StudyBullet-7
  • Reading time:4 mins read


Python Automation

What you will learn

Automating data entry using Python programming language

Managing project workflow

Working with Python libraries

Create Windows software using Python

Description

In this course you will learn to automate data entry process using Python programming language. In manual data entry system, client converts each order from excel file to HTML file one by one. It takes approximately 4 minutes to create one HTML file. Considering 8 hours per day of work done, he can create 37440 HTML files in a year. With this automated data entry system he can complete this task within 1 minute.

Creation of this project has an interesting story behind it. One of my student was working in a data entry company. He was tasked to convert each order from excel to HTML file. He showed me his workflow. It took me half an hour to create this software. It completed 1 month of his work in 10 seconds. As a result, he left his job and joined our research lab as an intern.

You will learn to create Python project using Pycharm and Python version 3 and deploy it for Microsoft Windows using Pyinstaller.


Get Instant Notification of New Courses on our Telegram channel.


By taking this course you will learn multiple skills of time management and mathematical logic behind automation. You can use these skills to automate other things by writing few lines of code. All functions and programs are modular and can be used in new projects. After purchasing this course you will get access to complete source code and Windows software. Lifetime updates to this course is included for your convenience.

We will be creating this project from scratch and build it step by step.

English
language

Content

Introduction

Requirement specification
Python setup
Pycharm setup

Create functions

Function to generate html code
Python library to read excel file
Save html code to file
Command line arguments

Validation & Delivery

Validation
Make it dynamic
Final output
Delivery