Python script stopped working
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 scriptfrom domomagic import *
import pandas as pd
input1 = read_dataframe('Add Formula')
input1 = pd.DataFrame(input1)
write_dataframe(input1)
#input1 = pd.DataFrame(input1)
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
-
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 followingCheck 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! **0
Answers
-
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 followingCheck 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! **0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive