|
装了pyinstaller和py2exe,照着网上的教程,成功打包起来了,但双击exe后,运行完没任何提示,直接退出。
我用cmd运行py文件是成功的,但是运行exe就不行了。在CMD下,运行玩exe也是没提示就结束了。
求助啊,为什么这样的,起码有个报错信息也好啊。。
代码:C:\Users\Maxxi\zx>pyinstaller -F Analysis.py
环境:python3.6
py代码:
import pandas as pd
import numpy as np
import datetime as dt
# In[2]:
file_location = input("file_location:")
writer = pd.ExcelWriter('Result.xlsx')
# In[3]:
df = pd.read_excel(file_location)
df['订单录入日期'] = pd.to_datetime(df['订单录入日期'])
df['大板数'] = round (df['订货数量'] / df['拼版数'],0)
# In[4]:
where_are_nan = np.isnan(df['大板数'])
where_are_inf = np.isinf(df['大板数'])
df[where_are_nan] = 0
df[where_are_inf] = 0
# In[5]:
df = df.sort_values(by = ['物资编号','订单录入日期'])
df = df[['物资编号','订单录入日期','大板数','客户号','订单类型']]
# In[6]:
df['cumsum_Qty'] = df.groupby(['物资编号'])['大板数'].cumsum()
# In[7]:
df_filter = df.loc[df.cumsum_Qty > 96]
# In[8]:
df_som = df_filter.loc[df_filter.groupby(['物资编号'])['订单录入日期'].idxmin()];
df_som = df_som.sort_values(by = '订单录入日期')
# In[9]:
df_som.to_excel(writer,sheet_name = '批量记录',index = False)
# In[10]:
df_1 = df.set_index('订单录入日期')
# In[11]:
current_date = str(dt.datetime.now().year) + "-" + str(dt.datetime.now().month)
# In[12]:
NPI_LIST = df_1[current_date].reset_index().drop(['大板数','cumsum_Qty','cumsum_Qty'],axis =1)
# In[13]:
NPI_LIST = NPI_LIST[NPI_LIST.订单类型 == '新单'].drop_duplicates().sort_values(by='订单录入日期')
# In[17]:
NPI_LIST.to_excel(writer,sheet_name = '当月新单记录',index = False)
|
|