I have an existing data set called Olympics. I need to create a new object using dplyr that's a copy of this data set. It has to contain only records concerning "Tennis", sorted by 'Year', oldest last, and then alphabetically by 'Name' and 'Event', in that order. I also need to add a new final column, 'Prize'. For each record, it should contain 'True' if a medal was won by that competitor in that event and 'False' otherwise.
I need to do the same using base R.
The data set Olympics has info on the participants of all the sports events held at the Summer and Winter Olympics from 2010-2016. Each row is a separate record. The 'Height' column is in cm and the 'Weight' column in in Kg. The 'NOC' column indicates the 'National Olympics Committee' that sent each athlete