seaborn plotting with datetime object

Question

I don't know why everytime when i plot with seaborn it's always showing all the date object as below.
I have already checked my "join_date" is an object rather than datetime.
Do anyone know what's the problem and how can I fix it?

Answer 1

One solution could be that you can modify the datetime object before plotting using to_period method. Here is an example:

import pandas as pd
import seaborn as sns
import matplotlib.pyplot as plt

#generating some test data
days = pd.date_range('1/1/2000', periods=8, freq='D')
d2 = dict({'price': [10, 11, 9, 13, 14, 18, 17, 19]})
df = pd.DataFrame(d2,index=days)
print(df)

#making join_date a datetime object
#df['join_date'] = pd.to_datetime(df['join_date'])

#setting join_date as index of the dataframe
#df.set_index(['join_date'],inplace=True)

#reducing the datetime object assuming the datetime is index and it is in pandas datetime format
df.index = df.index.to_period("D") 

#plotting the heatmap
sns.heatmap(data=df)
plt.tight_layout()
plt.show()

Original Outout:

Final Outout after using to_period: