How to recode a factor in order to make a pie chart

[saharazh]

I have a column (in a dataframe, with each row represent a paper published) called Publisher. It's a factor. I used this code to run a frequency table:
table(data$Publisher) %>%
sort(decreasing=TRUE)

I got a frequency table like this:
BMC
28
PloS
18
Springer Nature
9
Elsevier
5
BMJ
3
(here I omitted many other values with frequency less than 3)

I'm trying to regroup all the publishers with value less than 3 into "Other", because I'm hoping to group those publishers with which not many papers have been published into Other in a pie chart. Otherwise the pie chart would get too crowded and not meaningful. But I'm stuck here with recoding Publisher. Can anybody help?

[andresrcs]

You can use fct_lump() or fct_other() from forcats package

If you need more specific help, please turn this into a self-contained REPRoducible EXample (reprex) A reprex makes it much easier for others to understand your issue and figure out how to help.

If you've never heard of a reprex before, you might want to start by reading this FAQ:

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

[saharazh]

Thanks so much for your help! I've never heard of forecats but it sounds exactly what I need! I'll try it out.
Thanks also for the info about Reproducible example. I'll use it if I still can't figure this issue out.

[saharazh]

It worked! Here is my code:

data%>% 
    mutate(Publisher=fct_lump(Publisher, n=6))%>%
    count(Publisher)

Thanks again!

[andresrcs]

If your question's been answered (even by you!), would you mind choosing a solution? It helps other people see which questions still need help, or find solutions if they have similar problems. Here’s how to do it:

FAQ: How do I mark a solution?

If your question has been answered, don't forget to mark the solution! How do I mark a solution? Find the reply you want to mark as the solution and look for the row of small gray icons at the bottom of that reply. Click the one that looks like a box with a checkmark in it: [image] Hovering over the mark solution button shows the label, "Select if this reply solves the problem". If you don't see the mark solution button, try clicking the three dots button ( ••• ) to expand the full set of options. When a solution is chosen, the icon turns green and the hover label changes to: "Unselect if this reply no longer solves the problem". Success! [solution_reply_author] …

[saharazh]

done! thanks for the reminder! And many thanks for introducing me to forcats!