7

I'm trying to import a dataset of UK postcode districts UK postcode districts from Google Fusion tables into geopandas with the aim of splicing it to a dataset of house prices.

The problem is that geopandas doesn't seem to like either the CSV/KML version of the data.

If I use the command geopandas.from_file(path) then I receive the error:

DriverError: unsupported driver: u'CSV'

I have the same error when I try to import a KML version of the data (You can download the data below).

I'm sure it's trivial, but can anyone work out what I'm doing wrong?

UK postcode districts - KML

UK postcode districts - CSV

12

in case of csv, it probably would be easier to read it with pandas and then convert it to geopandas Dataframe

import pandas as pd
import geopandas as gp
from shapely.geometry import Point

stations = pd.read_csv('../data/stations.csv')
stations['geometry'] = stations.apply(lambda z: Point(z.X, z.Y), axis=1)
stations = gp.GeoDataFrame(stations)
5

GeoPandas relies on the Fiona library (http://github.com/toblerity/Fiona) for the from_file() implementation. At this time Fiona, and therefore GeoPandas, does not support CSV or KML input. If you can convert them to GeoJSON or Shapefiles, then GeoPandas should be able to read without a problem.

  • Ah, I didn't realise that. Time to dig out a file converter. I understand that ogr2ogr is great. – elksie5000 Sep 16 '14 at 18:21
3

The KML driver isn't enabled by default as detailed in this github issue https://github.com/Toblerity/Fiona/issues/97. Basically, the KML driver doesn't seem to meet Fiona's quality requirements (as of 2014), not sure if it will be fixed in the future.

You could try to read a simple/standard-enough KML as follows:

import geopandas as gpd
fiona.drvsupport.supported_drivers['kml'] = 'rw' # enable KML support which is disabled by default
fiona.drvsupport.supported_drivers['KML'] = 'rw' # enable KML support which is disabled by default

gpd.read_file("/path/to/your/test.kml")

I've tried to read a file here and it gave me the following output:

enter image description here

Credits to this gist:

https://gist.github.com/timtroendle/6f61dc38a0aad58c2261524d7d8594c3

Edit 20191021: With newer versions of fiona, you might need to use libkml instead of kml. I.e.:

fiona.drvsupport.supported_drivers['libkml'] = 'rw' # enable KML support which is disabled by default
fiona.drvsupport.supported_drivers['LIBKML'] = 'rw' # enable KML support which is disabled by default
  • 1
    In addition, to convert the POLYGON Z to standard POLYGON you can do : df.geometry.map(lambda poly: shapely.ops.transform(lambda x, y, z: (x, y), poly)) – MCMZL Oct 17 '18 at 9:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.