Ugly bar plot Graphic – and a simple alternative #rstats

At the Crooked Timber, there is an ugly graphic. A bar plot to represent a time series of grouped data. I was so annoyed by the graphic that I decided to make a version of my own. The data I got from here. The R code to reproduce the graphic is below.

The original one:


And my version (it would be possible to polish it a bit more, but I’m satisfied for now.


### My code

## I downloaded an excel file, copied into Google Docs, make some cleaning there, than exported
## as a tsv file to my local computer.

## Some data cleaning and prep
df <- read.table("crisisHumanities.tsv", header=T, sep="\t")
colnames(df)[1] <- "ano"
df[,1] <- as.numeric(substr(df[,1], 1,4))
df <- na.omit(df)
df <- df[,-2]
names(df) <- gsub("\\.", "", names(df) )
names(df) <- gsub("2*3*", "", names(df) )

mydf <- melt(df, id="ano")

mydf <- droplevels(mydf)

## relabeling
mydf$variable <- factor(mydf$variable, levels=levels(mydf$variable), 
                        labels=c("Humanites", "Scial Sciences", "Natural Sciences", 
                                "Computer science and engineering", "education", "business",
                                "Other fields"))
names(mydf)[2] <- "field"

## fixing issue with comma (Brazilian and US number formats are different regarding decimals) 
mydf$value <- as.numeric(gsub(",", "", mydf$value))

## plotting
p <- ggplot(mydf, aes(y=value, x=ano, group=field)) + geom_line(aes(colour=field)) + 
  ylab("Number of B.A. degrees awarded") + xlab("year") + theme_bw() + 
  theme(legend.key = element_rect(colour = "white")) + scale_y_continuous(labels=comma)

## putting labels. Not very satisfied, but it`s ok
p <- direct.label(p, 
             list("top.points", rot=10, cex=1, 
                  fontface="plain", fontfamily="serif", alpha=0.9))
# saving
ggsave(plot = p, "crisis_humanites.png", h = 9, w = 16, type = "cairo-png")

I’d be very glad if the original poster considered to change his graphic by mine.


Sobre Manoel Galdino

Corinthiano, Bayesiano e Doutor em ciência Política pela USP.
Esse post foi publicado em estatística, Manoel Galdino, orquídeas selvagens e marcado , , , , , . Guardar link permanente.

Uma resposta para Ugly bar plot Graphic – and a simple alternative #rstats

  1. I feel more enlightened on this topic after reading your article. Your content is fascinating, persuasive and thought-provoking. I just wish I were good with words like you so I could express my appreciation better.

Deixe um comentário

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do

Você está comentando utilizando sua conta Sair /  Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair /  Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair /  Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair /  Alterar )


Conectando a %s