import pandas as pd
import numpy as np
data = pd.read_excel(“F:/result/dangdang.xls”)
cp = data[‘price’]/data[‘comment’]
data[u"价评比"] = cp
file=“F:/result/b.xls”
data.to_excel(file,index=False)
import pandas as pd
import numpy as np
data = pd.read_excel(“F:/result/dangdang.xls”)
cp = data[‘price’]/data[‘comment’]
data[u"价评比"] = cp
file=“F:/result/b.xls”
data.to_excel(file,index=False)