虚空上的seaborn heatmap pandas计算 [英] seaborn heatmap pandas calculation on isnull

问题描述

生成数据帧的系列计算，以提供NaN占总行数的百分比，如下所示：

producing a series calculation of a dataframe to provide a percentage of NaN's to the total amount of rows as shown:

data = df.isnull().sum()/len(df)*100

RecordID          0.000000
ContactID         0.000000
EmailAddress      0.000000
ExternalID      100.000000
Date              0.000000
Name              0.000000
Owner            67.471362
Priority          0.000000
Status            0.000000
Subject           0.000000
Description       0.000000
Type              0.000000
dtype: float64

我热衷于将其表示为seaborn 中的热图sns.heatmap（data），吸引了100％和67％的读者注意，不幸的是我遇到了这个错误

What I'm keen to do is represent this as a heatmap in seaborn sns.heatmap(data), drawing the readers attention those with 100 and 67%, unfortunately I'm getting this error

IndexError：条件和输入的
之间的形状不一致（得到（12，1）和（12，））

IndexError: Inconsistent shape between the condition and the input (got (12, 1) and (12,))

完整追溯：

---------------------------------------------------------------------------
IndexError                                Traceback (most recent call last)
<ipython-input-17-05db696a3a9b> in <module>()
----> 1 sns.heatmap(data)

~\AppData\Local\Programs\Python\Python36-32\lib\site-packages\seaborn\matrix.py in heatmap(data, vmin, vmax, cmap, center, robust, annot, fmt, annot_kws, linewidths, linecolor, cbar, cbar_kws, cbar_ax, square, xticklabels, yticklabels, mask, ax, **kwargs)
    515     plotter = _HeatMapper(data, vmin, vmax, cmap, center, robust, annot, fmt,
    516                           annot_kws, cbar, cbar_kws, xticklabels,
--> 517                           yticklabels, mask)
    518 
    519     # Add the pcolormesh kwargs here

~\AppData\Local\Programs\Python\Python36-32\lib\site-packages\seaborn\matrix.py in __init__(self, data, vmin, vmax, cmap, center, robust, annot, fmt, annot_kws, cbar, cbar_kws, xticklabels, yticklabels, mask)
    114         mask = _matrix_mask(data, mask)
    115 
--> 116         plot_data = np.ma.masked_where(np.asarray(mask), plot_data)
    117 
    118         # Get good names for the rows and columns

~\AppData\Local\Programs\Python\Python36-32\lib\site-packages\numpy\ma\core.py in masked_where(condition, a, copy)
   1934     if cshape and cshape != ashape:
   1935         raise IndexError("Inconsistent shape between the condition and the input"
-> 1936                          " (got %s and %s)" % (cshape, ashape))
   1937     if hasattr(a, '_mask'):
   1938         cond = mask_or(cond, a._mask)

IndexError: Inconsistent shape between the condition and the input (got (12, 1) and (12,))

我的研究发现，如果围绕numpy广播规则碰壁，或3年前的错误-没有一个超级有用。

My research if hitting a lot of walls around numpy broadcasting rules, or a bug from 3 years ago - none of which are super helpful.

一如既往。

推荐答案

您的 data 变量是 pd.Series 的一个实例，它本质上是一维的。但是，
sns.heatmap 需要2D输入。例如，快速修复方法如下：

Your data variable is an instance of pd.Series which is inherently 1D. However, sns.heatmap expects a 2D input. A quick fix is for example the following:

sns.heatmap(data.to_frame())

这篇关于虚空上的seaborn heatmap pandas计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！