cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arungurung Frequent Visitor
Frequent Visitor

Help to implement Python Script

have install all the things requried tor un Python in Power BI

Is it possible to use this the python code fromt his url

https://python-graph-gallery.com/313-bubble-map-with-folium/

and use it in power bI?

I have my own lat , lon, name(location), value column in power bi.

 
import folium
import pandas as pd
 
# Make a data frame with dots to show on the map
data = pd.DataFrame({
   'lat':[-58, 2, 145, 30.32, -4.03, -73.57, 36.82, -38.5],
   'lon':[-34, 49, -38, 59.93, 5.33, 45.52, -1.29, -12.97],
   'name':['Buenos Aires', 'Paris', 'melbourne', 'St Petersbourg', 'Abidjan', 'Montreal', 'Nairobi', 'Salvador'],
   'value':[10,12,40,70,23,43,100,43]
})
data
 
# Make an empty map
m = folium.Map(location=[20,0], tiles="Mapbox Bright", zoom_start=2)
 
# I can add marker one by one on the map
for i in range(0,len(data)):
   folium.Circle(
      location=[data.iloc[i]['lon'], data.iloc[i]['lat']],
      popup=data.iloc[i]['name'],
      radius=data.iloc[i]['value']*10000,
      color='crimson',
      fill=True,
      fill_color='crimson'
   ).add_to(m)
 
# Save it as html
m.save('mymap.html')
 
1 REPLY 1
Community Support Team
Community Support Team

Re: Help to implement Python Script

Hi @arungurung ,

 

It is not available to run above Python script in Power BI desktop. Above script needs two packages: folium and pandas, however, folium is not yet supported by Power BI now.

The following Python packages (non-Intel MKL) are currently supported for use in your Power BI reports. Reference: Python packages and versions

  • Matplotlib
  • numpy
  • pandas
  • scikit-learn
  • scipy
  • seaborn
  • statsmodels

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.