agate
1.7.1
  • About agate
  • Installation
  • Tutorial
  • Cookbook
    • Creating tables
    • Save a table
    • Remove columns
    • Filter rows
    • Sort
    • Search
    • Standardize names and values
    • Statistics
    • Compute new values
    • Dates and times
    • Emulate SQL
    • Emulate Excel
    • Emulate R
    • Emulate underscore.js
    • Homogenize rows
    • Renaming and reordering columns
    • Transform
    • Locales
    • Rank
    • Charts
    • Lookup
    • Basics
    • Coming from other tools
    • Advanced techniques
  • Extensions
  • API
  • Contributing
  • Release process
  • License
  • Changelog
agate
  • Cookbook
  • View page source

Cookbook¶

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

Basics¶

  • 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

Coming from other tools¶

  • SQL

  • Excel

  • R

  • Underscore.js

  • Pandas (coming soon!)

Advanced techniques¶

  • 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.

Previous Next

© Copyright 2023, Christopher Groskopf.

Built with Sphinx using a theme provided by Read the Docs.