6 Merge, join, and concatenate

pandas provides various facilities for easily combining together Series, DataFrame, and Panel objects with various kinds of set logic for the indexes and relational algebra functionality in the case of join / merge-type operations.

In [1]: import numpy as np

In [2]: np.random.seed(123456)

In [3]: import pandas as pd

In [4]: pd.options.display.max_rows=15

In [5]: randn = np.random.randn

In [6]: np.set_printoptions(precision=4, suppress=True)

In [7]: import matplotlib.pyplot as plt

In [8]: plt.close('all')

In [9]: import pandas.util.doctools as doctools

In [10]: p = doctools.TablePlotter()