division by zero causing overflow error

To avoid a division by zero error and perform calculations only when there are values in column 1 or 2, you can implement a simple conditional check before performing the division. Here’s a generic example in Python:

“`python

# Sample data

data = [

“4 PACKS A WAHLOP (E/P 8) 3c Boff 30-1”,

” 09/30/2023 SA 6.5 T gd EddieD-G2 23.39 45.86 68.49 74.47″,

# … other lines …

“5 PANIC ALARM (S 0) 3g 6-1”,

# … other lines …

]

# Initialize variables to store values from columns

column1_value = None

column2_value = None

for line in data:

# Split the line by whitespace

parts = line.split()

# Check if there are enough parts in the line

if len(parts) >= 7:

try:

# Try to parse values from columns 1 and 2

column1_value = float(parts[6])

column2_value = float(parts[7])

except ValueError:

# Handle the case where column 1 or 2 couldn’t be converted to float

column1_value = None

column2_value = None

if column1_value is not None and column2_value is not None:

# Perform calculations only if both column 1 and 2 have valid values

result = column1_value / column2_value

print(f”Result: {result}”)

else:

# Handle the case where column 1 or 2 have missing or invalid values

print(“Missing or invalid values in column 1 or 2”)

“`

This code will iterate through your data and only perform division if there are valid values in column 1 and 2. It checks for missing or invalid values and handles them gracefully to avoid division by zero or overflow errors. You can adapt this code to your specific programming language and data format as needed.

Complete code below :

# Sample data

data = [

“4 PACKS A WAHLOP (E/P 8) 3c Boff 30-1”,

” 09/30/2023 SA 6.5 T gd EddieD-G2 23.39 45.86 68.49 74.47″,

# … other lines …

“5 PANIC ALARM (S 0) 3g 6-1”,

# … other lines …

]

# Initialize variables to store values from columns

column1_value = None

column2_value = None

for line in data:

# Split the line by whitespace

parts = line.split()

# Check if there are enough parts in the line

if len(parts) >= 7:

try:

# Try to parse values from columns 1 and 2

column1_value = float(parts[6])

column2_value = float(parts[7])

except ValueError:

# Handle the case where column 1 or 2 couldn’t be converted to float

column1_value = None

column2_value = None

if column1_value is not None and column2_value is not None:

# Perform calculations only if both column 1 and 2 have valid values

result = column1_value / column2_value

print(f”Result: {result}”)

else:

# Handle the case where column 1 or 2 have missing or invalid values

print(“Missing or invalid values in column 1 or 2”)

I hope this help you