How do I make a new dataframe based on the criteria that a particular row is included when a particular element in that row is equal to a specific string, say, "Ontario"?
I downloaded the publicly availble covid dataset from the Gov. of Canada website. I want to look at data pertaining to Ontario only. Each data entry corresponds to a row of data where the second column represents the province or territory. My goal is to create a new dataframe of rows where the second column entry is equal to the string "Ontario".
I have attached my maplesheet. I can't upload the data but it can be downloaded here: https://open.canada.ca/data/en/dataset/261c32ab-4cfd-4f81-9dea-7b64065690dc.
In the image below, see how the second column is a mix of different strings. I want a new dataframe where the second column reads only "Ontario". I have included my naive attempt to select data with 'prname'="Ontario".