Python Automation Course : Automate Mundane Tasks In Python

openpyxl pypdf2, Web scraping, selenium, Beautifulsoup, regular expression, send email, GUI automate , Python Automation

What you'll learn
Learn how to import excel workbook in python
Learn to create and delete worksheet
Read, write individual shell in worksheet
Learn how to manipulate excel functionality through automation
Learn to add image, formula and chart in excel through programming
Manipulate Microsoft word file with docx python module
Read, Parse and write PDF file from python PyPDF2
Learn webscraping with python Beautiful Soup library
Learn reading and writing file, filepath
Requirements
High School Mathematics
Description
==============================================What previous students have said: "The entire course was very well explained.Accessing Excel, word, pdfs using Python was a lot of fun.The Web scraping session was extremely very well explained.Ankit was very responsive to my questions.I would highly recommend any course he teaches.""thank you, Ankit. I learned a lot!"" The content is great and is guide that anyone with little python and Jupyter experience can follow. However, the instructor takes some shortcuts that might make it confusing for a beginner.""Excellent short and sweet explanation by Ankit"==============================================Whole world is moving towards automation. We human build machine to make task automatically.Computer science are mainly the field of automation engineer. And We deal with Excel,Word, PDF file in daily routine. So, do you find any  task mundane or boring and want to automate by writing some programming script.Then this course is for you. In this course, Learn Python Excel - openpyxl library tutorial for beginners and advanced to make your excel related task automated from python. This course teaches you how to read workbook  and read and write Excel file in particular cell of worksheet. How to create new workbook and worksheet. How to add chart, formula, image to excel sheet.How manipulate Microsoft word and .pdf file from python docx, PyPDF2 libraryHow to download webpage and extract content out it with BeautifulSoup libraryWebscraping mini project, count YouTube video views.Play with files and folder, copying and moving file.Browser automation with seleniumModule concept in PythonGUI automation with mouse and keyboardHandling error and exceptionRegular expressionPython basics and advanced moduleThis course provides techniques to deal with MS Excel files from Python, PDF file from python and many task to be automated with python library. This course  is for those  who want make daily routine excel related task automatically.

Overview

Section 1: *******++++++++ PYTHON (NEW) VIDEO ++++++++*********

Lecture 1 IMPORTANT NOTES

Section 2: welcome

Lecture 2 Course Overview

Lecture 3 Course FAQ

Section 3: Programming and Python

Lecture 4 What is programming

Lecture 5 Python Installation

Lecture 6 3. Download and Install Anaconda

Lecture 7 4. Getting started with Spyder IDE

Lecture 8 Python 2 vs Python 3

Lecture 9 Print & Input function

Lecture 10 7. Python programming Introduction

Section 4: Code Download

Lecture 11 Code Download

Section 5: Data Types in Python

Lecture 12 8. Python data Types

Lecture 13 9. Python Numbers

Lecture 14 10. Operator precedence

Lecture 15 11. Python Help

Lecture 16 12. Python Variable

Lecture 17 13. Variable Operations

Section 6: Strings

Lecture 18 14. Introduction to String

Lecture 19 15. String concatenation and Formatting

Lecture 20 16. String Methods

Lecture 21 17. String Indexing - Slicing

Lecture 22 18. String immutability

Section 7: More on Python

Lecture 23 19. Python Boolean Datatype

Lecture 24 20. Python Built in Functions

Lecture 25 21. Python DataType Conversion

Lecture 26 22. Python bin(), hex(), Oct() Number System Conversion

Section 8: Python Collections

Lecture 27 23. Define List DataType

Lecture 28 24. List Indexing - Slicing

Lecture 29 25. List Methods

Lecture 30 26. More about List

Lecture 31 27. Python Tuples

Lecture 32 28. Python Sets

Lecture 33 29. Define Python Dictionary

Lecture 34 30. More on Dictionary

Section 9: Decision making in Python

Lecture 35 32. Ternary Operator

Lecture 36 33. Python truthiness

Lecture 37 31. Conditional Logic

Lecture 38 34. Mathematical & Logical Operator

Lecture 39 35. == vs is in Python

Lecture 40 36. Introduction to Functions

Section 10: Functions

Lecture 41 38. Default Argument and Keyword Argument

Lecture 42 37. Define Function in Python

Lecture 43 39. Return in Function

Lecture 44 40. Function DocString Help

Lecture 45 41. Varible Scope - Global

Section 11: Looping in Python

Lecture 46 42. For Loop introduction

Lecture 47 43. For Loop Iterable Object

Lecture 48 44. enumerate on iterable object

Lecture 49 45. While Loop

Lecture 50 46. Break & Continue

Section 12: Modules

Lecture 51 47. Modules in Python

Lecture 52 48. Packages in Python

Lecture 53 49. Python Built-in Modules

Lecture 54 50. Python PIP package manager

Lecture 55 51. Conda install

Lecture 56 52. Conda Virtual Environment

Section 13: Python error and Debugging

Lecture 57 53. Python Built In Error

Lecture 58 54. Python Error Handling

Lecture 59 55. Python debugger

Section 14: Functional Programming

Lecture 60 56. What is Functional Programming -Pure Function

Lecture 61 57. Map and Filter Function

Lecture 62 58. Zip and Reduce Function

Lecture 63 59. Lambda Expression

Lecture 64 60. List Set Dictionary Comprehension

Section 15: Files and Folders

Lecture 65 61. Files and Folders

Lecture 66 62. Absolute path and Relative path

Lecture 67 63. Files & Folders More on OS Module

Lecture 68 64. Python File Reading

Lecture 69 65. File Writing in Python

Lecture 70 66. Copy and Move with Shutil in Python

Section 16: Python Generators

Lecture 71 67. Python generator - 1

Lecture 72 68. Python generator - 2

Lecture 73 69. Python Generator - 3 Multiple Yield

Lecture 74 70. if __name__ == '__main__' in Python

Section 17: Object Oriented in Python

Lecture 75 71. What is Object Oriented Programming

Lecture 76 72. Define Class and Create and Object in Python

Lecture 77 73. Classes and Object part - 2 Contd…

Lecture 78 74. classmethod and staticmethod

Section 18: Email and SMS with Python

Lecture 79 76. Sending Email with Python

Section 19: Web Scraping

Lecture 80 78. What is Web Scraping

Lecture 81 79. Web Scraping Contd…

Lecture 82 80. Web Scraping HTML Introduction

Lecture 83 81. Web Scraping install requests and BeautifulSoup Library

Lecture 84 82. Web Scraping requests module- Download Webpage

Lecture 85 83. Web Scraping BeautifulSoup

Lecture 86 84. Web Scraping Grage IMDB Moview Name BeautifulSoup

Lecture 87 85. Web Scraping Sorted Data

Lecture 88 86. What Next on Web Scraping

Section 20: Browser Automation

Lecture 89 87. Browser Automation - Introduction

Lecture 90 88. Browser Automation - Python selenium Part -I

Lecture 91 89. Browser Automation - Python selenium Part - II

Section 21: Twitter Bot

Lecture 92 90. Twitter Bot - tweepy - Part I

Lecture 93 91. Twitter Bot - tweepy - Part II

Lecture 94 92. Twitter Bot - tweepy - Part III

Lecture 95 93. Twitter Bot - tweepy - Part IV

Section 22: Imorting Data : Google Sheets

Lecture 96 94. Importing Data From Google Sheets - Part -1

Lecture 97 95. Importing Data From Google Sheets - Part -2

Lecture 98 96. Importing Data From Google Sheets - Part -3

Section 23: Importing Data : Excel File

Lecture 99 97. Import Excel File in Python - openpyxl Module - 1

Lecture 100 98. Import Excel File in Python - openpyxl Module - 2

Lecture 101 99. Import Excel File in Python - openpyxl Module - 3

Lecture 102 100. Import Excel File in Python - openpyxl Module - 4

Lecture 103 101. Import Excel File in Python - openpyxl Module - 5

Section 24: Python + Microsoft .docx File

Lecture 104 docx file

Section 25: Working with PDF Document

Lecture 105 Python PDF

Section 26: CSV and JSON File

Lecture 106 Processing JSON - CSV File

Section 27: Image Processing with Python

Lecture 107 Image Processing

Section 28: Time and Datetime module

Lecture 108 Time module in Python

Lecture 109 datetime module

Lecture 110 Create reminder application

Section 29: Control GUI through Python

Lecture 111 Play with Mouse and Keyboard

Section 30: ******* PYTHON (OLD) VIDEO *******

Lecture 112 IMPORTANT NOTES

Section 31: Python Setup

Lecture 113 Section : Introduction

Lecture 114 1.1 Download and install anaconda

Lecture 115 1.2 Conda virtual environment

Lecture 116 1.3 Getting started with Jupyter notebook

Lecture 117 2.1 Install stand alone Python and IDLE

Lecture 118 2.2 Write and Run Python Code

Section 32: Introduction

Lecture 119 Introduction

Lecture 120 Setup development environment - openpyxl Library

Lecture 121 Download and install anaconda

Lecture 122 Jupyter notebook - Overview

Lecture 123 Code

Section 33: Python Basics

Lecture 124 Numbers & Math operators

Lecture 125 Variables and Datatypes

Lecture 126 Dynamic Typing in Python

Lecture 127 String

Lecture 128 Boolean variable and conditional logic

Lecture 129 List

Lecture 130 List Comprehensions

Lecture 131 Dictionary

Lecture 132 Sets and tuples

Lecture 133 Looping in Python

Section 34: Python Basics -2

Lecture 134 Function - I

Lecture 135 Function - II

Lecture 136 Lambda Expression

Section 35: Module in Python

Lecture 137 Introduction

Lecture 138 What is Module and why require

Lecture 139 Create custom module - 1

Lecture 140 Create Python module - 2 : From command line

Lecture 141 Different ways of importing module

Lecture 142 External module

Section 36: Workbook and Worksheet

Lecture 143 Load excel workbook in python

Lecture 144 Read worksheet

Lecture 145 Create, Delete Worksheet

Lecture 146 Properties of Worksheet

Section 37: Cell of Worksheet

Lecture 147 Read cells, rows and columns of worksheet

Lecture 148 Write, modify cell of worksheet

Lecture 149 Styling cell

Lecture 150 Add Excel formula to cell

Lecture 151 Add image to cell

Lecture 152 Add Bar chart to worksheet

Lecture 153 Merge and unmerge cell

Lecture 154 Add filter on column

Section 38: Practical Activity

Section 39: Automate - .pdf Portable document file

Lecture 155 Read .pdf File

Lecture 156 Create and Write to .pdf file

Section 40: Web Scraping - Download web content and Extract it

Lecture 157 Introduction - Web Scraping

Lecture 158 What is Web Scraping

Lecture 159 Web Scraping Process

Lecture 160 Search Element by TagName and TagByClass

Lecture 161 Practical Activity

Section 41: Webscraping - mini project

Lecture 162 Problem

Lecture 163 Solution

Section 42: Automate Email

Lecture 164 Send Email - SMTP Python Library

Lecture 165 Read Email - IMAP Python library

Section 43: Play with Files and folders

Lecture 166 Files and Folders - 1

Lecture 167 Files and Folders - 2

Lecture 168 File Reading and writing

Lecture 169 Copying, moving files

Section 44: Errors and exception

Lecture 170 Types of error

Lecture 171 Handling exception

Lecture 172 Raise exception and cleaning

Section 45: Browser automation

Lecture 173 Control browser through selenium

Section 46: Regular expression

Lecture 174 String search without Regular expression

Lecture 175 Getting started with Regular expression

Lecture 176 Pipe and repetition of character

Lecture 177 FindAll & Character class

Section 47: GUI automation

Lecture 178 Play with Mouse from Python

Lecture 179 Play with Keyboard from Python

Section 48: Collections module

Lecture 180 Counter

Lecture 181 Default dictionary

Lecture 182 Ordered dictionary

Lecture 183 Namedtuple

Section 49: Python Miscellaneous

Lecture 184 Dealing with datetime and time module

Lecture 185 Command Line argument

Section 50: Special Bonus offer

Lecture 186 Discount for other courses

anyone who knows python programming want automate excel, word, pdf related task from python,anyone who want to learn openpyxl, docx, PyPDF2 python library,anyone who is intersted to enter in world of automation