For office workers enslaved by repetitive tasks, or for current or recent college graduates, zero-basic students are advised to start with our free Python course

This course covers Python programming language, Office automation, and file processing automation. Learning Python office automation, the society is the Python programming language in this era, the most effective tools for using Python programming repetitive, error-prone, a large number of the original work, boring work automation, freed themselves and the department of labor, do real work, enjoy programming brought their work efficiency, save the working time, Take your work to the next level. To master Python Office Automation, you just need to record the workflow of the work scene you are in, convert it into an algorithm flow, and realize it with Python programming. Python can control Office and automatically complete all tasks you assign, and 100% error free, and efficiently complete the work in 7×24 hours. Help promote your career. Siege of the lion

How to use Excel with the Python extension library xlwings during 课时1: how to use Excel with the Python extension library xlwings during 课时2: how to use Excel with the Python extension library xlwings during 课时2: how to use Excel with the Python extension library xlwings during 课时3: how to use Excel with the Python extension library xlwings during 课时2: how to use Excel with the Python extension library xlwings Introduction to the Python extension library xlwings 07:16 课时4 video how to install the Python extension library xlwings for example 16:18 课时5 video xlwings for example 06:38 课时6 video Xlwings extension library practice (1) — create worksheet connections 11:44 课时7 video xlwings extension library practice (2) — get worksheet objects and read/write data 06:43 课时8 video xlwings extension library practice (3) — clear content and get set row height and column width 06:48 课时9 video Xlwings extension library practice (4) — get, set and clear background color 07:06 课时10 video xlwings extension library practice (5) — write and get formula 03:53 课时11 video 2.9 xlwings extension library practice (6) — batch write and read data 08:30 The xlwings library is used for analyzing data in pandas. The library is used for analyzing data in pandas. The library is used for analyzing data in Pandas The xlwings library and its Library for data visualization are designed to be used in the library 14:34 Chapter 3: Case Study: The Python library is used for data analysis and processing. The library is used for data analysis and processing Lesson 20 Video data analysis and split Excel case code implementation (2) 10:22 Chapter 4: Data analysis, split Excel and insert picture report 课时22 video data analysis, split Excel case analysis and code implementation (I) 23:50 课时23 video data analysis, split Excel case analysis and code implementation (ii) 10:10 课时24 video Python extension library matplotlib visual library use explanation 12:24 Insert picture report into each split Excel table case analysis and code implementation Combining all worksheets in a workbook (video) Merging all worksheets in a workbook (Video) Merging All worksheets in a workbook (Video) Merging All worksheets in a workbook (Video 课时29 课时29 课时29 video merging all worksheets in a workbook case implementation Combining the first worksheet in multiple workbooks (algorithm design 课时33 课时33 解 决 方法 和 解 决 方法 和 解 决 方法 36:49 课时36 课时36 video merge all worksheets in multiple workbooks application – to other similar cases 16:29 课时37 code implementation and handling of complex and extreme cases in video merging (selected content) 20:21 chapter 8: automated file processing: Class 38 video batch add prefix to filename case explanation and implementation 08:02 can be seen class 39 video batch add suffix to filename case explanation and implementation 07:16 class 40 video batch modify filename case explanation and implementation 06:44 Chapter 9: Get all or specific files and folders under a folder Lesson 41 Video get the names of all files under a folder case explanation and implementation 14:27 lesson 42 Video get the names of all files under a folder and its subfolders case explanation and implementation 15:52 lesson 43 video Get the name of a specific file in a folder and its subfolders case Study and Implementation 16:33 Chapter 10:Word — Using the Python extension library Python docx Lesson 44 Video Python How to install the python docx extension library — Create a blank document and save it Lesson 47 video extension libraries python – docx field (2) – edit existing documents 04:26 48 video class extensions library python – docx field – add a paragraph (3) and batch 07:36 generated file 49 video class extensions library python – docx field (four) – add title and add a page break 04:30 50 video class extensions library python – docx field (5), inserted into the table 08:52 51 video class extensions library python – docx field (6) – insert form 04:01 with style Lesson 52 video extension libraries python – docx field (7), insert images 05:59 53 video class extensions library python – docx field (8) – set style and paragraph alignment 06:51 课时55 课时55 教 程 55 课时55 教 程 55 教 程 python-docx 教 程 (10) set paragraph spacing, line spacing, and paragraph 分 钟 课时57 课时57 video extension library python-docx: how to set the font style and font size The contract will be written in a large number of words. The contract will be written in a large number of words. The contract will be written in a large number of words How to use the Python extension Library PDfPlumber to read Pdf text and store it in a Word file How to use the PdfPlumber to access PDF forms and store them in Excel files Split PDF – Split each page of a PDF file into separate pdF11 :16 课 本 64 video Cases Split PDF – Split each PAGE of a PDF file into specific PDF files as required Merge PDF — Merge multiple PDF files into one PDF file 12:22 Chapter 13:Email –Python Email Automation lecture 66 Video Email –Python Email Automation 09:00 课时68 课时68 video mail automation — using Python extension library yagmail to automatically send emails Win10 task planner 14:16 chapter 14: Lesson 72 The Definition and Use of video Classes 03:42 课 堂 73 Private and public members of video classes 07:07 课 程 74 Video Class Members and Object Members 05:25 课 程 75 Video Member Methods 15:31 课 程 76 Video Member Properties 08:25 课 程 77 Video Class and object dynamics, mixing mechanisms 14:14 课 程 78 Video Python inheritance and polymorphism 14:04 课时80 课时80 video on special methods and operators in Python Lesson 81 video Python exception concepts 09:25 课时82 video Python exception structure 05:56 课时83 video Python exception structure demo 04:37 课时84 video assertion and context management module 03:08 课时85 课时86 课时 16ython file handling 课时87 video Python file handling 26:47 课时88 video Python file handling (0-5)22:53 Class 89 video Python files of actual combat (6), read and write the Json data format 28:46 class 90 video Python files of actual combat CSV format (7) -, speaking, reading and writing data length to class 91 video Python files of actual combat (8) – binary file 08:19 pickle, speaking, reading and writing 课时93 课时93 课时94 课时93 课时94 课时 课时96 课时96 video Python database development 34:17 课时96 video Python database development (zero) — batch create 500 Excel files 11:51 课时98 课时98 课时 how to import 500 Excel files into a database Basic knowledge of Python web crawler 18:14 课时100 课时 intensive introduction of Python web crawler case — average monthly rent per square meter of administrative areas in jinan (homechape 54:34 课时101 课时 Python web crawler case data processing and visualization 18:55 Chapter 20ython Data Analysis and Visualization Case Studies lesson 102 Video Into the world of data analysis and visualization 31:58 Lesson 103 Video Analysis and visualization — West Africa Ebola Epidemic data Analysis and visualization 30:55 Global COVID-19 data Analysis and Visualization (1) — Realizing dynamic data visualization (2) — Mapping the global epidemic in batches