Question

Bot Error in executing python script

  • 16 June 2023
  • 3 replies
  • 95 views

Badge

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_data[input_data['Start time'].isin(master_data['Start time'])&(input_data['Status'].isnull() | input_data['Status'].eq(''))]

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

filtered_data.to_excel(output_file, index=False)


3 replies

Userlevel 5
Badge +10

@Sanjay 7996  what was the error ?

Badge

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_data[input_data['Start time'].isin(master_data['Start time'])&(input_data['Status'].isnull() | input_data['Status'].eq(''))]

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

filtered_data.to_excel(output_file, index=False)

Did you fix this?

Userlevel 1
Badge +4

Hi Sanjay,
 

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

Reply