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
05 Delete Old Files With Datetime Module
Lesson content will be unlocked within 30 minutes.
Teachable is working on this bug.
No further action will be required on your part
.
Thank you for your patience