|
Chinook Database in Python (Albun Top 10)
|
|
Apr-23-2023, 11:28 AM
(This post was last modified: Apr-23-2023, 11:29 AM by Kessie1971.)
How do I make a python program that prints an album top 10 of the albums that have been listened to most often from the Chinook database. The output of the application takes the following form:
Attached Files
Thumbnail(s)
Apr-23-2023, 03:37 PM
What have you tried?
Is the database local or are you connecting to a remote server?
Sig:
>>> import this The UNIX philosophy: "Do one thing, and do it well." "The danger of computers becoming like humans is not as great as the danger of humans becoming like computers." :~ Konrad Zuse "Everything should be made as simple as possible, but not simpler." :~ Albert Einstein
Apr-23-2023, 03:54 PM
I have a local database file chinook.db but don’t now how I get the top 10 loost listen albums with python
Apr-23-2023, 04:38 PM
How much Python coding have you done? Do you know how to construct loop and branches?
I'd use the sqlite3 package for for the kind of a project and this tutorial should get you started, least ways.
Sig:
>>> import this The UNIX philosophy: "Do one thing, and do it well." "The danger of computers becoming like humans is not as great as the danger of humans becoming like computers." :~ Konrad Zuse "Everything should be made as simple as possible, but not simpler." :~ Albert Einstein
Apr-23-2023, 05:23 PM
Apr-23-2023, 05:29 PM
Thanks for your answer but how get I get with a query the top listen 10 albums
Apr-23-2023, 05:38 PM
(This post was last modified: Apr-23-2023, 05:51 PM by deanhystad.)
Is this link talking about the database you are using for your assignment?
https://docs.yugabyte.com/preview/sample...%20library
Apr-23-2023, 05:50 PM
Sorry I can open your link
Apr-23-2023, 05:58 PM
Sorry, try now.
Your database will have a schema that defines how all the tables are linked. The entity relationship in the link I provided documents the schem for a chinook database that contains music information. I don't know if this is the database you are using or not. Once you find the schema, you'll need to find out what table contains the information you are looking for When you know that, you write a query to get the info. It is likely that the query can be written to sort the responses in decreasing order and limit the number of responses to 10. But it all starts with finding where the information is in your database.
Apr-24-2023, 05:23 AM
Yes this is the database
|
|
|
