如何在Great Table中处理inf和nans

Question

我有一个数据表，里面有一些无穷大（inf）和缺失值（nan），我想把它格式化一下。

它的字典结构是：

df = pd.DataFrame({'Foodbank': {0: 'study',
  1: 'generation',
  2: 'near',
  3: 'sell',
  4: 'former',
  5: 'line',
  6: 'ok',
  7: 'field',
  8: 'last',
  9: 'really',
  10: 'particularly',
  11: 'must',
  12: 'drive',
  13: 'herself',
  14: 'learn'},
 '%(LY)': {0: -20.93,
  1: -19.23,
  2: -26.09,
  3: 150.0,
  4: 90.24,
  5: -23.85,
  6: nan,
  7: inf,
  8: inf,
  9: inf,
  10: inf,
  11: -35.48,
  12: nan,
  13: nan,
  14: -1.3}})

from great_tables import GT
GT(df)

看起来是这样的：

我想把无穷大（inf）替换成一个短横线或者“n/a”，这样观众看了会更明白，而不是看到无穷大这个词。

Answer 1

一个可能的解决方案：

df['%(LY)'] = df['%(LY)'].replace(np.inf, np.nan)

输出结果：

        Foodbank   %(LY)
0          study  -20.93
1     generation  -19.23
2           near  -26.09
3           sell  150.00
4         former   90.24
5           line  -23.85
6             ok     NaN
7          field     NaN
8           last     NaN
9         really     NaN
10  particularly     NaN
11          must  -35.48
12         drive     NaN
13       herself     NaN
14         learn   -1.30