Skip to main content

Im getting Bot Error while executing python script but is successful while running it on other IDE:

Here’s the code:

 

import pandas as pd

input_data = pd.read_excel('inputdata.xlsx')

master_data = pd.read_excel('masterdata.xlsx')

filtered_data = input_dataainput_dataa'Start time'].isin(master_dataa'Start time'])&(input_dataa'Status'].isnull() | input_dataa'Status'].eq(''))]

output_file = 'filtereddata_{}.xlsx'.format('_'.join(master_data.columns))

filtered_data.to_excel(output_file, index=False)

@Sanjay 7996  what was the error ?


Im getting Bot Error while executing python script but is successful while running it on other IDE:

Here’s the code:

 

import pandas as pd

input_data = pd.read_excel('inputdata.xlsx')

master_data = pd.read_excel('masterdata.xlsx')

filtered_data = input_dataainput_dataa'Start time'].isin(master_dataa'Start time'])&(input_dataa'Status'].isnull() | input_dataa'Status'].eq(''))]

output_file = 'filtereddata_{}.xlsx'.format('_'.join(master_data.columns))

filtered_data.to_excel(output_file, index=False)

Did you fix this?


Hi Sanjay,
 

Are you still facing an issue with the Python code? I can help you resolve this issue.


Reply