I have a pandas dataframe below containing some events and a counter that I am looking for to build and comment on event data in a chart:
Date Time Time Zone Currency Event Importance Actual Forecast Previous Count Volume
DateTime
2014-04-09 00:30:00 Wed Apr 9 00:30 GMT aud AUD Westpac Consumer Confidence Medium 0.3% NaN -0.7% 198 7739
2014-04-09 00:30:00 Wed Apr 9 00:30 GMT aud AUD Westpac Consumer Conf Index Low 99.7 NaN 99.5 198 7279
2014-04-09 01:30:00 Wed Apr 9 01:30 GMT aud AUD Investment Lending Low 4.4% NaN -3.7% 172 21297
2014-04-09 01:30:00 Wed Apr 9 01:30 GMT aud AUD Home Loans Medium 2.3% 1.5% 0.0% 172 22197
2014-04-09 01:30:00 Wed Apr 9 01:30 GMT aud AUD Value of Loans (MoM) Low 1.9% NaN 1.6% 172 22197
I use the code below to build a dataframe (df):
import matplotlib.pyplot as plt
import matplotlib.dates as mdates
temp=df[df['Count'].notnull()]
x = temp.index
y = temp.Count
z = temp.Event
g = temp.Importance
v = temp.Volume
fig, ax = plt.subplots(figsize=(15,8))
ax.plot_date(x, y, linestyle='--')
for i in range(len(x)):
if g[i]=="Medium":
ax.annotate(z[i]+' '+'Volume: '+str(v[i]), (mdates.date2num(x[i]), y[i]), xytext=(15, 15),
textcoords='offset points', arrowprops=dict(arrowstyle='-|>'))
fig.autofmt_xdate()
plt.show()
Since the data frame contains duplicate-datetime - indexes, annotated text appears overlapping:
Is there a better way to show this?
Possible solution: I think I managed to get a good plot by randomizing the xytext values
ax.annotate(z[i]+' '+'Volume: '+str(v[i]), (mdates.date2num(x[i]), y[i]), xytext=(5+randint(1,50), 5+randint(1,50)),
textcoords='offset points', arrowprops=dict(arrowstyle='-|>'), rotation=0)