FULL SOURCE CODE: PRACTICAL DATA SCIENCE WITH MYSQL AND PYTHON GUI

Name: FULL SOURCE CODE: PRACTICAL DATA SCIENCE WITH MYSQL AND PYTHON GUI
Brand: BALIGE PUBLISHING
SKU: 01866573

Cargando comentarios…

$232

Envío gratis siempre

Comentarios

Cargando el resumen…

Por favor, inicia sesión para escribir un comentario.

Cargando comentarios…

1899445FULL SOURCE CODE: PRACTICAL DATA SCIENCE WITH MYSQL AND PYTHON GUIhttps://www.gandhi.com.mx/full-source-code-practical-data-science-with-mysql-and-python-gui/phttps://gandhi.vtexassets.com/arquivos/ids/1245085/d9e71b07-473b-4a9b-9191-db463012f45e.jpg?v=638337694843900000232232MXNBALIGE PUBLISHINGInStock/Ebooks/In this project, we provide you with the MySQL version of SQLite sample database named chinook. The chinook sample database is a good database for practicing with SQL, especially SQLite. The detailed description of the database can be found on: https://www.sqlitetutorial.net/sqlite-sample-database/.There are 11 tables in the chinook sample database:The employee table stores employees data such as employee id, last name, first name, etc. It also has a field named ReportsTo to specify who reports to whom; customers table stores customers data; invoices & invoice_items tables: these two tables store invoice data. The invoice table stores invoice header data and the invoice_items table stores the invoice line items data; The artist table stores artists data. It is a simple table that contains only the artist id and name; The album table stores data about a list of tracks. Each album belongs to one artist. However, one artist may have multiple albums; The media_type table stores media types such as MPEG audio and AAC audio files; genre table stores music types such as rock, jazz, metal, etc; The track table stores the data of songs. Each track belongs to one album; playlist & playlist_track tables: The playlist table store data about playlists. Each playlist contains a list of tracks. Each track may belong to multiple playlists. The relationship between the playlist table and track table is many-to-many. The playlist_track table is used to reflect this relationship.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 order date by year, quarter, month, week, and day; the distribution of amount by year, quarter, month, week, day, and hour; the bottom/top 10 sales by employee, the bottom/top 10 sales by customer, the bottom/top 10 sales by customer, the bottom/top 10 sales by artist, the bottom/top 10 sales by genre, the bottom/top 10 sales by play list, the bottom/top 10 sales by customer city, the bottom/top 10 sales by customer city, the bottom/top 10 sales by customer city, the payment amount by month with mean and EWM, the average payment amount by every month, and amount payment in all years....1866573FULL SOURCE CODE: PRACTICAL DATA SCIENCE WITH MYSQL AND PYTHON GUI232232https://www.gandhi.com.mx/full-source-code-practical-data-science-with-mysql-and-python-gui/phttps://gandhi.vtexassets.com/arquivos/ids/1245085/d9e71b07-473b-4a9b-9191-db463012f45e.jpg?v=638337694843900000InStockMXN99999DIEbook20221230005703722_W3siaWQiOiI5MDAxMTMyYy1lMGZiLTQ5ZTUtYjlmYy0xMDU2OTFiN2JlYmUiLCJsaXN0UHJpY2UiOjIzMiwiZGlzY291bnQiOjAsInNlbGxpbmdQcmljZSI6MjMyLCJpbmNsdWRlc1RheCI6dHJ1ZSwicHJpY2VUeXBlIjoiSXBwIiwiY3VycmVuY3kiOiJNWE4iLCJmcm9tIjoiMjAyNS0wOS0wN1QwMjowMDowMFoiLCJ0byI6IjIwMjUtMDktMzBUMjM6NTk6NTlaIiwicmVnaW9uIjoiTVgiLCJpc1ByZW9yZGVyIjpmYWxzZX0seyJpZCI6IjUyZWY3Yzg3LWEzZDgtNDEyNi1iNDdmLTQxOWIwYzk1M2IzOSIsImxpc3RQcmljZSI6MjI0LCJkaXNjb3VudCI6MCwic2VsbGluZ1ByaWNlIjoyMjQsImluY2x1ZGVzVGF4Ijp0cnVlLCJwcmljZVR5cGUiOiJJcHAiLCJjdXJyZW5jeSI6Ik1YTiIsImZyb20iOiIyMDI1LTEwLTAxVDAwOjAwOjAwWiIsInJlZ2lvbiI6Ik1YIiwiaXNQcmVvcmRlciI6ZmFsc2V9XQ==1230005703722_In this project, we provide you with the MySQL version of SQLite sample database named chinook. The chinook sample database is a good database for practicing with SQL, especially SQLite. The detailed description of the database can be found on: https://www.sqlitetutorial.net/sqlite-sample-database/.There are 11 tables in the chinook sample database:The employee table stores employees data such as employee id, last name, first name, etc. It also has a field named ReportsTo to specify who reports to whom; customers table stores customers data; invoices & invoice_items tables: these two tables store invoice data. The invoice table stores invoice header data and the invoice_items table stores the invoice line items data; The artist table stores artists data. It is a simple table that contains only the artist id and name; The album table stores data about a list of tracks. Each album belongs to one artist. However, one artist may have multiple albums; The media_type table stores media types such as MPEG audio and AAC audio files; genre table stores music types such as rock, jazz, metal, etc; The track table stores the data of songs. Each track belongs to one album; playlist & playlist_track tables: The playlist table store data about playlists. Each playlist contains a list of tracks. Each track may belong to multiple playlists. The relationship between the playlist table and track table is many-to-many. The playlist_track table is used to reflect this relationship.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 order date by year, quarter, month, week, and day; the distribution of amount by year, quarter, month, week, day, and hour; the bottom/top 10 sales by employee, the bottom/top 10 sales by customer, the bottom/top 10 sales by customer, the bottom/top 10 sales by artist, the bottom/top 10 sales by genre, the bottom/top 10 sales by play list, the bottom/top 10 sales by customer city, the bottom/top 10 sales by customer city, the bottom/top 10 sales by customer city, the payment amount by month with mean and EWM, the average payment amount by every month, and amount payment in all years.(*_*)1230005703722_In this project, we provide you with the MySQL version of SQLite sample database named chinook. The chinook sample database is a good database for practicing with SQL, especially SQLite. The detailed description of the database can be found on: https://www.sqlitetutorial.net/sqlite-sample-database/.There are 11 tables in the chinook sample database:The employee table stores employees data such as employee id, last name, first name, etc. It also has a field named ReportsTo to specify who reports to whom; customers table stores customers data; invoices & invoice_items tables: these two tables store invoice data. The invoice table stores invoice header data and the invoice_items table stores the invoice line items data; The artist table stores artists data. It is a simple table that contains only the artist id and name; The album table stores data about a list of tracks. Each album belongs to one artist. However, one artist may have multiple albums; The media_type table stores media types such as MPEG audio and AAC audio files; genre table stores music types such as rock, jazz, metal, etc; The track table stores the data of songs. Each track belongs to one album; playlist & playlist_track tables: The playlist table store data about playlists. Each playlist contains a list of tracks. Each track may belong to multiple playlists. The relationship between the playlist table and track table is many-to-many. The playlist_track table is used to reflect this relationship.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 order date by year, quarter, month, week, and day; the distribution of amount by year, quarter, month, week, day, and hour; the bottom/top 10 sales by employee, the bottom/top 10 sales by customer, the bottom/top 10 sales by customer, the bottom/top 10 sales by artist, the bottom/top 10 sales by genre, the bottom/top 10 sales by play list, the bottom/top 10 sales by customer city, the bottom/top 10 sales by customer city, the bottom/top 10 sales by customer city, the payment amount by month with mean and EWM, the average payment amount by every month, and amount payment in all years....1230005703722_BALIGE PUBLISHINGlibro_electonico_3004469d-53cd-300d-a663-ce6b901d1d26_1230005703722;1230005703722_1230005703722Rismon HasiholanInglésMéxicohttps://getbook.kobo.com/koboid-prod-public/f2ca928b-958d-498f-bb70-f76c6615d8f6-epub-50c49529-a577-47cc-96ca-95c319e949e5.epub2022-08-06T00:00:00+00:00BALIGE PUBLISHING