Python, SQL, and Tableau: Integrating Python, SQL, and Tableau [Video]
Video
Video
$183.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
What do you get with video?
What do you get with video?
What do you get with Audiobook?
What do you get with Exam Trainer?
Video
$183.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Access this title in our online reader
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with video?
Stream this video
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
What do you get with Exam Trainer?
Flashcards, Mock exams, Exam Tips, Practice Questions
Access these resources with our interactive certification platform
Mobile compatible-Practice whenever, wherever, however you want
-
Free ChapterIntroduction
-
What is software integration?
-
Setting up the working environment
-
What's next in the course?
-
Preprocessing
- Data Sets in Python
- Data at a Glance
- A Note on Our Usage of Terms with Multiple Meanings
- Picking the Appropriate Approach for the Task at Hand
- Removing Irrelevant Data
- Examining the Reasons for Absence
- Splitting a Column into Multiple Dummies
- Dummy Variables and Their Statistical Importance
- Grouping - Transforming Dummy Variables into Categorical Variables
- Concatenating Columns in Python
- Changing Column Order in Pandas DataFrame
- Implementing Checkpoints in Coding
- Exploring the Initial "Date" Column
- Using the "Date" Column to Extract the Appropriate Month Value
- Introducing "Day of the Week"
- Further Analysis of the DataFrame: Next 5 Columns
- Further Analysis of the DaraFrame: "Education", "Children", "Pets"
- A Final Note on Preprocessing
-
Machine Learnings
- Exploring the Problem from a Machine Learning Point of View
- Creating the Targets for the Logistic Regression
- Selecting the Inputs
- A Bit of Statistical Preprocessing
- Train-test Split of the Data
- Training the Model and Assessing its Accuracy
- Extracting the Intercept and Coefficients from a Logistic Regression
- Interpreting the Logistic Regression Coefficients
- Omitting the dummy variables from the Standardization
- Interpreting the Important Predictors
- Simplifying the Model (Backward Elimination)
- Testing the Machine Learning Model
- How to Save the Machine Learning Model and Prepare it for Future Deployment
- Creating a Module for Later Use of the Model
-
Installing MySQL and Getting Acquainted with the Interface
-
Connecting Python and SQL
- Implementing the 'absenteeism_module' - Part I
- Implementing the 'absenteeism_module' - Part II
- Creating a Database in MySQL
- Importing and Installing 'pymysql'
- Creating a Connection and Cursor
- Creating the 'predicted_outputs' table in MySQL
- Running an SQL SELECT Statement from Python
- Transferring Data from Jupyter to Workbench - Part I
- Transferring Data from Jupyter to Workbench - Part II
- Transferring Data from Jupyter to Workbench - Part III
-
Analyzing the Obtained data in Tableau
About this
video
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
- Publication date:
- May 2019
- Publisher
- Packt
- Duration
- 5 hours 1 minutes
- ISBN
- 9781838987916
Latest Reviews
(1 reviews total)