pandas读取数据空值处理，题目详情见正文

yuechuchen

2020-04-30 阅读量: 4379

df表如下：

df表内包含特殊字符，读取df表是需要将特殊字符处理成空值形式，要求读取的数据结果如下：

参考代码：

list1 = [["第一分公司","第二分公司",]
         ,["销售部","市场部","行政部"]]
index = pd.MultiIndex.from_product(list1, names=['公司', '部门'])
df = pd.DataFrame({"姓名":["Allen","Lucy","Tom","Alice","Tim","Lily"],"工龄":np.random.randint(1,5,6)
                  ,"入职日期":["2017-01-30","#","2019-07-21","2020-04-02","-","2017-05-12"]},index = index)
df
df.to_csv('num.csv',index=False)

df = pd.read_csv('num.csv',na_values=['#',"-"])
df

代码结果：