Useful pandas Recipes

This is my collection of useful pandas recipes.

Recipes by category

• Select Data
  • Choose Columns
  • Choose Rows
    • Top and Bottom Rows
    • Range of Rows
    • Filter Rows
    • Duplicates
  • Missing Data

• Sorting

• Transform
  • Split Column
    • By Delimiter
    • By Number of Characters
    • By Positions
    • By Lowercase to Uppercase
    • By Uppercase to Lowercase
    • By Digit to Non-Digit
    • By Non-Digit to Digit
  • Group By
  • Data Type
  • Headers
  • Replace Values
• Combine
  • Merge
  • Concat
• Transform
  • Basic
    • Transpose
    • Rename
  • Table
    • Group By
    • Headers
    • Transpose
    • Reverse Rows
  • Any Columns
    • Data Type
    • Rename
    • Replace Values

    • Replace Errors

    • Fill Down
    • Fill Up
    • Unpivot Column (Melt)
    • Pivot Column
    • Move
  • Text Column
    • Split Column
    • Format
    • Merge Columns
    • Extract
• Add Column
  • Custom Column
  • Invoke Custom Function
  • Conditional Column
  • Index Column

  • Duplicate Column

  • Text Column
    • Format
    • Merge Columns
    • Extract