Loading a dataframe from a parquet file
A dataframe file called sherlock_sentences.parquet is available in your workspace. Each row of this dataframe contains a single clause. Each clause is a sequence of words that is separated from other clauses by punctuation, such as periods, quotes, and other natural language delimiters that signify a sentence or sentence fragment. Your mission, if you choose to accept it, is to load this file.
This exercise is part of the course
Introduction to Spark SQL in Python
Exercise instructions
- Load
sherlock_sentences.parquet. - Filter on "id > 70", and show the first 5 rows.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Load the dataframe
df = ____('sherlock_sentences.parquet')
# Filter and show the first 5 rows
df.where('id > 70').____(____, truncate=False)