Skip to main content
Question

Bot Error in executing python script

  • June 16, 2023
  • 5 replies
  • 166 views

Forum|alt.badge.img

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
Forum|alt.badge.img+17
  • Premier Pathfinder | Tier 7
  • June 21, 2023

@Sanjay 7996  what was the error ?


Forum|alt.badge.img
  • 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?


Forum|alt.badge.img+8
  • 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
Forum|alt.badge.img+5
  • Navigator | Tier 3
  • August 25, 2025

Hi,

Is there any solution for this issue ?

 

 


Forum|alt.badge.img+8
  • Automation Anywhere Team
  • August 25, 2025

Hi Anjali,

Please provide more details of the Python script