How to Make an Interactive Map Using Python and SQLite Data

Опубликовано: 28 Март 2023
на канале: Sean MacKenzie Data Engineering

2,537

In this episode, we're going to look at how to take data from our SQLite database and then create an interactive map of scattered points for our users. We'll connect to our SQLite database, extract data using a Select statement into a Pandas dataframe, then use that dataframe to populate a Plotly Express Mapbox map. We'll see how the user can scroll in and out on the map to view groupings of dots and hover over dots to see additional data. Also, we'll see how to export the entire map into a html file that can be given to others or used on a website. Let's go!

Related Videos:
Getting Started with SQLite for Python
   • Getting Started with SQLite for Python
How to Execute SQL from a File on SqLite Using Python
   • How to Execute SQL from a File on SqLite U...
How to Select Data from SQLite
   • How to Select Data from SQLite
How to Output HTML from SQLite
   • How to Output HTML from SQLite
Migrate Data from MS Excel to SQLite and Back Again
   • Migrate Data from MS Excel to SQLite and B...
How to Use Dates in SQLite
   • How to Use Dates in SQLite
How to Create a Delimited Field in your SQLite Query with Python
   • How to Create a Delimited Field in your SQ...
How to Make an Interactive Map Using Python and SQLite Data
You are watching this video now!

Join me on Patreon!
  / mackenziedataengineering

Demo of my BZ RDP Cloaker:
https://www.patreon.com/posts/how-to-...

Check out some tech (and support my channel!):
https://www.amazon.ca/shop/seanmacken...

Want the code from this video?
http://mackenziemackenzie.com/downloads

Interested in transforming your career or finding your next gig?
https://system.billzone.com/careers.html

Want my team to do a project for you? Let's get to it!
https://buy.billzone.com/smdeprojects...

Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
  / mackenziedataanalytics
  / seamacke
  / seamacke
  / seamacke
  / psmackenzie

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...

#python #plotly #openstreetmap #nasa

На этой странице сайта вы можете посмотреть видео онлайн How to Make an Interactive Map Using Python and SQLite Data длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Sean MacKenzie Data Engineering 28 Март 2023, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 2,537 раз и оно понравилось 51 зрителям. Приятного просмотра!

994