FULL SOURCE CODE: POSTGRESQL AND DATA SCIENCE FOR PROGRAMMERS WITH PYTHON GUI

FULL SOURCE CODE: POSTGRESQL AND DATA SCIENCE FOR PROGRAMMERS WITH PYTHON GUI
Author :
Publisher : BALIGE PUBLISHING
Total Pages : 496
Release :
ISBN-10 :
ISBN-13 :
Rating : 4/5 ( Downloads)

Book Synopsis FULL SOURCE CODE: POSTGRESQL AND DATA SCIENCE FOR PROGRAMMERS WITH PYTHON GUI by : Vivian Siahaan

Download or read book FULL SOURCE CODE: POSTGRESQL AND DATA SCIENCE FOR PROGRAMMERS WITH PYTHON GUI written by Vivian Siahaan and published by BALIGE PUBLISHING. This book was released on 2022-09-19 with total page 496 pages. Available in PDF, EPUB and Kindle. Book excerpt: This project uses the PostgreSQL version of MySQL-based 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 database from https://dev.mysql.com/doc/sakila/en/. 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 store have most sales; plot average payment amount by month with mean and EWM; and plot payment amount over June 2005.

FULL SOURCE CODE: POSTGRESQL AND DATA SCIENCE FOR PROGRAMMERS WITH PYTHON GUI Related Books

FULL SOURCE CODE: POSTGRESQL AND DATA SCIENCE FOR PROGRAMMERS WITH PYTHON GUI
Language: en
Pages: 496
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-09-19 - Publisher: BALIGE PUBLISHING

GET EBOOK

This project uses the PostgreSQL version of MySQL-based Sakila sample database which is a fictitious database designed to represent a DVD rental store. The tabl
FULL SOURCE CODE: POSTGRESQL FOR DATA SCIENTISTS AND DATA ANALYSTS WITH PYTHON GUI
Language: en
Pages: 360
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-09-06 - Publisher: BALIGE PUBLISHING

GET EBOOK

In this project, we will use the PostgreSQL version of SQL Server based BikeStores as a sample database to help you work with PostgreSQL quickly and effectively
FIVE PROJECTS: POSTGRESQL AND PYTHON GUI FOR DATA ANALYSIS
Language: en
Pages: 2257
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-11-03 - Publisher: BALIGE PUBLISHING

GET EBOOK

PROJECT 1: ZERO TO MASTERY: THE COMPLETE GUIDE TO LEARNING POSTGRESQL WITH PYTHON GUI This book uses the PostgreSQL version of MySQL-based Northwind database. T
FULL SOURCE CODE: THE COMPLETE GUIDE TO LEARNING POSTGRESQL AND DATA SCIENCE WITH PYTHON GUI
Language: en
Pages: 465
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-09-01 - Publisher: BALIGE PUBLISHING

GET EBOOK

In this project, we provide you with the PostgreSQL version of SQLite sample database named chinook. The chinook sample database is a good database for practici
FULL SOURCE CODE: POSTGRESQL FOR DATA ANALYTICS AND VISUALIZATION WITH PYTHON GUI
Language: en
Pages: 460
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-09-13 - Publisher: BALIGE PUBLISHING

GET EBOOK

In this project, we provide you with a PostgreSQL version of an Oracle sample database named OT which is based on a global fictitious company that sells compute