1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
========
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.
|
