#NEWLINE# def head( self , n = 6 ) : #NEWLINE# #INDENT# '\n        Returns first n values of your table as a DataFrame. This is executing:\n            SELECT\n                *\n            FROM\n                <name_of_the_table>\n            LIMIT <n>\n\n        Parameters\n        ----------\n        n: int\n            number of rows to return\n\n        Examples\n        --------\n        >>> from db import DemoDB\n        >>> db = DemoDB()\n        \n        \n        >>> db.tables.Track.count\n        3503\n        \n        -= Not in doctest as output is hard to predict\n        # select name from the Track table        \n        db.tables.Track.head()\n           TrackId                                     Name  AlbumId  MediaTypeId          0        1  For Those About To Rock (We Salute You)        1            1\n        1        2                        Balls to the Wall        2            2\n        2        3                          Fast As a Shark        3            2\n        3        4                        Restless and Wild        3            2\n        4        5                     Princess of the Dawn        3            2\n        5        6                    Put The Finger On You        1            1\n\n           GenreId                                           Composer  Milliseconds          0        1          Angus Young, Malcolm Young, Brian Johnson        343719\n        1        1                                               None        342562\n        2        1  F. Baltes, S. Kaufman, U. Dirkscneider & W. Ho...        230619\n        3        1  F. Baltes, R.A. Smith-Diesel, S. Kaufman, U. D...        252051\n        4        1                         Deaffy & R.A. Smith-Diesel        375418\n        5        1          Angus Young, Malcolm Young, Brian Johnson        205662\n\n              Bytes  UnitPrice\n        0  11170334       0.99\n        1   5510424       0.99\n        2   3990994       0.99\n        3   4331779       0.99\n        4   6290521       0.99\n        5   6713451       0.99\n        \n        db.tables.Track.head(1)\n           TrackId                                     Name  AlbumId  MediaTypeId          0        1  For Those About To Rock (We Salute You)        1            1\n\n           GenreId                                   Composer  Milliseconds     Bytes          0        1  Angus Young, Malcolm Young, Brian Johnson        343719  11170334\n\n           UnitPrice\n        0       0.99\n        ' #NEWLINE# q = self . _query_templates [ 'table' ] [ 'head' ] . format ( schema = self . schema , table = self . name , n = n ) #NEWLINE# return pd . read_sql ( q , self . _con )