Formatting index of a pandas table in a plot

Question

I am trying to annotate my plot with part of a dataframe. However, the time 00:00:00 is appearing in all the row labels. Is there a clean way to remove them since my data is daily in frequency? I have tried the normalize function but that doesn't remove the time; it just zeroes the time.

Here is what the issue looks like and the sample code to reproduce the issue.

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
from pandas.tools.plotting import table

# Setup of mock data
date_range = pd.date_range('2014-01-01', '2015-01-01', freq='MS')
df = pd.DataFrame({'Values': np.random.rand(0, 10, len(date_range))}, index=date_range)

# The plotting of the table
fig7 = plt.figure()
ax10 = plt.subplot2grid((1, 1), (0, 0))
table(ax10, np.round(df.tail(5), 2), loc='center', colWidths=[0.1] * 2)
fig7.show()

Nickil Maveli · Accepted Answer · 2016-12-30 15:34:02Z

1

Simply access the .date attribute of the DateTimeIndex so that every individual element of your index would be represented in datetime.date format.

The default DateTimeIndex format is datetime.datetime which gets defined automatically even if you didn't explicitly define your index that way before.

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
from pandas.tools.plotting import table   

np.random.seed(42)
# Setup of mock data
date_range = pd.date_range('2014-01-01', '2015-01-01', freq='MS')
df = pd.DataFrame({'Values': np.random.rand(len(date_range))}, date_range)
df.index = df.index.date                                   # <------  only change here

# The plotting of the table
fig7 = plt.figure()
ax10 = plt.subplot2grid((1, 1), (0, 0))
table(ax10, np.round(df.tail(5), 2), loc='center', colWidths=[0.1] * 2)
fig7.show()

edited Dec 30, 2016 at 15:34

answered Dec 30, 2016 at 15:28

Nickil Maveli

29.8k10 gold badges86 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Formatting index of a pandas table in a plot

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related