Intro to Pandas and Plotting¶

Abstract: This is a short tutorial to motivate usage of Pandas and demonstrates some basic functionality for working with time series. Previous knowledge of Numpy and Matplotlib is assumed. See also: https://pandas.pydata.org/docs/getting_started/10min.html We show various plots, including basic time series statistics and error intervals.

%load_ext watermark
%watermark -i -v -p pandas,matplotlib

Python implementation: CPython
Python version       : 3.9.7
IPython version      : 8.0.1

pandas    : 1.4.1
matplotlib: 3.5.1

import numpy as np
import pandas as pd
import matplotlib.pyplot as plt

Organising data¶

Suppose we run an experiment with two variables, x and y. We could store these data as two numpy arrays assigned to variables x and y:

# Generate a sinusoidal signal with random noise
x = np.linspace(-2*np.pi, 2*np.pi, 744)
y = np.sin(x) + 0.5*np.random.rand(len(x))
print(x[:3], "...")
print(y[:3], "...")

[-6.28318531 -6.26627229 -6.24935928] ...
[0.48622412 0.23666147 0.40472818] ...

To manipulate our data (e.g plotting), we must pass both of these variables around

def plot_data_1(x, y):
    fig, ax = plt.subplots()
    ax.plot(x, y)
    ax.set_xlabel("x")
    ax.set_ylabel("y")
    return fig, ax

plot_data_1(x,y);

../_images/01b1_Pandas-and-Plots_6_0.png

This is manageable as there are only two variables, but if we were to add more variables to our collection (e.g. other concurrent measurements), or if we wanted to store extra information about each variable, this would rapidly become annoying to handle.

To organise the variables better, we could assign them to a dictionary, d. Now we only have to pass one object to our plotting function. We also use the key names in the dictionary to describe our data (in this case, just x and y).

d = {"x": x, "y": y}
print("x:", d["x"][:3], "...")
print("y:", d["y"][:3], "...")

x: [-6.28318531 -6.26627229 -6.24935928] ...
y: [0.48622412 0.23666147 0.40472818] ...

def plot_data_2(d, xvar="x", yvar="y"):
    fig, ax = plt.subplots()
    ax.plot(d[xvar], d[yvar])
    ax.set_xlabel(xvar)
    ax.set_ylabel(yvar)
    return fig, ax

plot_data_2(d);

../_images/01b1_Pandas-and-Plots_9_0.png

We could go on like this, adding new measurements to this dictionary, and defining different datasets (including their various measurements) as different dictionaries. But there is a better way.

Working with dataframes¶

The pandas.DataFrame organises tabular data and provides convenient tools for computation and visualisation. Dataframes act much like a spreadsheet (or a SQL database) and are inspired partly by the R programming language. They consist of columns (here, we named them x and y), and rows. Each column should contain the same number of elements, and each row refers to some related measurements. Dataframes also have an index which identifies the rows - in our case they have just been labelled as integers that match the indexes in the original input arrays.

Pandas comes with many I/O tools to load dataframes. We can also create one from a dictionary:

df = pd.DataFrame.from_dict(d)
df

	x	y
0	-6.283185	0.486224
1	-6.266272	0.236661
2	-6.249359	0.404728
3	-6.232446	0.062275
4	-6.215533	0.226075
...	...	...
739	6.215533	0.122516
740	6.232446	0.069946
741	6.249359	0.035381
742	6.266272	0.405618
743	6.283185	0.411746

744 rows × 2 columns

There is an underlying Numpy array that can be accessed through the .values property:

df.values[:5, :]

array([[-6.28318531,  0.48622412],
       [-6.26627229,  0.23666147],
       [-6.24935928,  0.40472818],
       [-6.23244626,  0.06227467],
       [-6.21553324,  0.2260752 ]])

We can still extract the separate arrays (x and y) similar to interacting with a dictionary:

type(df["x"].values)

numpy.ndarray

We can append new data to the dataframe just like appending a variable to a dictionary. The new data should be the same length as the dataframe, but if a constant is supplied then that is used for every row:

df["y_error"] = 0.3

Some of the real advantages of using Pandas come when we employ a more useful index. If our measurements are taken at different times, we can set the index as a time-aware object. This uses the Pandas DatetimeIndex which is related to the datetime standard library

# Generate some sample times at hourly intervals over a month
df["time"] = pd.date_range("2020-01-01", "2020-02-01", periods=745, inclusive="left")
df = df.set_index("time")
df

	x	y	y_error
time
2020-01-01 00:00:00	-6.283185	0.486224	0.3
2020-01-01 01:00:00	-6.266272	0.236661	0.3
2020-01-01 02:00:00	-6.249359	0.404728	0.3
2020-01-01 03:00:00	-6.232446	0.062275	0.3
2020-01-01 04:00:00	-6.215533	0.226075	0.3
...	...	...	...
2020-01-31 19:00:00	6.215533	0.122516	0.3
2020-01-31 20:00:00	6.232446	0.069946	0.3
2020-01-31 21:00:00	6.249359	0.035381	0.3
2020-01-31 22:00:00	6.266272	0.405618	0.3
2020-01-31 23:00:00	6.283185	0.411746	0.3

744 rows × 3 columns

type(df.index)

pandas.core.indexes.datetimes.DatetimeIndex

It is reasonable to use dataframes to contain your data, use it for easily reading and writing to files, and to apply Numpy-based transformations and other computation, together with plotting routines using Matplotlib. However there are also many ways to use Pandas for manipulating data which are not covered here.

Below we show a few basic ways to plot time series.

Plotting with dataframes¶

We can use the .plot() method to access the Pandas plotting API which itself creates Matplotlib objects. This mechanism is rather complex but enables many convenient shortcuts to creating complex figures.

df.plot()

<AxesSubplot:xlabel='time'>

../_images/01b1_Pandas-and-Plots_23_1.png

It takes some time to get familiar with this API but after that it becomes very useful for rapid feedback and iteration while playing with data, particularly in combination with Jupyter notebooks.

df.plot(y="y")

<AxesSubplot:xlabel='time'>

../_images/01b1_Pandas-and-Plots_25_1.png

Let’s try some things to better visualise this time series.

We can use the resampling system to change the data from hourly samples to daily samples based on the mean of the measurements taken each day. We can directly feed the derived dataframe into a plotting command.

df.resample("1d")

<pandas.core.resample.DatetimeIndexResampler object at 0x7fa8d1008760>

df.resample("1d").mean().plot(y="y")

<AxesSubplot:xlabel='time'>

../_images/01b1_Pandas-and-Plots_28_1.png

A related method is rolling calculations:

df.rolling(24).mean().plot(y="y")

<AxesSubplot:xlabel='time'>

../_images/01b1_Pandas-and-Plots_30_1.png

For more, see e.g. https://ourcodingclub.github.io/2019/01/07/pandas-time-series.html

Rather than just creating the plot straight away as above, we can instead instantiate a Matplotlib axes, and then direct Pandas to plot onto it. This enables some more flexible configuration, like plotting aspects from two dataframes onto one axes:

fig, ax = plt.subplots()
df.plot(y="y", ax=ax)
df.rolling(24, center=True).mean().plot(y="y", ax=ax, label="y-smoothed")

<AxesSubplot:xlabel='time'>

../_images/01b1_Pandas-and-Plots_32_1.png

As an example of the more configurable plotting options through .plot(), let’s show the error bars on measurements. To make them visible, we first subselect down to only every 24th measurement using .iloc.

df.iloc[::24].plot(x="x", y="y", kind="scatter", yerr="y_error")

<AxesSubplot:xlabel='x', ylabel='y'>

../_images/01b1_Pandas-and-Plots_34_1.png

Beware! If we had resampled the dataframe like in the previous steps, the resampling logic would also have applied to the y_error column. You would instead need to supply the correct error propagation mechanism yourself.

Note that we had to resort to plotting against the “x” data instead of the index (time) because of a limitation in what the “scatter” option can do. Plotting against the index is not supported - this could be worked around by creating an extra column to use: df["time"] = df.index. Another option is to create the plot ourselves using the Matplotlib API:

_df = df.iloc[::24]
fig, ax = plt.subplots(figsize=(12, 3))
ax.errorbar(_df.index, _df["y"], yerr=_df["y_error"], marker="o")
ax.set_ylabel("y")
ax.set_xlabel("time");

../_images/01b1_Pandas-and-Plots_36_0.png

Above, we subsampled the data in order to create a clear visualisation with vertical error bars. To show the error intervals on the original data it is better to shade the area with fill_between:

fig, ax = plt.subplots(figsize=(12, 3))
x = df.index
y = df["y"]
y1 = y - df["y_error"]
y2 = y + df["y_error"]
ax.plot(x, y)
ax.fill_between(x, y1, y2, color="grey")
ax.set_ylabel("y")
ax.set_xlabel("time");

../_images/01b1_Pandas-and-Plots_38_0.png

Rather than using the provided error values, we might choose to plot the spread in the data itself. In the example below we create a new df_daily dataframe that contains the daily means and standard deviations of measurements. We use these to plot the mean and spread in the measurements.

def plot_daily_means(df, ax):
    df_daily = (
        df.resample("1d").mean()
        .drop(columns=["x", "y_error"])
        .rename(columns={"y": "y_mean"}))
    df_daily["y_std"] = df["y"].resample("1d").std()

    ax.plot(df_daily.index, df_daily["y_mean"])
    ax.fill_between(
        df_daily.index,
        df_daily["y_mean"] - df_daily["y_std"],
        df_daily["y_mean"] + df_daily["y_std"],
        color="lightgrey")
    ax.set_ylabel("y");

fig, ax = plt.subplots(figsize=(12, 3))
plot_daily_means(df, ax)

../_images/01b1_Pandas-and-Plots_40_0.png

When we create a figure like this, it is useful to define the plotting routine as a function that applies to a Matplotlib Axes object. This way we can control the figure setup (geometry, other plots etc.) separately from the detailed plotting commands. The figure can be manipulated more cleanly in this way. Other subplots can be easily combined into one figure, or other configurations applied: for example, we might later add on grid lines without modifying the original plotting code:

ax.grid(True)
fig

../_images/01b1_Pandas-and-Plots_42_0.png

Customising figures¶

We can continue modifying the figure above since we still have access to the fig and ax objects which contain the figure. Roughly speaking, the fig object (figure) can be considered as the page on which we are drawing, and the ax object (axes) refers to the particular subplot (though in this case, there is only one plot).

Let’s update the display of the plot and redraw it:

We can get matplotlib to directly render $\LaTeX$ elements for us by using the $...$ pattern
set_xlabel, set_ylabel, set_title let us update the labels in place
set_ylim controls the lower and upper limits on the y axis

ax.set_xlabel("Time")
ax.set_ylabel("$Mystery^2 + \sqrt{Intrigue}$")
ax.set_title("Analysis #42")
ax.set_ylim((-1.5, 1.5))
fig

../_images/01b1_Pandas-and-Plots_44_0.png

Aeolus Notebooks

Intro to Pandas and Plotting

Contents

Intro to Pandas and Plotting¶

Organising data¶

Working with dataframes¶

Plotting with dataframes¶

Customising figures¶

To xarray¶