Skip to main content
Ground Control | Tier 1
June 16, 2023
Question

Bot Error in executing python script

  • June 16, 2023
  • 5 replies
  • 258 views

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)

5 replies

rbkadiyam
Premier Pathfinder | Tier 7
Premier Pathfinder | Tier 7
June 21, 2023

@Sanjay 7996  what was the error ?

Ramesh B Kadiyam
Cadet | Tier 2
March 21, 2024

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?

Automation Anywhere Team
March 22, 2024

Hi Sanjay,
 

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

Anjali.K1
Navigator | Tier 3
Navigator | Tier 3
August 25, 2025

Hi,

Is there any solution for this issue ?

 

 

Anjali KK
Automation Anywhere Team
August 25, 2025

Hi Anjali,

Please provide more details of the Python script