dataframe 操作excel

import pandas as pd
dframe1 = pd.read_excel("window regulator分析报告分析.xlsx", sheetname="Sheet1")
dframe2 = pd.read_excel("window regulator分析报告分析.xlsx", sheetname="Sheet2")
dframe1["sku"] ="#"
# df = pd.read_excel("window regulator_test.xlsx")
# print(df.head())
print(dframe1.head())
print(dframe2.head())
# df = pd.DataFrame({"ebayno":"" , "p_sku":"" , "sale":"", "sku":""} ,index=["0"])
df = pd.DataFrame(columns = ["ebayno", "p_sku", "sale", "sku"])
print(df)
sku = dframe2.sku.values
p_skus = dframe2.p_sku.values
# print(p_skus)
i = 0
for ps in p_skus :
    dframe1.loc[dframe1.p_sku == ps,"sku"] = sku[i]

    # print(dframe1.loc[dframe1.p_sku == ps])
    df = df.append(dframe1.loc[dframe1.p_sku == ps], ignore_index=True)
    print(df)
    i = i + 1
# print(dframe1)
# print(sku.values) #将series变成数组
print(df)
df.to_csv("toto.csv",encoding="gbk",index=False )