Member-only story

Basic Data Analysis with MySQL Shell Python mode

Josh Otwell
12 min readSep 16, 2020

--

I recently watched a fantastic Python Pandas library tutorial series on YouTube. Without a doubt, Pandas is great for all sorts of data stuff. On the same token, MySQL Shell in Python mode is quite powerful in the sense that Python and the MySQL Shell (version >= 8.0) are somewhat united in the same environment. Although Pandas is in a league all its own when it comes to data analysis, between the power of MySQL and Python, we can also perform some basic analysis easily in MySQL Shell Python mode. In this blog post, I will cover some basic data analysis using Python mode in the MySQL Shell. Continue reading to see examples…

Business vector created by freepik — www.freepik.com

OS, Software, and DB used:

  • OpenSuse Leap 15.1
  • MySQL 8.0.21

Self-Promotion:

If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!

Data Set Used

You can download the Stack Overflow Developer Survey Results data set used in this post for your own exploration if you would like.

Basic Data Analysis with MySQL Shell Python Mode: Connecting, table row and…

--

--

Josh Otwell
Josh Otwell

Written by Josh Otwell

SQL/PHP | Photography | Technical Consultant. Sign-up for my free developer newsletter, OpenLampTech, here: openlamptech.substack.com

No responses yet