Python Pandas – 检查并显示无穷大的行索引
要检查和显示行索引，请使用isinf()withany()。首先，让我们使用各自的别名导入所需的库-
import pandas as pd import numpy as np
创建一个列表字典。我们使用Numpynp.inf设置了无穷大值-
d = { "Reg_Price": [7000.5057, np.inf, 5000, np.inf, 9000.75768, 6000, 900, np.inf] }从上面的列表字典创建DataFrame-
dataFrame = pd.DataFrame(d)
获取具有无穷大值的行索引-
indexNum = dataFrame.index[np.isinf(dataFrame).any(1)]
示例
以下是代码-
import pandas as pd
import numpy as np
#列表字典
d = { "Reg_Price": [7000.5057, np.inf, 5000, np.inf, 9000.75768, 6000, 900, np.inf] }
#从上面的列表字典创建数据框
dataFrame = pd.DataFrame(d)
print"DataFrame...\n",dataFrame
#检查无限值并显示计数
count = np.isinf(dataFrame).values.sum()
print"\nInfinity values count...\n ",count
#获取具有无穷大值的行索引
indexNum = dataFrame.index[np.isinf(dataFrame).any(1)]
print"\nDisplay row indexes with infinite values...\n ",indexNum输出结果这将产生以下输出-
DataFrame...
Reg_Price
0 7000.505700
1 inf
2 5000.000000
3 inf
4 9000.757680
5 6000.000000
6 900.000000
7 inf
Infinity values count...
3
Display row indexes with infinite values...
Int64Index([1, 3, 7], dtype='int64')