Python Automation

4.

Working with Common Data Formats

4.1.

Plain Text Files

4.1.1.

4.1.1.1.

4.1.1.2.

Encoding Considerations

4.1.2.

Reading from Files

4.1.2.1.

Reading Entire Files

4.1.2.2.

Reading Line by Line

4.1.2.3.

Reading Specific Amounts

4.1.3.

Writing to Files

4.1.3.1.

Overwriting Files

4.1.3.2.

Appending to Files

4.1.3.3.

Writing Multiple Lines

4.1.4.

File Context Managers

4.1.4.1.

Using with Statements

4.1.4.2.

Automatic File Closing

4.1.5.

4.1.6.

Handling Large Files

4.2.

4.2.1.

Understanding CSV Format

4.2.2.

4.2.3.

Reading CSV Data

4.2.3.1.

4.2.3.2.

Reading Rows as Lists

4.2.3.3.

Handling Headers

4.2.3.4.

Custom Delimiters

4.2.3.5.

Handling Quotes and Escaping

4.2.4.

Writing CSV Data

4.2.4.1.

4.2.4.2.

4.2.4.3.

Writing Headers

4.2.4.4.

Custom Delimiters and Quoting

4.2.5.

Dictionary-Based CSV Operations

4.2.5.1.

4.2.5.2.

4.2.5.3.

Working with Column Names

4.2.6.

Handling CSV Dialects

4.2.7.

Error Handling in CSV Processing

4.3.

4.3.1.

Understanding JSON Format

4.3.2.

The json Module

4.3.3.

Reading JSON Data

4.3.3.1.

json.load for Files

4.3.3.2.

json.loads for Strings

4.3.3.3.

Handling JSON Arrays and Objects

4.3.4.

Writing JSON Data

4.3.4.1.

json.dump for Files

4.3.4.2.

json.dumps for Strings

4.3.4.3.

Formatting and Indentation

4.3.4.4.

4.3.5.

Handling Complex Data Types

4.3.5.1.

Custom Serialization

4.3.5.2.

Date and Time Objects

4.3.6.

JSON Schema Validation

4.3.7.

Error Handling in JSON Processing

4.4.

Excel Spreadsheets

4.4.1.

Understanding Excel File Formats

4.4.2.

The openpyxl Library

4.4.2.1.

Installing openpyxl

4.4.2.2.

Opening Workbooks

4.4.2.3.

Accessing Worksheets

4.4.2.4.

Reading Cell Values

4.4.2.5.

Reading Ranges of Cells

4.4.2.6.

Writing Data to Cells

4.4.2.7.

Creating New Worksheets

4.4.2.8.

Creating New Workbooks

4.4.2.9.

Modifying Cell Formatting

4.4.2.10.

Working with Formulas

4.4.2.11.

Saving Workbooks

4.4.2.12.

Closing Workbooks

4.4.3.

Alternative Libraries

4.4.3.1.

xlrd for Reading

4.4.3.2.

xlwt for Writing

4.4.3.3.

pandas for Data Analysis

4.5.

4.5.1.

Understanding PDF Structure

4.5.2.

The PyPDF2 Library

4.5.2.1.

Installing PyPDF2

4.5.2.2.

Opening PDF Files

4.5.2.3.

Extracting Text from Pages

4.5.2.4.

Extracting Metadata

4.5.2.5.

Merging PDF Files

4.5.2.6.

Splitting PDF Documents

4.5.2.7.

4.5.2.8.

Adding Watermarks

4.5.3.

Alternative PDF Libraries

4.5.3.1.

4.5.3.2.

4.5.4.

Limitations of PDF Text Extraction

4.6.

4.6.1.

Understanding Word Document Structure

4.6.2.

The python-docx Library

4.6.2.1.

Installing python-docx

4.6.2.2.

Opening Documents

4.6.2.3.

Reading Document Content

4.6.2.3.1.

4.6.2.3.2.

4.6.2.3.3.

4.6.2.4.

4.6.2.4.1.

4.6.2.4.2.

4.6.2.4.3.

4.6.2.4.4.

4.6.2.4.5.

4.6.2.5.

Modifying Formatting

4.6.2.6.

Creating New Documents

4.6.2.7.

Saving Documents

4.6.3.

Working with Document Properties

4.6.4.

Handling Document Styles

Previous

3. Automating File and Directory Operations

Go to top

Next

5. Web Automation and Scraping