Create a bubble map from excel data using python folium and pandas

Поділитися
Вставка
  • Опубліковано 9 лис 2024

КОМЕНТАРІ • 25

  • @avepangilinan3814
    @avepangilinan3814 2 роки тому +1

    Thank you Sir for this video, it helps me a lot....

  • @ninaadathalye8050
    @ninaadathalye8050 Рік тому +1

    Very nice. Keep up the good work

  • @bextla3737
    @bextla3737 2 роки тому +1

    Nice tutorial. how did you add fuel type icon on legend?

    • @learningsoftwareskills
      @learningsoftwareskills  2 роки тому +1

      Hi, thanks for the feedback. The fuel type legend is actually injected HTML into the output file. I have explained about it in the video from 15:11
      I have also made a video on how to inject HTML into a folium map at ua-cam.com/video/Cvh-iSRRFJQ/v-deo.html . You can check out that video also.
      Hope this helps cheers👍

  • @shubhammukherjee2405
    @shubhammukherjee2405 3 роки тому +1

    Great job... I have an doubt. Can we make an layer that we be an path sorting algorithm avoiding clusters??
    Edit:we can do this via poly line function, but how to avoid overlapping?

    • @anitasunildesai
      @anitasunildesai 2 роки тому +2

      can we use multicolour polynomial function

    • @learningsoftwareskills
      @learningsoftwareskills  2 роки тому

      @@anitasunildesai you can color each bubble only with a single color, but the color of each bubble can be determined by your algorithm, for example you can write a function that returns a color based on the circle attribute like a polynomial function of the radius etc.
      Hope this helps.
      Cheers👍

  • @muhdHassanur
    @muhdHassanur Рік тому +1

    Awesome code! However what if I have more than 2 variables for the circle colour and I want different colours for each variables

    • @learningsoftwareskills
      @learningsoftwareskills  Рік тому

      Hi, the circle size and the circle color are the 2 parameters that can represent 2 dimensions of the data. But if you have to represent more than 2 variables of the data at a location on map, I think it is not possible with a bubble map.
      Hope this helps, Cheers👍

    • @muhdHassanur
      @muhdHassanur Рік тому +1

      @@learningsoftwareskills i see, thanks for clarifying!

  • @LeiffNathanAMendoza
    @LeiffNathanAMendoza 9 місяців тому +1

    have we encountered the limits of rows with python if the sheet reaches Millions ?

    • @learningsoftwareskills
      @learningsoftwareskills  9 місяців тому

      Hi, i think Excel itself has limits to how many rows can be present.
      Also there i a fair chance that browser can be struck if we plot millions of data points.

  • @acinad4605
    @acinad4605 3 роки тому +1

    Sir how can I avoid overlapping? And how can I add a window that displays my legend and how can I make it a responsive web map? Thanks

    • @learningsoftwareskills
      @learningsoftwareskills  3 роки тому

      Hi, Generally overlapping is common in a bubble map. But since we keep transparency, we can see all the bubbles even if they are overlapping.
      Injecting a legend into the map is already covered in this video.
      If you want to make the legend div responsive, use CSS to do so and you can also bootstrap for this.
      Hope this helps, Thanks for your feedback 👍

    • @acinad4605
      @acinad4605 3 роки тому +1

      @@learningsoftwareskills hi can you make a tutorial in making web map in jupyter notebook? Thank you

    • @learningsoftwareskills
      @learningsoftwareskills  3 роки тому +1

      @@acinad4605 I have made a video on working with folium maps in jupyter notebooks
      ua-cam.com/video/2Mn6IvzUKvY/v-deo.html
      Hope this helps 👍

    • @acinad4605
      @acinad4605 3 роки тому

      Thank you! Do you know how to render a web map in github?

    • @learningsoftwareskills
      @learningsoftwareskills  3 роки тому

      @@acinad4605 for that you have to use "GitHub pages" feature and render your map as HTML and JavaScript.
      If you don't know about JavaScript, just take the output.html file and place it in GitHub.
      For activating the GitHub pages feature check this out pages.github.com/

  • @daniyalalisyed368
    @daniyalalisyed368 3 роки тому +1

    Hey man great video!
    Can you please share the code file you used in the video? It would help A LOT

    • @learningsoftwareskills
      @learningsoftwareskills  3 роки тому +1

      Thanks a lot for the encouraging feedback!
      The blogpost with the code for this video can be seen at nagasudhir.blogspot.com/2021/08/create-bubble-map-from-excel-data-using.html
      The links are also in the description of the video

  • @anitasunildesai
    @anitasunildesai 2 роки тому +1

    how did you get the geojson file?

    • @learningsoftwareskills
      @learningsoftwareskills  2 роки тому +1

      Hi, you can get the geojson file here - raw.githubusercontent.com/nagasudhirpulla/taming_python/master/blog/skills/assets/data/states_india.geojson
      I found the geojson from github
      Just search in google like "India borders geojson github"
      You can also watch my video on geojson with folium in this channel at ua-cam.com/video/h16O4xt6yBU/v-deo.html
      Also see the video description for the blog post and more useful links
      Hope this helps, cheers👍

    • @anitasunildesai
      @anitasunildesai 2 роки тому +1

      Thanks a lot. God bless u.