Show dates on seaborn heatmap
Milan Jain
I am trying to create a heat map from pandas dataframe using seaborn library. Here, is the code:
test_df = pd.DataFrame(np.random.randn(367, 5),
index = pd.DatetimeIndex(start='01-01-2000', end='01-01-2001', freq='1D'))
ax = sns.heatmap(test_df.T)
ax.xaxis.set_major_locator(mdates.MonthLocator())
ax.xaxis.set_minor_locator(mdates.DayLocator())
ax.xaxis.set_major_formatter(mdates.DateFormatter('%b'))
ax.xaxis.set_minor_formatter(mdates.DateFormatter('%d'))
However, I am getting a figure with nothing printed on the x-axis.
ImportanceOfBeingErnest
Seaborn heatmap is a categorical plot. It scales from 0 to number of columns - 1, in this case from 0 to 366. The datetime locators and formatters expect values as dates (or more precisely, numbers that correspond to dates). For the year in question that would be numbers between 730120 (= 01-01-2000) and 730486 (= 01-01-2001).
So in order to be able to use matplotlib.dates formatters and locators, you would need to convert your dataframe index to datetime objects first. You can then not use a heatmap, but a plot that allows for numerical axes, e.g. an imshow plot. You may then set the extent of that imshow plot to correspond to the date range you want to show.
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import matplotlib.dates as mdates
df = pd.DataFrame(np.random.randn(367, 5),
index = pd.DatetimeIndex(start='01-01-2000', end='01-01-2001', freq='1D'))
dates = df.index.to_pydatetime()
dnum = mdates.date2num(dates)
start = dnum[0] - (dnum[1]-dnum[0])/2.
stop = dnum[-1] + (dnum[1]-dnum[0])/2.
extent = [start, stop, -0.5, len(df.columns)-0.5]
fig, ax = plt.subplots()
im = ax.imshow(df.T.values, extent=extent, aspect="auto")
ax.xaxis.set_major_locator(mdates.MonthLocator())
ax.xaxis.set_minor_locator(mdates.DayLocator())
ax.xaxis.set_major_formatter(mdates.DateFormatter('%b'))
fig.colorbar(im)
plt.show()
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Laravel select random rows from table based on another field
- Next: JSF 1.2: Too many small session beans: Is it bad and what the alternatives
Related
Related Related
- 1
pandas and seaborn - heatmap with no colors
- 2
Custom Annotation Seaborn Heatmap
- 3
Seaborn Heatmap Key Words
- 4
Seaborn custom range heatmap
- 5
Using seaborn heatmap
- 6
Seaborn heatmap to plotly failed
- 7
Highcharts - display dates in heatmap
- 8
Discrete legend in seaborn heatmap plot
- 9
Seaborn Heatmap Colorbar Label as Percentage
- 10
Seaborn heatmap with variating cell sizes
- 11
Python - Seaborn: Modifying the heatmap legend
- 12
Make the size of a heatmap bigger with seaborn
- 13
change certain squares in a seaborn heatmap
- 14
Lines to separate groups in seaborn heatmap
- 15
Change xticklabels fontsize of seaborn heatmap
- 16
seaborn heatmap using pandas dataframe
- 17
Adding units to heatmap annotation in Seaborn
- 18
Make the size of a heatmap bigger with seaborn
- 19
Lines to separate groups in seaborn heatmap
- 20
Flip over colorbar of Seaborn heatmap
- 21
seaborn.heatmap skips data
- 22
Seaborn FaceGrid + heatmap grey borders
- 23
Relabel axis ticks in seaborn heatmap
- 24
Plot dates with Pandas and Seaborn
- 25
Seaborn Heatmap - Display the heatmap only if values are above given threshold
- 26
Change tick size on colorbar of seaborn heatmap
- 27
How do I add a title to Seaborn Heatmap?
- 28
Changing the size of the heatmap specifically in a seaborn clustermap?
- 29
Changing the rotation of tick labels in Seaborn heatmap
Comments