Plot variable with column chart with ggplot with data from read.csv2

Question

I have the height of male and females in my data grouped by cm of 10. I want to plot them togheter side by side.

My graph looks somewhat what I want it to be, but the x-axis says factor(male). It should be height in cm.

Also I got three bars, but there should be two, one for male and one for female.


# Library
library(ggplot2)
library(tidyverse) # function "%>%"


# 1. Define data
data = read.csv2(text = "Height;Male;Female
160-170;5;2
170-180;5;5
180-190;6;5
190-200;2;2")

# 2. Print table
df <- as.data.frame(data)
df


# 3. Plot Variable with column chart 
ggplot(df, aes(factor(Male), 
                   fill = factor(Male))) + 
  geom_bar(position = position_dodge(preserve = "single")) + 
  theme_classic()

TarJae · Accepted Answer · 2021-05-16 16:51:44Z

1

pivot_longer to longformat
Then use geom_bar with fill

library(tidyverse)
df1 <- df %>% pivot_longer(
  cols = c(Male, Female),
  names_to = "Gender", 
  values_to = "N"
)


# 3. Plot Variable with column chart 
ggplot(df1, aes(x=Height, y=N)) + 
  geom_bar(aes(fill = Gender), position = "dodge", stat="identity") +
  theme_classic()

edited May 16, 2021 at 16:51

answered May 16, 2021 at 16:38

TarJae

80.2k6 gold badges30 silver badges94 bronze badges

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

Comments

bird · Accepted Answer · 2021-05-16 16:52:51Z

0

One solution would be:

df %>%
        pivot_longer(cols = 2:3, names_to = "gender", values_to = "count") %>%
        ggplot(aes(x = Height, y = count, fill = gender)) +
        geom_bar(stat = "identity", position = "dodge") +
        theme_classic()

edited May 16, 2021 at 16:52

answered May 16, 2021 at 16:38

bird

3,3741 gold badge12 silver badges49 bronze badges

Collectives™ on Stack Overflow

Plot variable with column chart with ggplot with data from read.csv2

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