CODEWITHSUNDEEP
pythonmatplotlib
geeb.24
geeb.24

Reputation: 557

ValueError: invalid literal for float(): Reading in Latitude and Longitude Data

Given the following script to read in latitude, longitude, and magnitude data:

#!/usr/bin/env python

# Read in latitudes and longitudes
eq_data = open('lat_long')

lats, lons = [], []

for index, line in enumerate(eq_data.readlines()):
    if index > 0:
        lats.append(float(line.split(',')[0]))
        lons.append(float(line.split(',')[1]))

#Build the basemap
from mpl_toolkits.basemap import Basemap
import matplotlib.pyplot as plt
import numpy as np

antmap = Basemap(projection='spstere', boundinglat=-20, lon_0=-60, resolution='f')
antmap.drawcoastlines(color='0.50', linewidth=0.25)
antmap.fillcontinents(color='0.95')

x,y = antmap(lons, lats)
antmap.plot(x,y, 'r^', markersize=4)
plt.show()

I receive the following error when attempting to read in the latitudes, longitudes, and magnitudes:

Traceback (most recent call last):
  File "./basic_eqplot.py", line 10, in <module>
    lats.append(float(line.split(',')[0]))
ValueError: invalid literal for float(): -18.381  -172.320  5.9

The input file looks something like:

-14.990,167.460,5.6
-18.381,-172.320,5.9
-33.939,-71.868,5.9
-22.742,-63.571,5.9
-2.952,129.219,5.7

Any ideas for why this would cause a hiccup?

Upvotes: 0

Views: 1263

Answers (2)

fpierfed
fpierfed

Reputation: 71

What is probably going on is that your input file has a malformed line where a space is used to separate fields instead of a comma.

As a consequence, the result of line.split(',')[0] is the whole input line (in your case "-18.381 -172.320 5.9").

More in general: for these types of problems I really like to use the Python cvs module to parse the input file:

import csv
with open('lat_long', 'r') as csvfile:
    reader = csv.reader(csvfile)
    for row in reader:
        assert len(row) == 3
        lst, lon, mag = row
        ...

An alternative would be to use tools like pandas; but that might be overkill in some cases.

Upvotes: 5

chucksmash
chucksmash

Reputation: 5997

It appears you have one or more lines of corrupt data in your input file. Your traceback says as much:

ValueError: invalid literal for float(): -18.381  -172.320  5.9

Specifically what is happening:

  1. The line -18.381 -172.320 5.9 is read in from eq_data.
  2. split(',') is called on the string "-18.381 -172.320 5.9". Since there is no comma in the string, the split method returns a list with a single element, the original string.
  3. You attempt to parse the first element of the returned array as a float. The string "-18.381 -172.320 5.9" cannot be parsed as a float and a ValueError is raised.

To fix this issue, double check the format of your input data. You might also try surrounding this code snippet in a try/except block to give you a bit more useful information as to the specific source of the problem:

for index, line in enumerate(eq_data.readlines()):
    if index > 0:
        try:
            lats.append(float(line.split(',')[0]))
            lons.append(float(line.split(',')[1]))
        except ValueError:
            raise ValueError("Unable to parse input file line #%d: '%s'" % (index + 1, line))

Upvotes: 5

Related Questions