division by zero causing overflow error

Question

I have a program that populates results below. The next step is to take the numbers in the first column the 23.39 and everything below it and divide it by a number. the problem is if you scroll down you see no values in the first column. I need to tell the program if there's no value in cloumn 1 or 2 then there is no calculation

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

09/02/2023 DMR 5.0 T fm GrnFlshH-G3 21.74 44.7 56.07

----------------------------------------

01/08/2023 SA 8.0 ft Sham-G3 22.28 45.57 69.55 95.87

----------------------------------------

11/04/2022 KEE 8.0 T fm BCJuvTrf-G1 23.4 48.29 73.04 95.99

10/09/2022 SA 8.0 T fm ZumaBch-G3 22.85 46.7 70.57 94.07

09/11/2022 DMR 8.0 T fm DMRJvTrf-G3 23 47.24 72.32 95.96

08/05/2022 DMR 5.0 T fm MdSpWt 22.6 46.23 58.08

----------------------------------------

06/03/2022 GP 5.0 sy MdSpWt 23.09 46.37 59.26

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

----------------------------------------

09/03/2023 DMR 9.0 T fm DMrDerby-G2 47.4 72.2 96.68 108.61

08/06/2023 DMR 8.5 T fm LaJollaH-G3 23.6 48.82 74.5 104.2

06/22/2023 ASC 8.0 T gd Brtnn Stks151k 100.02

05/21/2023 NAS 7.0 T gd Ownstwn Stu41k 86.46

04/18/2023 GOW 7.0 T sf Alw22700 93.33

03/26/2023 NAS 7.0 T hy Irsh Rcng W46k 100.71

----------------------------------------

10/16/2022 NAS 7.0 T sf Clm0 92.64

09/02/2022 DRL 7.0 T gd Md0 89.55

----------------------------------------

05/20/2022 CGH 6.0 T yl Md0 73.67

04/10/2022 CGH 6.0 T yl MdSpWt 76.37

Answer 1

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