文章/答案/技术大牛

发布

问Folium Map内存不足
EN

Stack Overflow用户

提问于 2020-11-19 13:12:36

回答 2查看 335关注 0票数 0

我一直在使用附带的代码构建一个HTML文件，该文件包含一个folium映射，其中包含来自数据帧的许多标记。直到今天，我一直在完美地使用它。现在它挂起了很长一段时间，并在保存html文件时出现内存错误。当我注释掉HTML文件行时，代码会在一段时间后运行。

为什么我现在会得到这个错误？

我的代码可以变得更高效吗？

import pandas as pd
import folium
import folium.plugins as plugins
import folium.map as fm


df = pd.read_excel('Stores_lat_long.xlsx')
df = df.dropna(subset=['Store Latitude'])
df = df.dropna(subset=['Store Longitude'])


sf = pd.read_excel('Stores_lat_long.xlsx', 1, index_col=0)

#oh / (sales/6)

sf['WOS'] = sf['Repl Inv Units'] / (sf['Sales Units'] / 6)

df = pd.merge(df, sf)

print(df)


#defining inital Map Object
m = folium.Map(
    location=[36.166340, -86.779068], 
    zoom_start=4)

folium.TileLayer('openstreetmap').add_to(m)
folium.TileLayer('Stamen Terrain').add_to(m)
folium.TileLayer('Stamen Toner').add_to(m)



#Define Features

fg = folium.FeatureGroup(name='Hardwood Only Stores Code 01', show=False)
m.add_child(fg)

gg = folium.FeatureGroup(name='Softwood Only Stores Code 01', show=False)
m.add_child(gg)

fgcl = folium.FeatureGroup(name='Hardwood Clustered', show=False)
fgcl_markers = plugins.MarkerCluster().add_to(fgcl)
m.add_child(fgcl)


ggcl = folium.FeatureGroup(name='Softwood Clustered', show=False)
ggcl_markers = plugins.MarkerCluster().add_to(ggcl)
m.add_child(ggcl)

# tie to top right layer control

folium.LayerControl('topright', collapsed=False).add_to(m)

#Hardwood Pellets un-clusterd

for i in range(0, len(df)):
    if df['Std Code'].iloc[i] != 1: continue
    if df['Article No'].iloc[i] != 3195163: continue

    sku = df['Article No'].iloc[i]
    store = df['Store No'].iloc[i]
    code = df['Std Code'].iloc[i]
    units = df['Repl Inv Units'].iloc[i]
    oo = df['On Order Units'].iloc[i]
    region = df['Region Full'].iloc[i]
    dm = df['Dist DM Name'].iloc[i]
    wos = df['WOS'].iloc[i]


    test = folium.Html('''

        <body>
            Store Number: <strong> {store} </strong> <br>
            Pellet SKU: <strong> {sku} </strong> <br>
            Store Coded: <strong> {code} </strong> <br>
            On-Hand Units: <strong> {units} </strong> <br>
            On-Order Units: <strong> {oo} </strong> <br>
            Region: <strong> {region} </strong> <br>
            DM: <strong> {dm} </strong> <br>
            WOS: <strong> {wos} </strong> <br>

        </body>'''.format(sku=sku, store=store, code=code, units=units, region=region, dm=dm, oo=oo,wos=wos), script=True)

    popup = folium.Popup(test, max_width=2650)
    folium.Marker(
                [df['Store Latitude'].iloc[i], df['Store Longitude'].iloc[i]], 
                popup=popup,
                tooltip= 'Store:' + str(df['Store No'].iloc[i]), 
                icon=folium.Icon(color='darkred',icon="home", prefix='fa')).add_to(fg)
    continue


#Softwood Pellets Unclustered
for i in range(0, len(df)):
    if df['Article No'].iloc[i] != 1115622: continue
    if df['Std Code'].iloc[i] != 1: continue

    sku = df['Article No'].iloc[i]
    store = df['Store No'].iloc[i]
    code = df['Std Code'].iloc[i]
    units = df['Repl Inv Units'].iloc[i]
    oo = df['On Order Units'].iloc[i]
    region = df['Region Full'].iloc[i]
    dm = df['Dist DM Name'].iloc[i]
    wos = df['WOS'].iloc[i]

    test = folium.Html('''

        <body>
            Store Number: <strong> {store} </strong> <br>
            Pellet SKU: <strong> {sku} </strong> <br>
            Store Coded: <strong> {code} </strong> <br>
            On-Hand Units: <strong> {units} </strong> <br>
            On-Order Units: <strong> {oo} </strong> <br>
            Region: <strong> {region} </strong> <br>
            DM: <strong> {dm} </strong> <br>
            WOS: <strong> {wos} </strong> <br>

        </body>'''.format(sku=sku, store=store, code=code, units=units, region=region, dm=dm, oo=oo, wos=wos), script=True)

    popup = folium.Popup(test, max_width=2650)
    folium.Marker(
                [df['Store Latitude'].iloc[i], df['Store Longitude'].iloc[i]], 
                popup=popup,
                tooltip= 'Store:' + str(df['Store No'].iloc[i]), 
                icon=folium.Icon(color='blue',icon="building", prefix='fa')).add_to(gg)
    continue


#Hardwood Clustered
for i in range(0, len(df)):
    if df['Std Code'].iloc[i] != 1: continue
    if df['Article No'].iloc[i] != 3195163: continue


    sku = df['Article No'].iloc[i]
    store = df['Store No'].iloc[i]
    code = df['Std Code'].iloc[i]
    units = df['Repl Inv Units'].iloc[i]
    oo = df['On Order Units'].iloc[i]
    region = df['Region Full'].iloc[i]
    dm = df['Dist DM Name'].iloc[i]
    wos = df['WOS'].iloc[i]


    test = folium.Html('''

        <body>
            Store Number: <strong> {store} </strong> <br>
            Pellet SKU: <strong> {sku} </strong> <br>
            Store Coded: <strong> {code} </strong> <br>
            On-Hand Units: <strong> {units} </strong> <br>
            On-Order Units: <strong> {oo} </strong> <br>
            Region: <strong> {region} </strong> <br>
            DM: <strong> {dm} </strong> <br>
            WOS: <strong> {wos} </strong> <br>

        </body>'''.format(sku=sku, store=store, code=code, units=units, region=region, dm=dm, oo=oo, wos=wos), script=True)

    popup = folium.Popup(test, max_width=2650)
    folium.Marker(
                [df['Store Latitude'].iloc[i], df['Store Longitude'].iloc[i]], 
                popup=popup,
                tooltip= 'Store:' + str(df['Store No'].iloc[i]), 
                icon=folium.Icon(color='darkred',icon="home", prefix='fa')).add_to(fgcl_markers)
    continue



#Softwood Clustered
for i in range(0, len(df)):
    if df['Article No'].iloc[i] != 1115622: continue
    if df['Std Code'].iloc[i] != 1: continue

    sku = df['Article No'].iloc[i]
    store = df['Store No'].iloc[i]
    code = df['Std Code'].iloc[i]
    units = df['Repl Inv Units'].iloc[i]
    oo = df['On Order Units'].iloc[i]
    region = df['Region Full'].iloc[i]
    dm = df['Dist DM Name'].iloc[i]
    wos = df['WOS'].iloc[i]

    
    test = folium.Html('''

        <body>
            Store Number: <strong> {store} </strong> <br>
            Pellet SKU: <strong> {sku} </strong> <br>
            Store Coded: <strong> {code} </strong> <br>
            On-Hand Units: <strong> {units} </strong> <br>
            On-Order Units: <strong> {oo} </strong> <br>
            Region: <strong> {region} </strong> <br>
            DM: <strong> {dm} </strong> <br>
            WOS: <strong> {wos} </strong> <br>

        </body>'''.format(sku=sku, store=store, code=code, units=units, region=region, dm=dm, oo=oo, wos=wos), script=True)

    

    popup = folium.Popup(test, max_width=2650)
    folium.Marker(
                [df['Store Latitude'].iloc[i], df['Store Longitude'].iloc[i]], 
                popup=popup,
                tooltip= 'Store:' + str(df['Store No'].iloc[i]), 
                icon=folium.Icon(color='blue',icon="building", prefix='fa')).add_to(ggcl_markers)
    continue



m.save(outfile='pellet_map2.html')
df.to_excel('ThisOne.xlsx')

Error Message

folium

python

pandas

memory

ram

回答 2

Stack Overflow用户

发布于 2020-11-19 22:21:03

我发现了问题所在。我错误地合并了两个数据帧，结果得到的df是55,000+行。我的地图正试图在铬浏览器中绘制出所有这些点。这太过分了。Folium地图在冻结你的浏览器之前达到了大约3000个点。

票数 0

Stack Overflow用户

发布于 2021-04-25 12:59:30

不是直接回答这个问题-而是一个减少folium HTML文件大小的技巧：

使用gpd.simplify(tolerance=0.1)简化geoDataFrame --容差越大，多边形文件的扭曲程度就越大。

这样做后，我的folium HTML大小从70mb减少到不到1MB。

票数 0

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/64905772

复制

相似问题

问Folium Map内存不足
EN

回答 2

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Folium Map内存不足EN

回答 2

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Folium Map内存不足
EN