I am trying to make a bar graph using ggplot2
the data looks like this (there are about 10000 observations) and i have around 60 different subgroups.
ID subgroup patient_group
1866 cancer 1
1877 heart failure 1
1878 cancer 2
1879 infection 1
... ...
What I would like to do is sort the subgroups by count instead of alphabetically, so the graph is easier to read. this is my code so far.
ggplot(data = data, aes(x = subgroup, fill = patient_group)) +
geom_bar(position = "dodge") +
coord_flip() +
ggtitle("Count of Subgroups of patients") +
xlab("") +
ylab("") +
labs(fill = "Emerge Version")
Is there a way to reorder the bars without having to make a new dataframe for the subgroups? Thanks!