Classic books
Time to use your new DataFrame skills to analyze the books dataset one last time.
You are working for a publisher that wants to spotlight classic books this month. Can you analyze the DataFrame df_books to find the top-rated books published before 1900?
df_books is available in your environment.
This exercise is part of the course
Introduction to Julia
Exercise instructions
- Filter the DataFrame to rows where the integer in the
original_publication_yearcolumn is less than 1900. - Sort the
df_old_booksDataFrame by theaverage_ratingcolumn, sorting from high to low. - Print the first five rows of the DataFrame to show the top-rated old books.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Filter to books which were published before 1900
df_old_books = ____(row -> ____, ____)
# Sort these books by rating
df_old_books_sorted = ____(____, "____", rev=____)
# Print the 5 top-rated old books
println(____)