Welcome to the agate cookbook, a source of how-to's and use cases.

.. toctree::
    :hidden:
    :maxdepth: 2

    cookbook/create
    cookbook/save
    cookbook/remove
    cookbook/filter
    cookbook/sort
    cookbook/search
    cookbook/standardize
    cookbook/statistics
    cookbook/compute
    cookbook/datetime
    cookbook/sql
    cookbook/excel
    cookbook/r
    cookbook/underscore
    cookbook/homogenize
    cookbook/columns
    cookbook/transform
    cookbook/locale
    cookbook/rank
    cookbook/charting
    cookbook/lookup

• Creating tables from various data types
• Saving data to various data types
• Removing columns from a table
• Filtering rows of data
• Sorting rows of data
• Searching through a table
• Standardize names and values
• Calculating statistics
• Computing new columns
• Handling dates and times

• SQL
• Excel
• R
• Underscore.js
• Pandas (coming soon!)

• Filling missing rows in a dataset
• Renaming and reordering columns
• Transforming data (pivot/normalize/denormalize)
• Setting your locale and working with foreign data
• Ranking a sequence of data
• Creating simple charts
• Mapping columns to common lookup tables

Have a common use case that isn't covered? Please submit an issue on the GitHub repository.