In [1]:
from db import DemoDB
In [2]:
data = DemoDB()
Indexing schema. This will take a second...finished!
In [3]:
data.tables
Refreshing schema. Please wait...done!
Out[3]:
Table
Columns
Album
AlbumId, Title, ArtistId
Artist
ArtistId, Name
Customer
CustomerId, FirstName, LastName, Company, Address, City, State, Country, PostalC
ode, Phone, Fax, Email, SupportRepId
Employee
EmployeeId, LastName, FirstName, Title, ReportsTo, BirthDate, HireDate, Address,
City, State, Country, PostalCode, Phone, Fax, Email
Genre
GenreId, Name
Invoice
InvoiceId, CustomerId, InvoiceDate, BillingAddress, BillingCity, BillingState, B
illingCountry, BillingPostalCode, Total
InvoiceLine
InvoiceLineId, InvoiceId, TrackId, UnitPrice, Quantity
MediaType
MediaTypeId, Name
Playlist
PlaylistId, Name
PlaylistTrack
PlaylistId, TrackId
Track
TrackId, Name, AlbumId, MediaTypeId, GenreId, Composer, Milliseconds, Bytes, Uni
tPrice
In [4]:
tracks = data.query("select * from Track")
In [9]:
print(tracks)
TrackId Name AlbumId \
0 1 For Those About To Rock (We Salute You) 1
1 2 Balls to the Wall 2
2 3 Fast As a Shark 3
3 4 Restless and Wild 3
4 5 Princess of the Dawn 3
5 6 Put The Finger On You 1
6 7 Let's Get It Up 1
7 8 Inject The Venom 1
8 9 Snowballed 1
9 10 Evil Walks 1
10 11 C.O.D. 1
11 12 Breaking The Rules 1
12 13 Night Of The Long Knives 1
13 14 Spellbound 1
14 15 Go Down 4
15 16 Dog Eat Dog 4
16 17 Let There Be Rock 4
17 18 Bad Boy Boogie 4
18 19 Problem Child 4
19 20 Overdose 4
20 21 Hell Ain't A Bad Place To Be 4
21 22 Whole Lotta Rosie 4
22 23 Walk On Water 5
23 24 Love In An Elevator 5
24 25 Rag Doll 5
25 26 What It Takes 5
26 27 Dude (Looks Like A Lady) 5
27 28 Janie's Got A Gun 5
28 29 Cryin' 5
29 30 Amazing 5
... ... ... ...
3473 3474 October Song 322
3474 3475 What Is It About Men 322
3475 3476 Help Yourself 322
3476 3477 Amy Amy Amy (Outro) 322
3477 3478 Slowness 323
3478 3479 Prometheus Overture, Op. 43 324
3479 3480 Sonata for Solo Violin: IV: Presto 325
3480 3481 A Midsummer Night's Dream, Op.61 Incidental Mu... 326
3481 3482 Suite No. 3 in D, BWV 1068: III. Gavotte I & II 327
3482 3483 Concert pour 4 Parties de V**les, H. 545: I. P... 328
3483 3484 Adios nonino 329
3484 3485 Symphony No. 3 Op. 36 for Orchestra and Sopran... 330
3485 3486 Act IV, Symphony 331
3486 3487 3 Gymnopédies: No.1 - Lent Et Grave, No.3 - Le... 332
3487 3488 Music for the Funeral of Queen Mary: VI. "Thou... 333
3488 3489 Symphony No. 2: III. Allegro vivace 334
3489 3490 Partita in E Major, BWV 1006A: I. Prelude 335
3490 3491 Le Sacre Du Printemps: I.iv. Spring Rounds 336
3491 3492 Sing Joyfully 314
3492 3493 Metopes, Op. 29: Calypso 337
3493 3494 Symphony No. 2, Op. 16 - "The Four Temperamen... 338
3494 3495 24 Caprices, Op. 1, No. 24, for Solo Violin, i... 339
3495 3496 Étude 1, In C Major - Preludio (Presto) - Liszt 340
3496 3497 Erlkonig, D.328 341
3497 3498 Concerto for Violin, Strings and Continuo in G... 342
3498 3499 Pini Di Roma (Pinien Von Rom) \ I Pini Della V... 343
3499 3500 String Quartet No. 12 in C Minor, D. 703 "Quar... 344
3500 3501 L'orfeo, Act 3, Sinfonia (Orchestra) 345
3501 3502 Quintet for Horn, Violin, 2 Violas, and Cello ... 346
3502 3503 Koyaanisqatsi 347
MediaTypeId GenreId Composer \
0 1 1 Angus Young, Malcolm Young, Brian Johnson
1 2 1 None
2 2 1 F. Baltes, S. Kaufman, U. Dirkscneider & W. Ho...
3 2 1 F. Baltes, R.A. Smith-Diesel, S. Kaufman, U. D...
4 2 1 Deaffy & R.A. Smith-Diesel
5 1 1 Angus Young, Malcolm Young, Brian Johnson
6 1 1 Angus Young, Malcolm Young, Brian Johnson
7 1 1 Angus Young, Malcolm Young, Brian Johnson
8 1 1 Angus Young, Malcolm Young, Brian Johnson
9 1 1 Angus Young, Malcolm Young, Brian Johnson
10 1 1 Angus Young, Malcolm Young, Brian Johnson
11 1 1 Angus Young, Malcolm Young, Brian Johnson
12 1 1 Angus Young, Malcolm Young, Brian Johnson
13 1 1 Angus Young, Malcolm Young, Brian Johnson
14 1 1 AC/DC
15 1 1 AC/DC
16 1 1 AC/DC
17 1 1 AC/DC
18 1 1 AC/DC
19 1 1 AC/DC
20 1 1 AC/DC
21 1 1 AC/DC
22 1 1 Steven Tyler, Joe Perry, Jack Blades, Tommy Shaw
23 1 1 Steven Tyler, Joe Perry
24 1 1 Steven Tyler, Joe Perry, Jim Vallance, Holly K...
25 1 1 Steven Tyler, Joe Perry, Desmond Child
26 1 1 Steven Tyler, Joe Perry, Desmond Child
27 1 1 Steven Tyler, Tom Hamilton
28 1 1 Steven Tyler, Joe Perry, Taylor Rhodes
29 1 1 Steven Tyler, Richie Supa
... ... ... ...
3473 2 9 Matt Rowe & Stefan Skarbek
3474 2 9 Delroy "Chris" Cooper, Donovan Jackson, Earl C...
3475 2 9 Freddy James, Jimmy hogarth & Larry Stock
3476 2 9 Astor Campbell, Delroy "Chris" Cooper, Donovan...
3477 2 23 None
3478 4 24 Ludwig van Beethoven
3479 4 24 Béla Bartók
3480 2 24 None
3481 2 24 Johann Sebastian Bach
3482 2 24 Marc-Antoine Charpentier
3483 2 24 Astor Piazzolla
3484 2 24 Henryk Górecki
3485 2 24 Henry Purcell
3486 2 24 Erik Satie
3487 2 24 Henry Purcell
3488 2 24 Kurt Weill
3489 2 24 Johann Sebastian Bach
3490 2 24 Igor Stravinsky
3491 2 24 William Byrd
3492 2 24 Karol Szymanowski
3493 2 24 Carl Nielsen
3494 2 24 Niccolò Paganini
3495 4 24 None
3496 2 24 None
3497 4 24 Pietro Antonio Locatelli
3498 2 24 None
3499 2 24 Franz Schubert
3500 2 24 Claudio Monteverdi
3501 2 24 Wolfgang Amadeus Mozart
3502 2 10 Philip Glass
Milliseconds Bytes UnitPrice
0 343719 11170334 0.99
1 342562 5510424 0.99
2 230619 3990994 0.99
3 252051 4331779 0.99
4 375418 6290521 0.99
5 205662 6713451 0.99
6 233926 7636561 0.99
7 210834 6852860 0.99
8 203102 6599424 0.99
9 263497 8611245 0.99
10 199836 6566314 0.99
11 263288 8596840 0.99
12 205688 6706347 0.99
13 270863 8817038 0.99
14 331180 10847611 0.99
15 215196 7032162 0.99
16 366654 12021261 0.99
17 267728 8776140 0.99
18 325041 10617116 0.99
19 369319 12066294 0.99
20 254380 8331286 0.99
21 323761 10547154 0.99
22 295680 9719579 0.99
23 321828 10552051 0.99
24 264698 8675345 0.99
25 310622 10144730 0.99
26 264855 8679940 0.99
27 330736 10869391 0.99
28 309263 10056995 0.99
29 356519 11616195 0.99
... ... ... ...
3473 204846 3358125 0.99
3474 209573 3426106 0.99
3475 300884 5029266 0.99
3476 663426 10564704 0.99
3477 215386 3644793 0.99
3478 339567 10887931 0.99
3479 299350 9785346 0.99
3480 387826 6497867 0.99
3481 225933 3847164 0.99
3482 110266 1973559 0.99
3483 289388 4781384 0.99
3484 567494 9273123 0.99
3485 364296 5987695 0.99
3486 385506 6458501 0.99
3487 142081 2365930 0.99
3488 376510 6129146 0.99
3489 285673 4744929 0.99
3490 234746 4072205 0.99
3491 133768 2256484 0.99
3492 333669 5548755 0.99
3493 286998 4834785 0.99
3494 265541 4371533 0.99
3495 51780 2229617 0.99
3496 261849 4307907 0.99
3497 493573 16454937 0.99
3498 286741 4718950 0.99
3499 139200 2283131 0.99
3500 66639 1189062 0.99
3501 221331 3665114 0.99
3502 206005 3305164 0.99
[3503 rows x 9 columns]
In [8]:
tracks[tracks['Milliseconds'] > 343719]
Out[8]:
TrackId
Name
AlbumId
MediaTypeId
GenreId
Composer
Milliseconds
Bytes
UnitPrice
4
5
Princess of the Dawn
3
2
1
Deaffy & R.A. Smith-Diesel
375418
6290521
0.99
16
17
Let There Be Rock
4
1
1
AC/DC
366654
12021261
0.99
19
20
Overdose
4
1
1
AC/DC
369319
12066294
0.99
29
30
Amazing
5
1
1
Steven Tyler, Richie Supa
356519
11616195
0.99
36
37
Livin' On The Edge
5
1
1
Steven Tyler, Joe Perry, Mark Hudson
381231
12374569
0.99
49
50
You Oughta Know (Alternate)
6
1
1
Alanis Morissette & Glenn Ballard
491885
16008629
0.99
52
53
Sea Of Sorrow
7
1
1
Jerry Cantrell
349831
11316328
0.99
55
56
Love, Hate, Love
7
1
1
Jerry Cantrell, Layne Staley
387134
12575396
0.99
59
60
Confusion
7
1
1
Jerry Cantrell, Michael Starr, Layne Staley
344163
11183647
0.99
74
75
O Boto (Bôto)
8
1
2
None
366837
12089673
0.99
77
78
Master Of Puppets
9
1
3
Apocalyptica
436453
14375310
0.99
78
79
Harvester Of Sorrow
9
1
3
Apocalyptica
374543
12372536
0.99
82
83
Wherever I May Roam
9
1
3
Apocalyptica
369345
12033110
0.99
83
84
Welcome Home (Sanitarium)
9
1
3
Apocalyptica
350197
11406431
0.99
123
124
Snoopy's search-Red baron
13
1
2
Billy Cobham
456071
15075616
0.99
126
127
Stratus
13
1
2
Billy Cobham
582086
19115680
0.99
140
141
World Of Trouble
14
1
3
None
359157
11820932
0.99
141
142
No More Tears
14
1
3
None
555075
18041629
0.99
142
143
The Begining... At Last
14
1
3
None
365662
11965109
0.99
144
145
Snowblind
15
1
3
None
420022
13842549
0.99
148
149
Black Sabbath
16
1
3
None
382066
12440200
0.99
151
152
N.I.B.
16
1
3
None
368770
12029390
0.99
153
154
Sleeping Village
16
1
3
None
644571
21128525
0.99
155
156
Wheels Of Confusion / The Straightener
17
1
3
Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osb...
494524
16065830
0.99
164
165
Under The Sun/Every Day Comes and Goes
17
1
3
Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osb...
350458
11360486
0.99
175
176
The Winner Loses
18
1
4
None
392254
12843821
0.99
176
177
There Goes The Neighborhood
18
1
4
None
350171
11443471
0.99
180
181
Momma's Gotta Die Tonight
18
1
4
None
371539
12122946
0.99
186
187
Book Of Thel
19
1
3
Eddie Casillas/Roy Z
494393
16034404
0.99
188
189
Jerusalem
19
1
3
Roy Z
402390
13194463
0.99
...
...
...
...
...
...
...
...
...
...
3364
3365
Say Hello 2 Heaven
269
2
23
None
384497
6477217
0.99
3365
3366
Reach Down
269
2
23
None
672773
11157785
0.99
3372
3373
Four Walled World
269
2
23
None
414474
6964048
0.99
3403
3404
Miserere mei, Deus
273
2
24
Gregorio Allegri
501503
8285941
0.99
3409
3410
The Messiah: Behold, I Tell You a Mystery... T...
279
2
24
George Frideric Handel
582029
9553140
0.99
3411
3412
"Eine Kleine Nachtmusik" Serenade In G, K. 525...
281
2
24
Wolfgang Amadeus Mozart
348971
5760129
0.99
3412
3413
Concerto for Clarinet in A Major, K. 622: II. ...
282
2
24
Wolfgang Amadeus Mozart
394482
6474980
0.99
3414
3415
Symphony No.5 in C Minor: I. Allegro con brio
284
2
24
Ludwig van Beethoven
392462
6419730
0.99
3422
3423
Jupiter, the Bringer of Jollity
292
2
24
Gustav Holst
522099
8547876
0.99
3424
3425
Adagio for Strings from the String Quartet, Op...
294
2
24
Samuel Barber
596519
9585597
0.99
3427
3428
Branch Closing
251
3
22
None
1814855
360331351
1.99
3428
3429
The Return
251
3
22
None
1705080
343877320
1.99
3431
3432
Scheherazade, Op. 35: I. The Sea and Sindbad's...
299
2
24
Nikolai Rimsky-Korsakov
545203
8916313
0.99
3433
3434
Concerto for Piano No. 2 in F Minor, Op. 21: I...
301
2
24
Frédéric Chopin
560342
9160082
0.99
3435
3436
Karelia Suite, Op.11: 2. Ballade (Tempo Di Men...
303
2
24
Jean Sibelius
406000
5908455
0.99
3436
3437
Piano Sonata No. 14 in C Sharp Minor, Op. 27, ...
304
2
24
Ludwig van Beethoven
391000
6318740
0.99
3439
3440
Concerto for Cello and Orchestra in E minor, O...
306
2
24
Edward Elgar
483133
7865479
0.99
3441
3442
Wellington's Victory or the Battle Symphony, O...
308
2
24
Ludwig van Beethoven
412000
6965201
0.99
3444
3445
On the Beautiful Blue Danube
311
2
24
Johann Strauss II
526696
8610225
0.99
3445
3446
Symphonie Fantastique, Op. 14: V. Songe d'une ...
312
2
24
Hector Berlioz
561967
9173344
0.99
3453
3454
Symphony No. 41 in C Major, K. 551, "Jupiter":...
320
2
24
Wolfgang Amadeus Mozart
362933
6173269
0.99
3465
3466
Rehab (Hot Chip Remix)
321
2
14
None
418293
6670600
0.99
3467
3468
You Sent Me Flying / Cherry
322
2
9
None
409906
6657517
0.99
3476
3477
Amy Amy Amy (Outro)
322
2
9
Astor Campbell, Delroy "Chris" Cooper, Donovan...
663426
10564704
0.99
3480
3481
A Midsummer Night's Dream, Op.61 Incidental Mu...
326
2
24
None
387826
6497867
0.99
3484
3485
Symphony No. 3 Op. 36 for Orchestra and Sopran...
330
2
24
Henryk Górecki
567494
9273123
0.99
3485
3486
Act IV, Symphony
331
2
24
Henry Purcell
364296
5987695
0.99
3486
3487
3 Gymnopédies: No.1 - Lent Et Grave, No.3 - Le...
332
2
24
Erik Satie
385506
6458501
0.99
3488
3489
Symphony No. 2: III. Allegro vivace
334
2
24
Kurt Weill
376510
6129146
0.99
3497
3498
Concerto for Violin, Strings and Continuo in G...
342
4
24
Pietro Antonio Locatelli
493573
16454937
0.99
706 rows × 9 columns
In [ ]:
Content source: gileno/curso-citi
Similar notebooks: