English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 4 Hours | 1.10 GB
Manipute routine Excel, word, pdf, HTML (Web scraping) related task from python by automation – Beautifulsoup, openpyxl
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 library
- How to download webpage and extract content out it with BeautifulSoup library
- Webscraping mini project, count YouTube video views.
- Play with files and folder, copying and moving file.
- Browser automation with selenium
- Module concept in Python
- GUI automation with mouse and keyboard
- Handling error and exception
This course provides techniques to deal with MS Excel files from Python. This course is for those who want make daily routine excel related task automatically.
Table of Contents
Introduction
1 Introduction
2 Setup development environment – openpyxl Library
Workbook and Worksheet
3 Load excel workbook in python
4 Read worksheet
5 Create Delete Worksheet
6 Properties of Worksheet
attached files
Cell of Worksheet
7 Read cells rows and columns of worksheet
8 Write modify cell of worksheet
9 Styling cell
10 Add Excel formula to cell
11 Add image to cell
12 Add Bar chart to worksheet
13 Merge and unmerge cell
14 Add filter on column
Automate – Microsoft .docx Document file
15 Introduction – Document file
16 Read .docx file – python-docx
17 Write to .docx file
Automate – .pdf Portable document file
18 Read .pdf File
19 Create and Write to .pdf file
Web Scraping – Download web content and Extract it
20 Introduction – Web Scraping
21 What is Web Scraping
22 Web Scraping Process
23 Search Element by TagName and TagByClass
24 Practical Activity
Webscraping – mini project
25 Problem
26 Solution
Automate Email
27 Send Email – SMTP Python Library
28 Read Email – IMAP Python library
Play with Files and folders
29 Files and Folders – 1
30 Files and Folders – 2
31 File Reading and writing
32 Copying moving files
Errors and exception
33 Types of error
34 Handling exception
35 Raise exception and cleaning
Browser automation
36 Control browser through selenium
GUI automation
37 Play with Mouse from Python
38 Play with Keyboard from Python
Collections module
39 Counter
40 Default dictionary
41 Ordered dictionary
42 Namedtuple
Modules in Python
43 Create Python module
Special Bonus offer
44 Discount for other courses
Resolve the captcha to access the links!