Pages

Topics

Tools

↑↓navigate↵openescclose

Python guides

Every published Python guide, newest first, with practical examples you can copy into your own project.

3,965 guides across 14 topics

Topics

Latest Python guides

A pandas DataFrame with a PyArrow arrow symbol representing the backend integration, emphasizing speed and memory efficiency.
Python

pandas PyArrow Backend: A Practical Guide

Learn how to enable the pandas PyArrow backend, understand the data type changes, and decide when it improves performance and memory use.

pandaspyarrowdataframeperformance
Illustration of Parquet file blocks being compressed by a press, with a balance scale showing the tradeoff between speed and file size.
Python

PyArrow Parquet Compression for Files and Datasets

Configure PyArrow Parquet compression for single files and datasets, compare snappy, zstd, and gzip codecs, and choose the right codec for your workload.

pyarrowparquetcompressiondatasets
A visual representation of reading and writing Parquet files with PyArrow in Python, showing a columnar table and file I/O arrows.
Python

Python PyArrow: Read and Write Parquet Files

A practical guide to reading and writing Parquet files with PyArrow in Python, covering schema control, row group access, partitioning, compression, and memory considerations.

pyarrowparquetdata engineeringcolumnar storage
Diagram comparing PyArrow Table and pandas DataFrame memory layouts, showing shared buffers and copied columns.
Python

PyArrow Tables and pandas: Memory and Integration

How PyArrow Tables and pandas DataFrames convert to each other, when conversion copies memory, and how to structure pipelines to avoid repeated allocation.

pyarrowpandasdataframesmemory management
A split illustration comparing the Python libraries xlsxwriter and openpyxl for Excel file generation, showing a stream of data on one side and an editable workbook on the other.
Python

python xlsxwriter vs openpyxl: Choosing the Right Excel Library

python xlsxwriter vs openpyxl: Compare xlsxwriter and openpyxl for Python Excel workflows: API design, performance, formatting, and when to use each.

xlsxwriteropenpyxlExcelPython
Stylized spreadsheet with green and red highlighted cells next to a blue column chart, representing XlsxWriter conditional formatting and charts.
Python

Python XlsxWriter Charts and Conditional Formatting

Use Python XlsxWriter to add Excel charts and conditional formatting to reports. Covers cell rules, data bars, formula rules, chart series, and combining both features.

XlsxWriterExcel automationconditional formattingdata visualization
Python XlsxWriter workbook with multiple sheets, formatted cells, and formula bar visible
Python

Python XlsxWriter Formatting Formulas and Multiple Sheets

python xlsxwriter formatting formulas and multiple sheets: Learn to combine formatting, formulas, and multiple sheets in Python XlsxWriter to build professional Excel...

xlsxwriterexcelpythonspreadsheet
Illustration of a pandas DataFrame being written into an Excel spreadsheet using XlsxWriter, with a gear icon representing the engine.
Python

Python XlsxWriter: Create Excel and Write Pandas DataFrame

How to use XlsxWriter with pandas to write DataFrames to Excel, format columns and cells, create multi-sheet workbooks, and avoid common export pitfalls.

XlsxWriterpandasExcelDataFrame
Comparison of openpyxl and xlsxwriter for Python Excel writing, showing two library logos with a spreadsheet background.
Python

openpyxl vs xlsxwriter in Python: Choosing the Right Excel Library

Compare openpyxl and xlsxwriter for creating Excel files in Python. Learn their read/write capabilities, memory behavior, and how to choose the right library for your workflow.

openpyxlxlsxwriterExcelPython libraries
Illustration of a large Excel spreadsheet being processed by Python with streaming arrows showing memory-efficient handling.
Python

Handling Large Excel Files with Python and openpyxl

Stream large Excel files with Python openpyxl using read-only and write-only modes, iterators, and memory-aware patterns.

openpyxlExcelperformancememory