Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Python, SQL, and Tableau: Integrating Python, SQL, and Tableau
  • Table Of Contents Toc
Python, SQL, and Tableau: Integrating Python, SQL, and Tableau

Python, SQL, and Tableau: Integrating Python, SQL, and Tableau

By : 365 Careers Ltd.
close
close
Python, SQL, and Tableau: Integrating Python, SQL, and Tableau

Python, SQL, and Tableau: Integrating Python, SQL, and Tableau

By: 365 Careers Ltd.

Overview of this book

Python, SQL, and Tableau are three of the most widely used tools in the world of data science. Python is the leading programming language SQL is the most widely used means for communication with database systems Tableau is the preferred solution for data visualization; The course starts off by introducing software integration as a concept. We discuss some important terms such as servers, clients, requests, and responses. Moreover, you will learn about data connectivity, APIs, and endpoints. Then we continue by introducing the real-life example exercise the course is centred around: the Absenteeism at Work dataset. The preprocessing part that follows will give you a taste of what BI and data science look like in real-life, on-the-job situations. Then we continue by applying some Machine Learning to our data. You will learn how to explore the problem at hand from a machine-learning perspective, how to create targets, what kind of statistical preprocessing is necessary for this part of the exercise, how to train a Machine Learning model, and how to test it—a truly comprehensive ML exercise. Connecting Python and SQL is not immediate; we show how that's done in an entire section of the course. By the end of that section, you will be able to transfer data from Jupyter to Workbench. And finally, as promised, Tableau will allow us to visualize the data we have been working with. We will prepare several insightful charts and will interpret the results together. All the code files are placed at https://github.com/PacktPublishing/Python-SQL-Tableau-Integrating-Python-SQL-and-Tableau
Table of Contents (9 chapters)
close
close
7
Installing MySQL and Getting Acquainted with the Interface
You're currently viewing a free sample. Access the full title and Packt library for free now with a free trial.
Chapter: 5
Preprocessing
Icon This video is locked
Icon
Icon
0:00
2.0x
1.5x
1.25x
1.0x
0.5x
caption settings
caption off
Icon Icon
ShowHide Transcripts Icon
CONTINUE WATCHING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Python, SQL, and Tableau: Integrating Python, SQL, and Tableau
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon