Data Sciense and ML (SQL – Python – Tableau) for integration

سرفصل های دوره

1 - Introduction

1 -Introduction

2 -Data Connectivity, APIs, and Endpoints

3 -API

4 -4. Exchanging Information using Text Files

5 -Software Integration

2 - What's Next

1 -What's next in the course

2 -Defining the Task - Absenteeism at Work

3 -3. The Data Set

3 - Preprocessing the 'Absenteeism_data'

1 -Importing the Data Set in Python

2 -Eyeballing the Data

3 -Introduction to Terms with Multiple Meanings

4 -An Analytical Approach to Solving the Task

5 -Dropping the 'ID' Column

6 -Analysis of the 'Reason for Absence' Column

7 -Converting a Feature into Multiple Dummy Variables

8 -Working with Dummy Variables from a Statistical Perspective

9 -Grouping the Various Reasons for Absence

10 -Concatenating Column Values

11 -Reordering Columns

12 -Creating Checkpoints in Jupyter

13 -Working on the 'Date' Column

14 -Extracting the Month Value

15 -Creating the 'Day of the Week' Column

16 -Analyzing the Next 5 Columns in our DataFrame

17 -Modifying 'Education' and discussing 'Children' and 'Pets'

18 -Final Remarks on the Data Preprocessing Part of the Exercise

4 - Applying Machine Learning to the Preprocessed Datav

1 -Exploring the Problem from a Machine Learning Point of View

2 -Creating the Targets for the Regression

3 -Selecting the Inputs for the Regression

4 -Standardizing the Dataset for Better Results

5 -Train-Test Split

6 -Training and evaluating the model

7 -Extracting the Intercept and Coefficients

8 -Interpreting the Coefficients

9 -Creating a Custom Scaler to Standardize Only Numerical Features

10 -Interpreting the (Important) Coefficients

11 -Simplifying the Model (Backward Elimination)

12 -Testing the Logistic Regression Model

13 -Saving the Logistic Regression Model

14 -Creating a module for later use of the model

5 - Python and SQL

1 -Loading the 'absenteeism_module'

2 -Working with the 'absenteeism_module'

3 -Creating a Database Structure in MySQL

4 -Installing and Importing 'pymysql'

5 -Setting up a Connection and Creating a Cursor

6 -Creating the 'predicted_outputs' table in MySQL

7 -Executing an SQL Query from Python

8 -Moving Data from Python to SQL - Part I

9 -Moving Data from Python to SQL - Part II

10 -Moving Data from Python to SQL - Part III

6 - Analyzing the Obtained Data in Tableau

1 -Tableau Analysis - Age vs Probability

2 -Tableau Analysis - Reasons vs Probability

3 -Tableau Analysis - Transportation Expense vs Probability

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy