Search code examples
rpivot-tablebubble-chart

visualizing crosstab tables with a plot in R


I saw a plot generated in excel and I was wondering if R could also do it.this picture is essentially a visualization of a crosstab table comparing the days of the week to preferred meals on that day and counting the number of people that fall within those categories

This picture is essentially a visualization of a crosstab table comparing the days of the week to preferred meals on that day and counting the number of people that fall within those categories.

How I can make a plot like this one?


Solution

  • Using Hadley Wickham's ggplot2:

    library(ggplot2)                           
    
    # Set up the vectors                           
    days <- c("Mon","Tues","Wed","Thurs","Fri")
    slots <- c("Coffee/Breakfast","Lunch","Happy Hour","Dinner")
    
    # Create the data frame
    df <- expand.grid(days, slots)
    df$value <- c(1,1,1,1,2,1,1,NA,NA,1,4,4,7,4,1,5,6,14,5,1)    
    
    #Plot the Data
    g <- ggplot(df, aes(Var1, Var2)) + geom_point(aes(size = value), colour = "green") + theme_bw() + xlab("") + ylab("")
    g + scale_size_continuous(range=c(10,30)) + geom_text(aes(label = value))
    

    enter image description here

    Do you care that the axis lines go through the circles? Also, the greens are slightly different and the label text is black instead of white.