How to plot aggregated by date pandas dataframe?

To plot aggregated by date pandas dataframe, we can take the following steps −


  • Set the figure size and adjust the padding between and around the subplots.

  • Create a data frame, df, of two-dimensional, size-mutable, potentially heterogeneous tabular data.

  • Get the values of aggregated by date pandas dataframe.

  • Plot the df (Step 3) with kind="bar".

  • To display the figure, use show() method.


import numpy as np
import pandas as pd
from matplotlib import pyplot as plt, dates

# Set the figure size
plt.rcParams["figure.figsize"] = [7.50, 3.50]
plt.rcParams["figure.autolayout"] = True

# Create a dataframe
df = pd.DataFrame(dict(data=list(pd.date_range("2021-01-01", periods=10)),
value=np.linspace(1, 10, 10)))
df = df.groupby('data').agg(['sum']).reset_index()

# Plot the dataframe
df.plot(x='data', y='value', kind="bar")

# Display the plot


It will produce the following ouput −

Updated on: 02-Feb-2022

1K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started