how to create multiple values for the name column?

Question

My dataset has this form:

name = c("h", "s", "i", "s", "o","R")
value = c(37, 27, 20, 20, 5, 5)
df = data.frame(name, value)

I tried every idea that I could, but I think that I am missing some basic knowledge about how to solve it. adding stats = "count"

 ggplot(df,aes(name) ) +
     geom_bar(stat = "count", show.legend = TRUE)

I am obtaing or: - A plot with all the columns - Error messages

My expected solutions is: A barplot using ggplot, with 4 columns as "h", "s", "i & s", "o & R"

And in y-axis, each of the columns with the next values: 37, 27, 20, 5

Ronak Shah · Accepted Answer · 2019-11-12 06:10:27Z

3

After summarising the data as suggested by @caldwellst, you could plot the bar plot using

library(dplyr)
library(ggplot2)

df %>%
  group_by(value) %>%
  summarize(name = toString(name)) %>%
  ggplot() + aes(name, value, label = value, fill = name) +
  geom_col() + geom_text(nudge_y = 1)

answered Nov 12, 2019 at 6:10

Ronak Shah

391k20 gold badges173 silver badges237 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

caldwellst · Accepted Answer · 2019-11-12 08:06:54Z

3

You need to adjust your dataset prior to plotting, as ggplot has no idea that you want to visualize identical values as a single bar. Using dplyr you could simply do:

library(dplyr)

df %>%
  group_by(value) %>%
  summarize(name = paste(name, collapse = " & "))

edited Nov 12, 2019 at 8:06

answered Nov 12, 2019 at 5:58

caldwellst

5,97610 silver badges25 bronze badges

Collectives™ on Stack Overflow

how to create multiple values for the name column?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related