MYSQL AND DATA SCIENCE: QUERIES AND VISUALIZATION WITH PYTHON GUI

MYSQL AND DATA SCIENCE: QUERIES AND VISUALIZATION WITH PYTHON GUI
Author :
Publisher : BALIGE PUBLISHING
Total Pages : 404
Release :
ISBN-10 :
ISBN-13 :
Rating : 4/5 ( Downloads)

Book Synopsis MYSQL AND DATA SCIENCE: QUERIES AND VISUALIZATION WITH PYTHON GUI by : Vivian Siahaan

Download or read book MYSQL AND DATA SCIENCE: QUERIES AND VISUALIZATION WITH PYTHON GUI written by Vivian Siahaan and published by BALIGE PUBLISHING. This book was released on 2022-06-19 with total page 404 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this project, you will write Python script to create every table and insert rows of data into each of them. You will develop GUI with PyQt5 to each table in the database. You will also create GUI to plot case distribution of film release year, film rating, rental duration, and categorize film length; plot rating variable against rental_duration variable in stacked bar plots; plot length variable against rental_duration variable in stacked bar plots; read payment table; plot case distribution of Year, Day, Month, Week, and Quarter of payment; plot which year, month, week, days of week, and quarter have most payment amount; read film list by joining five tables: category, film_category, film_actor, film, and actor; plot case distribution of top 10 and bottom 10 actors; plot which film title have least and most sales; plot which actor have least and most sales; plot which film category have least and most sales; plot case distribution of top 10 and bottom 10 overdue costumers; plot which customer have least and most overdue days; plot which store have most sales; plot average payment amount by month with mean and EWM; and plot payment amount over June 2005. This project uses the Sakila sample database which is a fictitious database designed to represent a DVD rental store. The tables of the database include film, film_category, actor, film_actor, customer, rental, payment and inventory among others. You can download the MySQL from https://dev.mysql.com/doc/sakila/en/.


MYSQL AND DATA SCIENCE: QUERIES AND VISUALIZATION WITH PYTHON GUI Related Books

MYSQL AND DATA SCIENCE: QUERIES AND VISUALIZATION WITH PYTHON GUI
Language: en
Pages: 404
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-06-19 - Publisher: BALIGE PUBLISHING

DOWNLOAD EBOOK

In this project, you will write Python script to create every table and insert rows of data into each of them. You will develop GUI with PyQt5 to each table in
SQLITE AND DATA SCIENCE: QUERIES AND VISUALIZATION WITH PYTHON GUI
Language: en
Pages: 428
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-06-15 - Publisher: BALIGE PUBLISHING

DOWNLOAD EBOOK

In this project, you will develop GUI with PyQt5 to: utilize Push Button, Combo Box, Table Widget, Line Edit, and Widget, read and create SQLite database and ev
FOUR PROJECTS: MySQL and SQLite For Data Science with Python GUI
Language: en
Pages: 1583
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-06-29 - Publisher: BALIGE PUBLISHING

DOWNLOAD EBOOK

PROJECT 1: SQLITE AND DATA SCIENCE: QUERIES AND VISUALIZATION WITH PYTHON GUI In this project, you will develop GUI with PyQt5 to: utilize Push Button, Combo Bo
DATA SCIENCE WITH MYSQL, SQLITE, POSTGRESQL, AND SQL SERVER USING PYTHON GUI
Language: en
Pages: 1667
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-10-03 - Publisher: BALIGE PUBLISHING

DOWNLOAD EBOOK

Book 1: MYSQL AND DATA SCIENCE: QUERIES AND VISUALIZATION WITH PYTHON GUI In this project, you will write Python script to create every table and insert rows of
THREE PROJECTS: SQL SERVER AND PYTHON GUI FOR DATA ANALYSIS
Language: en
Pages: 1344
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-11-08 - Publisher: BALIGE PUBLISHING

DOWNLOAD EBOOK

PROJECT 1: FULL SOURCE CODE: SQL SERVER FOR STUDENTS AND DATA SCIENTISTS WITH PYTHON GUI In this project, we provide you with the SQL SERVER version of SQLite s