python 运行时一直报错

1哦哦哦

can't find '__main__' module in         还有excel表格读取和写入模块如何安装呀

ba21

提问不上代码的？

1哦哦哦

import pandas as pd
import demjson

def combData(data1,data2,data3):
        result = data1.append(data2.append(data3))
        return result.iloc[:,3:6]
       
data28_1 = pd.read_csv(r'F:\movies.xls')
data28_2 = pd.read_csv(r'F:\movies.xls')
data28_3 = pd.read_csv(r'F:\movies.xls')
result1 = combData(data28_1,data28_2,data28_3)


data29_1 = pd.read_csv(r'F:\movies.xls')
data29_2 = pd.read_csv(r'F:\movies.xls')
data29_3 = pd.read_csv(r'F:\movies.xls')
result2 = combData(data29_1,data29_2,data29_3)


data30_1 = pd.read_csv(r'F:\movies.xls')
data30_2 = pd.read_csv(r'F:\movies.xls')
data30_3 = pd.read_csv(r'F:\movies.xls')
result3 = combData(data30_1,data30_2,data30_3)


mid_result = pd.merge(result1,result2,how = 'outer',on = ['src_id','des_id'])
mid_result=mid_result.fillna(value=0)
final_result = pd.merge(mid_result,result3,how = 'outer',on = ['src_id','des_id'])
final_result=final_result.fillna(value=0)
print(final_result.info)

data1 = final_result.iloc[:,0:1].values.T.tolist()[0]
data2 = final_result.iloc[:,1:2].values.T.tolist()[0]
data3 = final_result.iloc[:,2:3].values.T.tolist()[0]
data4 = final_result.iloc[:,3:4].values.T.tolist()[0]
data5 = final_result.iloc[:,4:5].values.T.tolist()[0]

dict = {}
for i in  range(len(data1)):
        json_data = [
                                {
                                        'time' : 28,
                                        'count' : data3[i]
                                } ,
                                {
                                        'time' : 29,
                                        'count' : data4[i]
                                },
                                {
                                        'time' : 31,
                                        'count' : data5[i]
                                }
                        ]
        json = demjson.encode(json_data)
       
        dict[""+str(data1[i])+str(data2[i])]=json
       
print(dict)