RuntimeError: input(): lost sys.stdin from executable file

Question

Seeking your help regarding this executable file I have converted from my .py file using auto-py-to-exe. I have this code below that I made for my csv automation report. Looks fine when running on IDE and CMD but when I tried to convert it to .exe this what happens.

Traceback (most recent call last):
  File "new.py", line 7, in 
    input_file = input("Enter the file name of your HC file: ")
RuntimeError: input(): lost sys.stdin

Here is my code below for your reference. Hoping you could help me with this issue.

import pandas as pd
import numpy as np


print("Fixed Network Health Check Checker")

input_file = input("Enter the file name of your HC file: ")
file = input_file + str('.xlsx')
df = pd.read_excel(file, sheet_name = 'MSAN Cabinets')

print("Done")

#fixed
df['MSAN Interface'] = df['MSAN Interface'].replace(np.nan, 0)

df['ACCESS Interface 1 (IPRAN, ATN, LSA, VLAN)'] = df['ACCESS Interface 1 (IPRAN, ATN, LSA, VLAN)'].replace(np.nan, 0)

df['Homing AG2'] = df['Homing AG1'].replace(np.nan, 0)

df = df.iloc[:11255]


# filter "REGION" and drop unnecessary columns

f_df1 = df[df['REGION'] == 'MIN']
dropcols_df1 = f_df1.drop(df.iloc[:, 1:6], axis = 1)
dropcols_df2 = dropcols_df1.drop(df.iloc[:, 22:27], axis = 1)
dropcols_df3 = dropcols_df2.drop(df.iloc[:, 37:50], axis = 1)


# filter "MSAN Interface" and filter the peak util for >= 50%

f_d2 = dropcols_df3['MSAN Interface'] != 0
msan_int = dropcols_df3[f_d2]
f_msan_int = msan_int['Peak Util'] >= 0.5
new_df = msan_int[f_msan_int]


# filter "ACCESS Interface 1 (IPRAN, ATN, LSA, VLAN)" and filter the peak util for >= 50%

fblank_msan_int = dropcols_df3['MSAN Interface'] == 0
msan_int1 = dropcols_df3[fblank_msan_int]
f_df3 = dropcols_df3['ACCESS Interface 1 (IPRAN, ATN, LSA, VLAN)'] != 0
access_int1 = dropcols_df3[f_df3]
f_access_int1 = access_int1['Peak Util.1'] >= 0.5
new_df1 = access_int1[f_access_int1]


# filter "Homing AG1" and filter the peak util for >= 50%

fblank_msan_int1 = dropcols_df3['MSAN Interface'] == 0
msan_int2 = dropcols_df3[fblank_msan_int1]
f_access_int2 = msan_int2['ACCESS Interface 1 (IPRAN, ATN, LSA, VLAN)'] == 0
new_df2 = msan_int2[f_access_int2]
ag1 = new_df2['Peak Util.3'] >= 0.5
new_df3 = new_df2[ag1]

# Concatenate all DataFrames

pdList = [new_df, new_df1, new_df3]
final_df = pd.concat(pdList)


print(final_df.to_csv('output.csv', index = False))

Thank you. Btw I'm new in Python :).

RuntimeError: input(): lost sys.stdin from executable file

0 Answers