Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Python Automation Scripting and Regular Expressions
01 Work with text files
01 Create And Read A New Text File (6:29)
02 Read And Write A Text File With A Loop (7:14)
03 Copy Contents Of A File (4:05)
Source files
02 Work with csv files
01 Print Csv Contents (4:25)
02 Print Csv As List (3:00)
03 Create A Csv File (3:35)
Source files
03 Work with json files
01 Read And Write To A Json File (3:15)
Source files
04 Work with Excel files
01 Inspect Excel Sheets (5:07)
02 Merge Excel Files (13:45)
03 Get Value From Cell In Excel Sheet (7:12)
04 Display Entire Excel Sheet Contents (3:48)
05 Create A New Excel File With Values (2:35)
Source files
05 Automate files with OS Module
02 Check If File Or Directory Path Exists (3:03)
01 Find A File By Name (3:17)
03 List All Files And Directories At A Path (2:51)
04 Find All Files Of Given Type (2:56)
05 Delete Old Files With Datetime Module (6:24)
06 Bulk Rename Files (4:54)
Source files
06 Work with exceptions
01 Handle Exceptions (4:21)
02 Use Asserts (3:24)
Source files
07 Search documents for words
01 Search Txt File (4:14)
02 Search Csv File (2:12)
Source files
08 Format data
01 Format Data Into Table (6:31)
02 Visualize Product Sales Per Quarter (9:37)
Source files
09 Search through data with regex
01 Search For String In Text (2:34)
02 Find Characters By Type (2:49)
Source files
10 Find expressions that match conditions
01 Find Words Of Specific Length Starting With Specific Letter (8:17)
02 Find Expression Containing Numbers And Symbols In A Specific Format (4:23)
03 Find Expression Of A Specific Format (5:10)
04 Search Ignoring Capitalization (1:19)
05 Find Words At Beginning Or End Of Line (3:45)
06 Find Independent Words (2:34)
Source Files
11 Search for anomalies
01 Find Repeating Characters (3:47)
02 Search For Multiple Expressions At Once (7:59)
03 Make A Dictionary Of Expressions Found (4:05)
Source files
12 Data manipulation with regex
01 Remove Whitespaces (2:57)
02 Split String On Word (3:29)
Source files
01 Create And Read A New Text File
Complete and Continue