========
Cookbook
========

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

Basics
======

* `Creating tables from various data types <cookbook/create.html>`_
* `Saving data to various data types <cookbook/save.html>`_
* `Removing columns from a table <cookbook/remove.html>`_
* `Filtering rows of data <cookbook/filter.html>`_
* `Sorting rows of data <cookbook/sort.html>`_
* `Searching through a table <cookbook/search.html>`_
* `Standardize names and values <cookbook/standardize.html>`_
* `Calculating statistics <cookbook/statistics.html>`_
* `Computing new columns <cookbook/compute.html>`_
* `Handling dates and times <cookbook/datetime.html>`_

Coming from other tools
=======================

* `SQL <cookbook/sql.html>`_
* `Excel <cookbook/excel.html>`_
* `R <cookbook/r.html>`_
* `Underscore.js <cookbook/underscore.html>`_
* Pandas (coming soon!)

Advanced techniques
===================

* `Filling missing rows in a dataset <cookbook/homogenize.html>`_
* `Renaming and reordering columns <cookbook/columns.html>`_
* `Transforming data (pivot/normalize/denormalize) <cookbook/transform.html>`_
* `Setting your locale and working with foreign data <cookbook/locale.html>`_
* `Ranking a sequence of data <cookbook/rank.html>`_
* `Creating simple charts <cookbook/charting.html>`_
* `Mapping columns to common lookup tables <cookbook/lookup.html>`_

Have a common use case that isn't covered? Please `submit an issue <https://github.com/wireservice/agate/issues/new>`_ on the GitHub repository.