我有一个地理空间打印数据框,并且想要打印它。
我正在开发一个由Databricks运行的Jupyter笔记本电脑。
我下载了一个shapefile (https://data.london.gov.uk/download/statistical-gis-boundary-files-london/9ba8c833-6370-4b11-abdc-314aa020d5e0/statistical-gis-boundaries-london.zip),并设法只对伦敦的一部分进行了子集,使用:
import geopandas as gpd
import descartes
import pandas as pd
import matplotlib.pyplot as plt
fp = '/dbfs/FileStore/tables/LondonShapeFile/OA_2011_London_gen_MHW.shp'
map_df = gpd.read_file(fp, encoding="utf-8")
orp = map_df[map_df['WD11NM_BF']=='Orpington']
print(orp.shape)
orp.plot()我得到了:
(50, 18)
Out[95]: <matplotlib.axes._subplots.AxesSubplot at 0x7f064e8df5c0>我没有得到一个图,所以试了一下:
%matplotlib inline但得到的是:
%matplotlib inline is not supported in Databricks.
You can display matplotlib figures using display(). For an example, see https://docs.databricks.com/user-guide/visualizations/matplotlib-and-ggplot.html遵循https://docs.databricks.com/user-guide/visualizations/matplotlib-and-ggplot.html works上的建议示例,
import numpy as np
df3 = pd.DataFrame(np.random.randn(1000, 2), columns=['B', 'C']).cumsum()
df3['A'] = pd.Series(list(range(len(df3))))
dd=df3.plot(x='A', y='B')
display(dd.figure)但是当我尝试用geopandas df实现类似的东西时,我得到了多个错误:
orp.dipslay()
AttributeError: 'GeoDataFrame' object has no attribute 'dipslay'
---------------------------------------------------------------------------
AttributeError Traceback (most recent call last)
<command-797544454504214> in <module>()
1 import descartes
----> 2 orp.dipslay()
/databricks/python/lib/python3.5/site-packages/pandas/core/generic.py in __getattr__(self, name)
2742 if name in self._info_axis:
2743 return self[name]
-> 2744 return object.__getattribute__(self, name)
2745
2746 def __setattr__(self, name, value):
AttributeError: 'GeoDataFrame' object has no attribute 'dipslay'display(orp)
Exception: Cannot call display(<class 'geopandas.geodataframe.GeoDataFrame'>)
---------------------------------------------------------------------------
Exception Traceback (most recent call last)
<command-797544454504288> in <module>()
----> 1 display(orp)
/local_disk0/tmp/1553768511027-0/PythonShell.py in display(self, input, *args, **kwargs)
860 input.help() # This is going to display the help as a side-effect
861 else:
--> 862 raise Exception(genericErrorMsg)
863
864 def displayHTML(self, html):
Exception: Cannot call display(<class 'geopandas.geodataframe.GeoDataFrame'>)
Call help(display) for more info.和
display(orp.plot())
/databricks/python/lib/python3.5/site-packages/matplotlib/pyplot.py:524: RuntimeWarning: More than 20 figures have been opened. Figures created through the pyplot interface (`matplotlib.pyplot.figure`) are retained until explicitly closed and may consume too much memory. (To control this warning, see the rcParam `figure.max_open_warning`).
max_open_warning, RuntimeWarning)
Exception: Cannot call display(<class 'matplotlib.axes._subplots.AxesSubplot'>)
---------------------------------------------------------------------------
Exception Traceback (most recent call last)
<command-797544454504291> in <module>()
----> 1 display(orp.plot())
/local_disk0/tmp/1553768511027-0/PythonShell.py in display(self, input, *args, **kwargs)
860 input.help() # This is going to display the help as a side-effect
861 else:
--> 862 raise Exception(genericErrorMsg)
863
864 def displayHTML(self, html):
Exception: Cannot call display(<class 'matplotlib.axes._subplots.AxesSubplot'>)
Call help(display) for more info.发布于 2019-04-08 22:36:07
有些东西在DataBricks中不工作,所以我按照下面的步骤,在我的笔记本电脑(Windows10)上运行它,它工作了。
Windows 10 installation of geopandas
1) I go this website to download the following installation files (.whl):
https://www.lfd.uci.edu/~gohlke/pythonlibs/
1.1) Shapely
1.2) GDAL and
1.3) Fiona
2) Go to the download file and run in anaconda prompt
pip install < *.whl> for Shapely, GDAL and Fiona

发布于 2019-04-08 22:46:26
这个解决方案最终奏效了。
fp = '/dbfs/FileStore/tables/LondonShapeFile/OA_2011_London_gen_MHW.shp'
map_df = gpd.read_file(fp, encoding="utf-8")
print(map_df.shape)
ldn = map_df.plot()
display(ldn.figure)

https://stackoverflow.com/questions/55574769
复制相似问题