pandas_test.py 文件源码

def search():
    #??
    df = pd.read_excel("huatai2.xls")
    input_m = 0.0
    output_m = 0.0
    for index, row in df.iterrows():
        if row[u'??'] == u'??':
            each_input = row[u'?????']
            print u"??",
            print each_input
            input_m = input_m + each_input
            #print type(money)
        if row[u'??'] == u'??':
            each_output = row[u'?????']
            print u"??",
            print each_output
            #print type(money)
            output_m = output_m + each_output

    print "Sumary is %f" % (input_m - output_m)