I have a dataset showing the exchange rate of the Australian Dollar versus the US dollar once a day over a period of about 20 years. I have the data in a data frame, with the first column being the date, and the second column being the exchange rate. Here's a sample from the data:
>data V1 V2 1 12/12/1983 0.9175 2 13/12/1983 0.9010 3 14/12/1983 0.9000 4 15/12/1983 0.8978 5 16/12/1983 0.8928 6 19/12/1983 0.8770 7 20/12/1983 0.8795 8 21/12/1983 0.8905 9 22/12/1983 0.9005 10 23/12/1983 0.9005
How would I go about displaying the top n% of these records? E.g. say I want to see the days and exchange rates for those days where the exchange rate falls in the top 5% of all exchange rates in the dataset?
To find the most frequent factor value in an R data frame column, we can use names function with which. max function after creating the table for the particular column. This might be required while doing factorial analysis and we want to know which factor occurs the most.
max() in R The max() is a built-in R function that finds the maximum value of the vector or data frame. It takes the R object as an input and returns the maximum value out of it. To find the maximum value of vector elements, data frame, and columns, use the max() function.
For the top 5%:
n <- 5 data[data$V2 > quantile(data$V2,prob=1-n/100),]
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With