Discretization and quantiling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 509 9.6 Function application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . SQLAlchemy (GH2717, GH4163, GH5950, GH6292). All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included dialects). The drivers for each SQL dialect in the SQLAlchemy docs. Some common drivers are: – psycopg2: for PostgreSQL – pymysql: for MySQL. – SQLite: for SQLite, this is included in Python’s standard library by

Discretization and quantiling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 507 9.6 Function application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . SQLAlchemy (GH2717, GH4163, GH5950, GH6292). All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included dialects). The drivers for each SQL dialect in the SQLAlchemy docs. Some common drivers are: – psycopg2: for PostgreSQL – pymysql: for MySQL. – SQLite: for SQLite, this is included in Python’s standard library by

Discretization and quantiling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 535 9.6 Function application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . SQLAlchemy (GH2717, GH4163, GH5950, GH6292). All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included dialects). The drivers for each SQL dialect in the SQLAlchemy docs. Some common drivers are: – psycopg2: for PostgreSQL – pymysql: for MySQL. – SQLite: for SQLite, this is included in Python’s standard library by

statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209 9.6 Function application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . SQLAlchemy (GH2717, GH4163, GH5950, GH6292). All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included dialects). The Chapter 9. Essential Basic Functionality pandas: powerful Python data analysis toolkit, Release 0.14.0 9.6 Function application Arbitrary functions can be applied along the axes of a DataFrame or Panel using

statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 279 9.6 Function application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . SQLAlchemy (GH2717, GH4163, GH5950, GH6292). All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included dialects). The inf], (-inf, 0], (-inf, 0], (0, inf]] Length: 20 Categories (2, object): [(-inf, 0] < (0, inf]] 9.6 Function application Arbitrary functions can be applied along the axes of a DataFrame or Panel using

statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 271 9.6 Function application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . SQLAlchemy (GH2717, GH4163, GH5950, GH6292). All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included dialects). The inf], (-inf, 0], (-inf, 0], (0, inf]] Length: 20 Categories (2, object): [(-inf, 0] < (0, inf]] 9.6 Function application Arbitrary functions can be applied along the axes of a DataFrame or Panel using

Hierarchical indexing (MultiIndex) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 196 9.6 Adding an index to an existing DataFrame . . . . . . . . . . . . . . . . . . . . . . . . . . . . . from_arrays ensure that this is true, but if you compute the levels and labels yourself, please be careful. 9.6 Adding an index to an existing DataFrame Occasionally you will load or create a data set into a DataFrame new object): In [248]: data.set_index(’c’, drop=False) a b c d c z bar one z 1 y bar two y 2 9.6. Adding an index to an existing DataFrame 207 pandas: powerful Python data analysis toolkit, Release

statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 182 9.6 Function application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . (-inf, 0] (0, inf] (-inf, 0] Levels (2): Index([’(-inf, 0]’, ’(0, inf]’], dtype=object) Length: 20 9.6 Function application Arbitrary functions can be applied along the axes of a DataFrame or Panel using [4 rows x 3 columns] In [111]: df.apply(np.exp) Out[111]: one three two a 0.495907 NaN 0.916583 9.6. Function application 189 pandas: powerful Python data analysis toolkit, Release 0.13.1 b 1.115534

openpyxl 2.4.8 Reading / writing for xlsx files pandas-gbq 0.8.0 Google Big Query access psycopg2 PostgreSQL engine for sqlalchemy pyarrow 0.9.0 Parquet and feather reading / writing pymysql 0.7.11 MySQL addition you will need a driver library for your database. Examples of such drivers are psycopg2 for PostgreSQL or pymysql for MySQL. For SQLite this is included in Pythons standard library by default. You can Database SQL Datetime Types Timezone Support SQLite TEXT No MySQL TIMESTAMP or DATETIME No PostgreSQL TIMESTAMP or TIMESTAMP WITH TIME ZONE Yes When writing timezone aware data to databases that do

openpyxl 2.5.7 Reading / writing for xlsx files pandas-gbq 0.8.0 Google Big Query access psycopg2 PostgreSQL engine for sqlalchemy pyarrow 0.12.0 Parquet, ORC (requires 0.13.0), and feather reading / writing addition you will need a driver library for your database. Examples of such drivers are psycopg2 for PostgreSQL or pymysql for MySQL. For SQLite this is included in Python’s standard library by default. You Database SQL Datetime Types Timezone Support SQLite TEXT No MySQL TIMESTAMP or DATETIME No PostgreSQL TIMESTAMP or TIMESTAMP WITH TIME ZONE Yes When writing timezone aware data to databases that do