Python script stopped working

Options

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)

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓
    Options

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓
    Options

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **