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)