Python script stopped working

oalabed

I am using a Python script to split multi value cells into separate rows, The script was working fine for a few days and now it fails, anything I should look into checking ?

Import the domomagic package into the script

from domomagic import *
import pandas as pd

read data from inputs into a data frame

input1 = read_dataframe('Add Formula')
input1 = pd.DataFrame(input1)

write your script here

write_dataframe(input1)
#input1 = pd.DataFrame(input1)

code here

def count_splits(value):
return len(value.split(','))

input1['Split_Count'] = input1['JobNumber'].apply(count_splits)
input1['Split JobNumber']= input1['JobNumber'].str.split(',') #split dataframe column 'job number' on delimiter " "
input1= input1.explode('Split JobNumber') #create a row for every job number created from split
write_dataframe(input1)

ArborRose

I assume that isn't your exact code. There are comments there that don't have # symbols. And the formatting is wrong. Probably caused by the community forum interface for input. For example, you have "write your script here"….which is a comment. As if AI is asking you for a function.

Consider the following

Check for Errors: Identify the exact error message you are getting. This will give you a clue about what might be going wrong.

Input Data Consistency: Ensure that the input data format has not changed. Inconsistent data can cause functions to fail.

Library Versions: Verify that the versions of the libraries (domomagic, pandas) have not changed. Updates to these libraries might introduce breaking changes.

Code Syntax and Indentation: Ensure that the code is correctly indented and syntactically correct.

Check for Null Values: If JobNumber contains any null values, the split function will fail. Ensure that JobNumber has no null values or handle them appropriately.

Check for Data Types: Ensure that the JobNumber column contains strings. If there are non-string values, the split function will fail.

Indentation: The function count_splits is not correctly indented. Ensure it is indented properly.

ArborRose

I assume that isn't your exact code. There are comments there that don't have # symbols. And the formatting is wrong. Probably caused by the community forum interface for input. For example, you have "write your script here"….which is a comment. As if AI is asking you for a function.

Consider the following

Check for Errors: Identify the exact error message you are getting. This will give you a clue about what might be going wrong.

Input Data Consistency: Ensure that the input data format has not changed. Inconsistent data can cause functions to fail.

Library Versions: Verify that the versions of the libraries (domomagic, pandas) have not changed. Updates to these libraries might introduce breaking changes.

Code Syntax and Indentation: Ensure that the code is correctly indented and syntactically correct.

Check for Null Values: If JobNumber contains any null values, the split function will fail. Ensure that JobNumber has no null values or handle them appropriately.

Check for Data Types: Ensure that the JobNumber column contains strings. If there are non-string values, the split function will fail.

Indentation: The function count_splits is not correctly indented. Ensure it is indented properly.