pandas_test.py 文件源码

def replace_test():
    #???

    df = pd.read_excel("huatai2.xls")
    s1 = pd.Series(['a', 'b', 'c', 'd', 'e'])
    #print s1
    s2 = pd.Series(['1', '2', '3', '4', '5'])
    #print s2

    s3 = s1.replace(1, 'k')
    #print s1
    #print s3
    print df
    df.replace(['20160722', u'????', 2431.0, u'????', 13.00, 300.0, 3891.10, 3905.71, u'??'],
               ['20160722', '0', '0', '0', 0, 0, 0, 0, '0'], inplace=True)
    #df.replace(['20160722'],['20160725','0','0','0',0,0,0,0,'0'],inplace=True)
    print df