agate
1.6.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
  • Docs »
  • 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.

Next Previous

© Copyright 2017, Christopher Groskopf

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