5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Aspire     Programming Python in Action     Programming Python in Action Track 1: Python in Action
Buttons are useful widgets but they occupy screen real estate even when not being clicked and often clutter the UI of an app. Menus are a natural and popular choice to mitigate these weaknesses of buttons. Combining menus with visualization libraries such as Seaborn and databases such as MySQL can help you build a fully functional data analysis app in Python.
Begin by adding menu bars to your app and link up actions to these menu bar items. Add a Seaborn line plot to your app which will allow the user to visualize the commodity price data they uploaded. You will then set up MySQL and run SQL code from the MySQL command line. Next, create a database that you will later connect to from an app, and load data from a file on your computer. Finally, you'll create an archive database to store old data and connect to MySQL from your app.
After completing this course, you'll be able to add menus and menu items to a Tkinter app and leverage MySQL for database connectivity and Tkinter for visualizing data by integrating it with Seaborn.

Objectives

Developing Apps with Tkinter: Menu Bars, Seaborn Visualization, & MySQL DBs

  • discover the key concepts covered in this course
  • introduce the menu bar widget
  • add Seaborn charts to a Tkinter app
  • customize a Seaborn chart in a Tkinter app
  • open MySQL on a shell and create a table
  • run queries from the MySQL shell and connect to MySQL from an app
  • connect to MySQL from an app and pull data to display in tree view
  • write out to MySQL from an app
  • set up an archive database
  • illustrate the code for a complex UI
  • write code for an app which connects to MySQL
  • summarize the key concepts covered in this course