In [13]:

    

from metal_lyric_data import *


    

In [14]:

    

df_artist = get_artist_genre_table(500)


    

In [15]:

    

df_artist.info()


    

    




<class 'pandas.core.frame.DataFrame'>
Int64Index: 600 entries, 0 to 599
Data columns (total 3 columns):
artist     600 non-null object
genre      600 non-null object
country    600 non-null object
dtypes: object(3)
memory usage: 18.8+ KB

In [26]:

    

df_artist.tail()


    

    
Out[26]:






  

    

      

      
artist
      
genre
      
country
    
  
  

    

      
595
      
A.G.R.E.S.O.R.
      
Thrash Metal
      
Argentina
    
    

      
596
      
A.I.D.S.
      
Black Metal
      
United States
    
    

      
597
      
A.I.T.H.
      
Heavy Metal
      
Japan
    
    

      
598
      
A.L.M.A.
      
Heavy Metal
      
Argentina
    
    

      
599
      
A.L.M.A.S.
      
Heavy Metal
      
Argentina
    
  

In [17]:

    

df_songs = get_song_table(500)


    

In [24]:

    

df_songs.info()


    

    




<class 'pandas.core.frame.DataFrame'>
Int64Index: 600 entries, 0 to 599
Data columns (total 5 columns):
artist        600 non-null object
album         600 non-null object
album_type    600 non-null object
song          600 non-null object
lyric_id      600 non-null int64
dtypes: int64(1), object(4)
memory usage: 28.1+ KB

In [25]:

    

df_songs.iloc[206:211, :]


    

    
Out[25]:






  

    

      

      
artist
      
album
      
album_type
      
song
      
lyric_id
    
  
  

    

      
206
      
$ilverdollar
      
Covers from Hell
      
Full-length
      
Aces High (Iron Maiden cover)
      
803064
    
    

      
207
      
$ilverdollar
      
Covers from Hell
      
Full-length
      
Bark at the Moon (Ozzy Osbourne cover)
      
803063
    
    

      
208
      
$ilverdollar
      
Covers from Hell
      
Full-length
      
Crazy Train (Ozzy Osbourne cover)
      
803071
    
    

      
209
      
$ilverdollar
      
Covers from Hell
      
Full-length
      
Don't Talk to Strangers (Dio cover)
      
803068
    
    

      
210
      
$ilverdollar
      
Covers from Hell
      
Full-length
      
Freewheel Burning (Judas Priest cover)
      
803070
    
  

In [21]:

    

df_songs.iloc[206:211, :].lyric_id.apply(get_lyrics)


    

    
Out[21]:





206    There goes the siren that warns of the air rai...
207    SCREAMS BREAK THE SILENCE WAKING FROM THE DEAD...
208    All aboard, hah hah Crazy, but that's how it g...
209    Don't talk to strangers Mmmmh Don't talk to st...
210    Fast and furious We ride the universe To carve...
Name: lyric_id, dtype: object

In [ ]: