How to get top n companies from a data frame in decreasing order

by

head and tail are really useful functions!

head(sort(Forbes2000$profits,decreasing=TRUE), n = 50)

If you want the first 50 rows of the data.frame, then you can use the arrange function from plyr to sort the data.frame and then use head

library(plyr)

head(arrange(Forbes2000,desc(profits)), n = 50)

Notice that I wrapped profits in a call to desc which means it will sort in decreasing order.

To work without plyr

head(Forbes2000[order(Forbes2000$profits, decreasing= T),], n = 50)

More Related Contents:

  1. summarizing multiple variables in group by
  2. Sort (order) data frame rows by multiple columns
  3. How to select the rows with maximum values in each group with dplyr? [duplicate]
  4. How to sort a character vector where elements contain letters and numbers in R?
  5. Group by multiple columns and sum other multiple columns
  6. Reorder levels of a factor without changing order of values
  7. Fastest way to add rows for missing time steps?
  8. How does one reorder columns in a data frame?
  9. How to perform natural (lexicographic) sorting in R? [duplicate]
  10. Applying a function to every row of a table using dplyr?
  11. Remove group from data.frame if at least one group member meets condition
  12. How to quickly form groups (quartiles, deciles, etc) by ordering column(s) in a data frame
  13. Idiomatic R code for partitioning a vector by an index and performing an operation on that partition
  14. Merge two data frames while keeping the original row order
  15. What does the dot mean in R – personal preference, naming convention or more?
  16. rank and order in R
  17. Count number of rows by group using dplyr
  18. How to sort letters in a string?
  19. How to strsplit different number of strings in certain column by do function
  20. Pass a vector of variable names to arrange() in dplyr
  21. What are the R sorting rules of character vectors?
  22. Sorting each row of a data frame [duplicate]
  23. R: Split unbalanced list in data.frame column
  24. meaning of ddply error: ‘names’ attribute [9] must be the same length as the vector [1]
  25. Sorting rows alphabetically
  26. Replace missing values (NA) in one data set with values from another where columns match
  27. R use ddply or aggregate
  28. How to order my dataframe lexicographicaly
  29. Sum of rows based on column value
  30. Can `ddply` (or similar) do a sliding window?

Leave a Comment