Plotting Two Time Series with Pandas

Time series data is prevalent in various fields such as finance, meteorology, and healthcare. Analyzing and visualizing multiple time series simultaneously can provide valuable insights into relationships, trends, and patterns. Pandas, a powerful Python library for data manipulation and analysis, offers convenient tools for plotting multiple time series. In this blog post, we will explore how to use Pandas to plot two time series, covering core concepts, typical usage methods, common practices, and best practices.

Table of Contents#

  1. Core Concepts
  2. Typical Usage Method
  3. Common Practices
  4. Best Practices
  5. Code Examples
  6. Conclusion
  7. FAQ
  8. References

Core Concepts#

Time Series#

A time series is a sequence of data points indexed in time order. In Pandas, time series data is typically represented using a DatetimeIndex. This index allows for efficient indexing, slicing, and resampling of time series data.

Plotting#

Pandas provides a high - level interface for plotting data using the plot() method. When plotting two time series, we can use this method to create a single plot that displays both series, allowing for easy comparison.

Axes#

In Matplotlib (the underlying plotting library used by Pandas), an Axes object represents the area where the data is plotted. When plotting two time series, we can use the same Axes object to overlay the plots, or we can use separate Axes objects to create subplots.

Typical Usage Method#

  1. Import Libraries: Import Pandas and Matplotlib.
  2. Prepare Data: Create or load time series data with a DatetimeIndex.
  3. Plot Data: Use the plot() method on the Pandas DataFrame or Series to plot the time series.
  4. Customize Plot: Add labels, titles, legends, and other visual elements to enhance the plot.

Common Practices#

Overlaying Plots#

Overlaying two time series on the same plot allows for direct comparison. This can be done by plotting the first series and then using the same Axes object to plot the second series.

Using Subplots#

If the two time series have different scales or units, it may be better to use subplots. Subplots allow each time series to have its own Axes object, which can have its own scale and axis labels.

Adding Legends#

Legends are essential for distinguishing between the two time series in the plot. Pandas automatically adds a legend when plotting multiple series, but it can be customized for better clarity.

Best Practices#

Data Cleaning#

Before plotting, ensure that the time series data is clean and free of missing values. Missing values can cause gaps in the plot or lead to incorrect visualizations.

Normalization#

If the two time series have different scales, normalizing the data can make the comparison more meaningful. Normalization can be done using various methods such as min - max scaling or z - score normalization.

Use Appropriate Plot Types#

Depending on the nature of the data, choose the appropriate plot type. For time series data, line plots are commonly used, but other types such as scatter plots or bar plots may also be suitable in some cases.

Code Examples#

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
 
# Generate sample time series data
date_rng = pd.date_range(start='2020-01-01', end='2020-12-31', freq='D')
ts1 = pd.Series(np.random.randn(len(date_rng)), index=date_rng)
ts2 = pd.Series(np.random.randn(len(date_rng)), index=date_rng)
 
# Combine the two series into a DataFrame
df = pd.DataFrame({'Series 1': ts1, 'Series 2': ts2})
 
# Overlaying plots
plt.figure(figsize=(10, 6))
df.plot(ax=plt.gca())  # gca() gets the current Axes
plt.title('Overlaying Two Time Series')
plt.xlabel('Date')
plt.ylabel('Value')
plt.legend()
plt.show()
 
# Using subplots
fig, axes = plt.subplots(2, 1, figsize=(10, 12))
df['Series 1'].plot(ax=axes[0])
axes[0].set_title('Series 1')
axes[0].set_ylabel('Value')
df['Series 2'].plot(ax=axes[1])
axes[1].set_title('Series 2')
axes[1].set_xlabel('Date')
axes[1].set_ylabel('Value')
plt.show()

Conclusion#

Plotting two time series with Pandas is a straightforward process that can provide valuable insights into the relationship between the two series. By understanding the core concepts, using the typical usage methods, following common and best practices, and leveraging the provided code examples, intermediate - to - advanced Python developers can effectively visualize and analyze multiple time series in real - world situations.

FAQ#

Q: Can I plot more than two time series?#

A: Yes, you can plot multiple time series by including them in the same DataFrame and using the plot() method. Pandas will automatically handle the plotting of all the series in the DataFrame.

Q: How can I change the color of the lines in the plot?#

A: You can specify the color of the lines using the color parameter in the plot() method. For example, df.plot(color=['red', 'blue']) will plot the first series in red and the second series in blue.

Q: What if my time series data has different frequencies?#

A: You can resample the data to a common frequency before plotting. Pandas provides the resample() method for this purpose.

References#

2025-10