摘要:
import pandas as pd products = pd.read_excel('c:/Temp/List.xlsx',index_col = 'ID') products.sort_values(by =['Worthy','Price'],inplace=True,ascending=[True,False] ) #sort_values 数据排序 ... 阅读全文
摘要:
import pandas as pd books = pd.read_excel('e:/Books.xlsx',index_col='ID') for i in books.index: books['Price'].at[i]=books['ListPrice'].at[i]*books['Discount'].at[i] print(books) import pan... 阅读全文