Open driskerr opened 6 years ago
https://github.com/jewgeney/intro-data-capstone-musclehub/blob/163399689a37b3ba7ecfc7b955f8ea20bfe90f0d/MuscleHub%20capstone%20project/musclehub.py#L57-L58
Helpful hint! You're opening up the entire dataframe with this query - if you include the command LIMIT n at the end of your query it will just print the first n rows of the table, enough to give you a sense of the data.
LIMIT n
n
i.e. here I wrote:
sql_query('''select * from visits limit 5;''')
to print the first 5 rows of the visits table
visits
https://github.com/jewgeney/intro-data-capstone-musclehub/blob/163399689a37b3ba7ecfc7b955f8ea20bfe90f0d/MuscleHub%20capstone%20project/musclehub.py#L57-L58
Helpful hint! You're opening up the entire dataframe with this query - if you include the command
LIMIT nat the end of your query it will just print the firstnrows of the table, enough to give you a sense of the data.i.e. here I wrote:
to print the first 5 rows of the
visitstable