+- Forum Rockoldies (https://rockoldies.net/forum)
+-- Forum: Fotobearbeitung - Photoshop (https://rockoldies.net/forum/forumdisplay.php?fid=16)
+--- Forum: E-Learning, Tutorials (https://rockoldies.net/forum/forumdisplay.php?fid=18)
+--- Thema: Python Automation Course : Automate Mundane Tasks In Python (/showthread.php?tid=62325)
Python Automation Course : Automate Mundane Tasks In Python - Panter - 03.11.2022
![[Bild: oehkctxyanqdkxose50ji2pc3n.jpg]](https://abload.de/img/oehkctxyanqdkxose50ji2pc3n.jpg)
Python Automation Course : Automate Mundane Tasks In Python
Last updated 5/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 8.72 GB | Duration: 21h 7m
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
![[Bild: pythonautomationcoursk1epo.jpg]](https://abload.de/img/pythonautomationcoursk1epo.jpg)
Download from RapidGator
Download from Rapidgator:
Download from DDownload