Master comprehensive techniques for reading Excel files with various structures and formats.

📋 Learning Objectives

  • Read single and multiple sheets efficiently
  • Handle different data types and formats
  • Read specific rows, columns, and ranges
  • Work with headers and custom indices
  • Use openpyxl for direct cell access
  • Handle common reading errors

📚 Topics Covered

  1. Reading Single Sheets - Basic reading with pandas - Specifying sheet names and indices - Handling headers and column names

  2. Reading Multiple Sheets - Reading all sheets at once - Processing multiple sheets in loops - Combining data from multiple sheets

  3. Reading Specific Ranges - Reading specific rows and columns - Using usecols and skiprows parameters - Reading cell ranges with openpyxl

  4. Handling Data Types - Specifying data types explicitly - Converting data types after reading - Handling dates and times

  5. Working with Headers - Files with and without headers - Multi-level headers - Custom column names

  6. Advanced Reading Techniques - Reading large files efficiently - Memory optimization - Reading with formulas preserved

📖 Materials

  • 02_reading_excel.md - Theory and explanations
  • 02_reading_excel.py - Executable examples
  • 02_reading_excel.ipynb - Interactive notebook
  • exercises/ - Practice exercises
  • sample_files/ - Various Excel file structures

Next Session

Session 3: Writing Excel Files - Learn to create and write Excel files with various formats and structures.