python – 熊猫如何替换？使用NaN – 处理非标准缺失值

请帮助我.我曾尝试阅读Pandas文档,但我无法遵循.

def readData(filename):
   DataLabels =["age", "workclass", "fnlwgt", "education", "education-num", "marital-status",
               "occupation", "relationship", "race", "sex", "capital-gain",
               "capital-loss", "hours-per-week", "native-country", "class"] 

   # ==== trying to replace ? with Nan using na_values
   rawfile = pd.read_csv(filename, header=None, names=DataLabels, na_values=["?"])
   age = rawfile["age"]
   print age
   print rawfile[25:40]

   #========trying to replace ?
   rawfile.replace("?", "NaN")
   print rawfile[25:40]

df['workclass'].replace('?', np.NaN)

或整个df：

df.replace('?', np.NaN)

UPDATE

好的我找出了你的问题,默认情况下,如果你没有传递一个分隔符,那么read_csv将使用逗号’,’作为分隔符.

您的数据,特别是您遇到问题的一个示例：

54, ?, 180211, Some-college, 10, Married-civ-spouse, ?, Husband, Asian-Pac-Islander, Male, 0, 0, 60, South, >50K

实际上有一个逗号和一个空格作为分隔符,所以当你传递na_value = [‘？’]时,这并不匹配,因为你所有的值前面都有一个空格字符,你无法观察到它们.

如果你改变你的行：

rawfile = pd.read_csv(filename, header=None, names=DataLabels, sep=',\s', na_values=["?"])

然后你应该发现它一切正常：

27      54               NaN  180211  Some-college             10