24 - Best practices for data analyses

A noncomprehensive set of best practices for building data analyses
module 6
week 8
best practices
Author
Affiliations

This lecture, as the rest of the course, is adapted from the version Stephanie C. Hicks designed and maintained in 2021 and 2022. Check the recent changes to this file through the GitHub history.

Pre-lecture materials

Acknowledgements

Material for this lecture was borrowed and adopted from

Learning objectives

Learning objectives

At the end of this lesson you will:

Be able to state best practices for:

  • Considerations around building ethical data analyses
  • Sharing data
  • Creating data visualizations

Best practices for data ethics

In philosophy departments, classes and modules centered around data ethics are widely discussed.

The ethical challenges around working with data are not fundamentally different from the ethical challenges philosophers have always faced.

However, putting an ethical framework around building data analyses in practice is indeed new for most data scientists, and for many of us, we are woefully under-prepared to teach so far outside our comfort zone.

That being said, we can provide some thoughts on how to approach a data science problem using a philosophical lens.

Defining ethics

We start with a grounding in the definition of Ethics:

Ethics, also called moral philosophy, has three main branches:

  1. Applied ethics “is a branch of ethics devoted to the treatment of moral problems, practices, and policies in personal life, professions, technology, and government.”
  2. Ethical theory “is concerned with the articulation and the justification of the fundamental principles that govern the issues of how we should live and what we morally ought to do. Its most general concerns are providing an account of moral evaluation and, possibly, articulating a decision procedure to guide moral action.”
  3. Metaethics “is the attempt to understand the metaphysical, epistemological, semantic, and psychological, presuppositions and commitments of moral thought, talk, and practice.”

While, unfortunately, there are myriad examples of ethical data science problems (see, for example, blog posts bookclub and data feminism), here I aim to connect some of the broader data science ethics issues with the existing philosophical literature.

Note, I am only scratching the surface and a deeper dive might involve education in related philosophical fields (epistemology, metaphysics, or philosophy of science), philosophical methodologies, and ethical schools of thought, but you can peruse all of these through, for example, a course or readings introducing the discipline of philosophy.

Below we provide some thoughts on how to approach a data science problem using a philosophical lens.

Case Study

We begin by considering a case study around ethical data analyses.

Many ethics case studies provided in a classroom setting describe algorithms built on data which are meant to predict outcomes.

Note

Large scale algorithmic decision making presents particular ethical predicaments because of both the scale of impact and the “black-box” sense of how the algorithm is generating predictions.

Consider the well-known issue of using facial recognition software in policing.

There are many questions surrounding the policing issue:

  • What are the action options with respect to the outcome of the algorithm?
  • What are the good and bad aspects of each action and how are these to be weighed against each other?

[Source: CNN]

Important questions

The two main ethical concerns surrounding facial recognition software break down into

  • How the algorithms were developed?
  • How the algorithm is used?

When thinking about the questions below, reflect on the good aspects and the bad aspects and how one might weight the good versus the bad.

Creating the algorithm

  • What data should be used to train the algorithm?
    • If the accuracy rates of the algorithm differ based on the demographics of the subgroups within the data, is more data and testing required?
  • Who and what criteria should be used to tune the algorithm?
    • Who should be involved in decisions on the tuning parameters of the algorithm?
    • Which optimization criteria should be used (e.g., accuracy? false positive rate? false negative rate?)
  • Issues of access:
    • Who should own or have control of the facial image data?
      • Do individuals have a right to keep their facial image private from being in databases?
      • Do individuals have a right to be notified that their facial image is in the data base? For example, if I ring someone’s doorbell and my face is captured in a database, do I need to be told? [While traditional human subjects and IRB requirements necessitate consent to be included in any research project, in most cases it is legal to photograph a person without their consent.]
    • Should the data be accessible to researchers working to make the field more equitable? What if allowing accessibility thereby makes the data accessible to bad actors?

Using the algorithm

  • Issues of personal impact:
    • The software might make it easier to accurately associate an individual with a crime, but it might also make it easier to mistakenly associate an individual with a crime. How should the pro vs con be weighed against each other?
    • Do individuals have a right to know, correct, or delete personal information included in a database?
  • Issues of societal impact:
    • Is it permissible to use a facial recognition software which has been trained primarily on faces of European ancestry individual, given that this results in false positive and false negative rates that are not equally dispersed across racial lines?
    • While the software might make it easier to protect against criminal activity, it also makes it easier to undermine specific communities when their members are mistakenly identified with criminal activity. How should the pro vs con of different communities be weighed against each other?
  • Issues of money:
    • Is it permissible for a software company to profit from an algorithm while having no financial responsibility for its misuse or negative impacts?
    • Who should pay the court fees and missed work hours of those who were mistakenly accused of crimes?

To settle the questions above, we need to study various ethical theories, and it turns out that the different theories may lead us to different conclusions. As non-philosophers, we recognize that the suggested readings and ideas may come across as overwhelming. If you are overwhelmed, we suggest that you choose one ethical theory, think carefully about how it informs decision making, and help your students to connect the ethical framework to a data science case study.

Final thoughts

This is a challenging topic, but as you analyze data, ask yourself the following broad questions to help you with ethical considerations around the data analysis.

Questions to ask yourself when analyzing data?
  1. Why are we producing this knowledge?
  2. For whom are we producing this knowledge?
  3. What communities do they serve?
  4. Which stakeholders need to be involved in making decisions in and around the data analysis?

Best practices for sharing data

Data sharing is an essential element of the scientific method, imperative to ensure transparency and reproducibility.

Different areas of research collect fundamentally different types of data, such as tabular data, time series data, image data, or genomic data. These types of data differ greatly in size and require different approaches for sharing.

In this section, I outline broad best practices to make your data publicly accessible and usable, generally and for several specific kinds of data.

FAIR principles

Sharing data proves more useful when others can easily find and access, interpret, and reuse the data. To maximize the benefit of sharing your data, follow the findable, accessible, interoperable, and reusable (FAIR) guiding principles of data sharing, which optimize reuse of generated data.

FAIR data sharing principles
  1. Findable. The first step in (re)using data is to find them. Metadata and data should be easy to find for both humans and computers. Machine-readable metadata are essential for automatic discovery of datasets and services, so this is an essential component of the FAIRification process.
  2. Accessible. Once the user finds the required data, she/he needs to know how can they be accessed, possibly including authentication and authorization.
  3. Interoperable. The data usually need to be integrated with other data. In addition, the data need to interoperate with applications or workflows for analysis, storage, and processing.
  4. Reusable. The ultimate goal of FAIR is to optimize the reuse of data. To achieve this, metadata and data should be well-described so that they can be replicated and/or combined in different settings.

Why share?

  1. Benefits of sharing data to science and society. Sharing data allows for transparency in scientific studies and allows one to fully understand what occurred in an analysis and reproduce the results. Without complete data, metadata, and information about resources used to generate the data, reproducing a study proves impossible.
  2. Benefits of sharing data to individual researchers. Sharing data increases the impact of a researcher’s work and reputation for sound science. Awards for those with an excellent record of data sharing or data reuse can exemplify this reputation.

Addressing common concerns about data sharing

Despite the clear benefits of sharing data, some researchers still have concerns about doing so.

  • Novelty. Some worry that sharing data may decrease the novelty of their work and their chance to publish in prominent journals. You can address this concern by sharing your data only after publication. You can also choose to preprint your manuscript when you decide to share your data. Furthermore, you only need to share the data and metadata required to reproduce your published study.
  • Time spent on sharing data. Some have concerns about the time it takes to organize and share data publicly. Many add ‘data available upon request’ to manuscripts instead of depositing the data in a public repository in hopes of getting the work out sooner. It does take time to organize data in preparation for sharing, but sharing data publicly may save you time. Sharing data in a public repository that guarantees archival persistence means that you will not have to worry about storing and backing up the data yourself.
  • Human subject data. Sharing of data on human subjects requires special ethical, legal, and privacy considerations. Existing recommendations largely aim to balance the privacy of human participants with the benefits of data sharing by de-identifying human participants and obtaining consent for sharing. Sharing human data poses a variety of challenges for analysis, transparency, reproducibility, interoperability, and access.
Human data

Sometimes you cannot publicly post all human data, even after de-identification. We suggest three strategies for making these data maximally accessible.

  1. Deposit raw data files in a controlled-access repository. Controlled-access repositories allow only qualified researchers who apply to access the data.
  2. Even if you cannot make individual-level raw data available, you can make as much processed data available as possible. This may take the form of summary statistics such as means and standard deviations, rather than individual-level data.
  3. You may want to generate simulated data distinct from the original data but statistically similar to it. Simulated data would allow others to reproduce your analysis without disclosing the original data or requiring the security controls needed for controlled access.

What data to share?

Depending on the data type, you might be able to share the data itself, or a summarized version of it. Broadly thought, you want to share the following:

  1. The data itself, or a summarized version, or a simulated data similar to the original.
  2. Any metadata to describe the primary data and the resources used to generate it. Most disciplines have specific metadata standards to follow (e.g. microarrays).
  3. Data dictionary. These have crucial role in organizing your data, especially explaining the variables and their representation. Data dictionaries should provide short names for each variable, a longer text label for the variable, a definition for each variable, data type (such as floating-point number, integer, or string), measurement units, and expected minimum and maximum values. Data dictionaries can make explicit what future users would otherwise have to guess about the representation of data.
  4. Source code. Ideally, readers should have all materials needed to completely reproduce the study described in a publication, not just data. These materials include source code, preprocessing, and analysis scripts. Guidelines for organization of computational project can help you arrange your data and scripts in a way that will make it easier for you and other to access and reuse them.
  5. Licensing. Clear licensing information attached to your data avoids any questions of whether others may reuse it. Many data resources turn out not to be as reusable as the providers intended, due to lack of clarity in licensing or restrictive licensing choices.
How should you document your data?

Document your data in three ways:

  1. With your manuscript.
  2. With description fields in the metadata collected by repositories
  3. With README files. README files provide abbreviated information about a collection of files (e.g. explain organization, file locations, observations and variables present in each file, details on the experimental design, etc).

Best git/GitHub practices when adapting code

The following material is from a LIBD rstats club presentation I gave in 2023-09-15.

I’ve adapted some of the content from the public notes.

Adapted from (file path) strategy

Pros:

  • Simple, you likely know the file path to which script you are adapting.

Cons:

  • File paths change over time
  • Not everyone will have access to older files

Adapted from (GitHub URL) strategy

Pros:

  • You likely know the URL to the script you are adapting

Cons:

  • URLs change over time: files get renamed, code gets moved around
    • It’s best to use GitHub permalinks documented here
  • Not everyone will have access to private GitHub repos

Best practices for data visualizations

Motivation

Quote from one of Roger Peng’s heroes

“The greatest value of a picture is when it forces us to notice what we never expected to see.” -John W. Tukey

Mistakes, biases, systematic errors and unexpected variability are commonly found in data regardless of applications. Failure to discover these problems often leads to flawed analyses and false discoveries.

As an example, consider that measurement devices sometimes fail and not all summarization procedures, such as the mean() function in R, are designed to detect these. Yet, these functions will still give you an answer.

Furthermore, it may be hard or impossible to notice an error was made just from the reported summaries.

Data visualization is a powerful approach to detecting these problems. We refer to this particular task as exploratory data analysis (EDA), coined by John Tukey.

On a more positive note, data visualization can also lead to discoveries which would otherwise be missed if we simply subject the data to a battery of statistical summaries or procedures.

When analyzing data, we often make use of exploratory plots to motivate the analyses we choose.

In this section, we will discuss some types of plots to avoid, better ways to visualize data, some principles to create good plots, and ways to use ggplot2 to create expository (intended to explain or describe something) graphs.

Example

The following figure is from Lippmann et al. 2006:

Nickel concentration and PM10 health effects (Blue points represent average county-level concentrations from 2000–2005 for 72 U.S. counties representing 69 communities).

The following figure is from Dominici et al. 2007, in response to the work by Lippmann et al. above.

Nickel concentration and PM10 health effects (with and without New York).

Elevated levels of Ni and V PM2.5 chemical components in New York are likely attributed to oil-fired power plants and emissions from ships burning oil, as noted by Lippmann et al. (2006).

Generating data visualizations

In order to determine the effectiveness or quality of a visualization, we need to first understand three things:

Questions to ask yourself when building data visualizations
  1. What is the question we are trying to answer?
  2. Why are we building this visualization?
  3. For whom are we producing this data visualization for? Who is the intended audience to consume this visualization?

No plot (or any statistical tool, really) can be judged without knowing the answers to those questions. No plot or graphic exists in a vacuum. There is always context and other surrounding factors that play a role in determining a plot’s effectiveness.

Conversely, high-quality, well-made visualizations usually allow one to properly deduce what question is being asked and who the audience is meant to be. A good visualization tells a complete story in a single frame.

Broad steps for creating data visualizations

The act of visualizing data typically proceeds in two broad steps:

  1. Given the question and the audience, what type of plot should I make?
  2. Given the plot I intend to make, how can I optimize it for clarity and effectiveness?

Again I highly recommend checking the content made by Christine Zhang!

Data viz principles

Developing plots

Initially, one must decide what information should be presented. The following principles for developing analytic graphics come from Edward Tufte’s book Beautiful Evidence.

  1. Show comparisons
  2. Show causality, mechanism, explanation
  3. Show multivariate data
  4. Integrate multiple modes of evidence
  5. Describe and document the evidence
  6. Content is king - good plots start with good questions

Optimizing plots

  1. Maximize the data/ink ratio – if “ink” can be removed without reducing the information being communicated, then it should be removed.
  2. Maximize the range of perceptual conditions – your audience’s perceptual abilities may not be fully known, so it’s best to allow for a wide range, to the extent possible (or knowable).
  3. Show variation in the data, not variation in the design.

What’s sub-optimal about this plot?

d <- airquality %>%
    mutate(Summer = ifelse(Month %in% c(7, 8, 9), 2, 3))
with(d, {
    plot(Temp, Ozone, col = unclass(Summer), pch = 19, frame.plot = FALSE)
    legend("topleft",
        col = 2:3, pch = 19, bty = "n",
        legend = c("Summer", "Non-Summer")
    )
})

What’s sub-optimal about this plot?

airquality %>%
    mutate(Summer = ifelse(Month %in% c(7, 8, 9),
        "Summer", "Non-Summer"
    )) %>%
    ggplot(aes(Temp, Ozone)) +
    geom_point(aes(color = Summer), size = 2) +
    theme_minimal()

Some of these principles are taken from Edward Tufte’s Visual Display of Quantitative Information:

Plots to Avoid

This section is based on a talk by Karl W. Broman titled “How to Display Data Badly”, in which he described how the default plots offered by Microsoft Excel “obscure your data and annoy your readers” (here is a link to a collection of Karl Broman’s talks).

FYI

Karl’s lecture was inspired by the 1984 paper by H. Wainer: How to display data badly. American Statistician 38(2): 137–147.

Dr. Wainer was the first to elucidate the principles of the bad display of data.

However, according to Karl Broman, “The now widespread use of Microsoft Excel has resulted in remarkable advances in the field.”

Here we show examples of “bad plots” and how to improve them in R.

Some general principles of bad plots
  • Display as little information as possible.
  • Obscure what you do show (with chart junk).
  • Use pseudo-3D and color gratuitously.
  • Make a pie chart (preferably in color and 3D).
  • Use a poorly chosen scale.
  • Ignore significant figures.

Examples

Here are some examples of bad plots and suggestions on how to improve

Pie charts

Let’s say we are interested in the most commonly used browsers. Wikipedia has a table with the “usage share of web browsers” or the proportion of visitors to a group of web sites that use a particular web browser from July 2017.

browsers <- c(
    Chrome = 60, Safari = 14, UCBrowser = 7,
    Firefox = 5, Opera = 3, IE = 3, Noinfo = 8
)
browsers.df <- gather(
    data.frame(t(browsers)),
    "browser", "proportion"
)

Let’s say we want to report the results of the usage. The standard way of displaying these is with a pie chart:

pie(browsers, main = "Browser Usage (July 2022)")

If we look at the help file for pie():

?pie

It states:

“Pie charts are a very bad way of displaying information. The eye is good at judging linear measures and bad at judging relative areas. A bar chart or dot chart is a preferable way of displaying this type of data.”

To see this, look at the figure above and try to determine the percentages just from looking at the plot. Unless the percentages are close to 25%, 50% or 75%, this is not so easy. Simply showing the numbers is not only clear, but also saves on printing costs.

Having said that, see how we used a pie chart in a 2023 pre-print https://www.biorxiv.org/content/biorxiv/early/2023/02/15/2023.02.15.528722/F5.large.jpg. The published version is accessible from doi 10.1126/science.adh1938.

Instead of pie charts, try bar plots

If you do want to plot them, then a barplot is appropriate. Here we use the geom_bar() function in ggplot2. Note, there are also horizontal lines at every multiple of 10, which helps the eye quickly make comparisons across:

p <- browsers.df %>%
    ggplot(aes(
        x = reorder(browser, -proportion),
        y = proportion
    )) +
    geom_bar(stat = "identity")
p

Notice that we can now pretty easily determine the percentages by following a horizontal line to the x-axis.

Polish your plots

While this figure is already a big improvement over a pie chart, we can do even better. When you create figures, you want your figures to be self-sufficient, meaning someone looking at the plot can understand everything about it.

Some possible critiques are:

  1. make the axes bigger
  2. make the labels bigger
  3. make the labels be full names (e.g. “Browser” and “Proportion of users”, ideally with units when appropriate)
  4. add a title

Let’s explore how to do these things to make an even better figure.

To start, go to the help file for theme()

?ggplot2::theme

We see there are arguments with text that control all the text sizes in the plot. If you scroll down, you see the text argument in the theme command requires class element_text. Let’s try it out.

To change the x-axis and y-axis labels to be full names, use xlab() and ylab()

p <- p + xlab("Browser") +
    ylab("Proportion of Users")
p

Maybe a title

p + ggtitle("Browser Usage (July 2022)")

Next, we can also use the theme() function in ggplot2 to control the justifications and sizes of the axes, labels and titles.

To center the title

p + ggtitle("Browser Usage (July 2022)") +
    theme(plot.title = element_text(hjust = 0.5))

To create bigger text/labels/titles:

p <- p + ggtitle("Browser Usage (July 2022)") +
    theme(
        plot.title = element_text(hjust = 0.5),
        text = element_text(size = 15)
    )
p

“I don’t like that theme”

p + theme_bw()

p + theme_dark()

p + theme_classic() # axis lines!

p + ggthemes::theme_base()

3D barplots

Please, avoid a 3D version because it obfuscates the plot, making it more difficult to find the percentages by eye.

Donut plots

Even worse than pie charts are donut plots.

The reason is that by removing the center, we remove one of the visual cues for determining the different areas: the angles. There is no reason to ever use a donut plot to display data.

Barplots as data summaries

While barplots are useful for showing percentages, they are incorrectly used to display data from two groups being compared. Specifically, barplots are created with height equal to the group means; an antenna is added at the top to represent standard errors. This plot is simply showing two numbers per group and the plot adds nothing:

Instead of bar plots for summaries, try box plots

If the number of points is small enough, we might as well add them to the plot. When the number of points is too large for us to see them, just showing a boxplot is preferable.

Let’s recreate these barplots as boxplots and overlay the points. We will simulate similar data to demonstrate one way to improve the graphic above.

set.seed(1000)
dat <- data.frame(
    "Treatment" = rnorm(10, 30, sd = 4),
    "Control" = rnorm(10, 36, sd = 4)
)
gather(dat, "type", "response") %>%
    ggplot(aes(type, response)) +
    geom_boxplot() +
    geom_point(position = "jitter") +
    ggtitle("Response to drug treatment")

Notice how much more we see here: the center, spread, range, and the points themselves. In the barplot, we only see the mean and the standard error (SE), and the SE has more to do with sample size than with the spread of the data.

This problem is magnified when our data has outliers or very large tails. For example, in the plot below, there appears to be very large and consistent differences between the two groups:

However, a quick look at the data demonstrates that this difference is mostly driven by just two points.

set.seed(1000)
dat <- data.frame(
    "Treatment" = rgamma(10, 10, 1),
    "Control" = rgamma(10, 1, .01)
)
gather(dat, "type", "response") %>%
    ggplot(aes(type, response)) +
    geom_boxplot() +
    geom_point(position = "jitter")

Use log scale if data includes outliers

A version showing the data in the log-scale is much more informative.

gather(dat, "type", "response") %>%
    ggplot(aes(type, response)) +
    geom_boxplot() +
    geom_point(position = "jitter") +
    scale_y_log10()

Barplots for paired data

A common task in data analysis is the comparison of two groups. When the dataset is small and data are paired, such as the outcomes before and after a treatment, two-color barplots are unfortunately often used to display the results.

Instead of paired bar plots, try scatter plots

There are better ways of showing these data to illustrate that there is an increase after treatment. One is to simply make a scatter plot, which shows that most points are above the identity line. Another alternative is to plot the differences against the before values.

set.seed(1000)
before <- runif(6, 5, 8)
after <- rnorm(6, before * 1.15, 2)
li <- range(c(before, after))
ymx <- max(abs(after - before))

par(mfrow = c(1, 2))
plot(before, after,
    xlab = "Before", ylab = "After",
    ylim = li, xlim = li
)
abline(0, 1, lty = 2, col = 1)

plot(before, after - before,
    xlab = "Before", ylim = c(-ymx, ymx),
    ylab = "Change (After - Before)", lwd = 2
)
abline(h = 0, lty = 2, col = 1)

or line plots

Line plots are not a bad choice, although they can be harder to follow than the previous two. Boxplots show you the increase, but lose the paired information.

z <- rep(c(0, 1), rep(6, 2))
par(mfrow = c(1, 2))
plot(z, c(before, after),
    xaxt = "n", ylab = "Response",
    xlab = "", xlim = c(-0.5, 1.5)
)
axis(side = 1, at = c(0, 1), c("Before", "After"))
segments(rep(0, 6), before, rep(1, 6), after, col = 1)

boxplot(before, after,
    names = c("Before", "After"),
    ylab = "Response"
)

The above plot was made using ggpubr::ggpaired(). Note that the title of the package is:

ggpubr: ‘ggplot2’ Based Publication Ready Plots

Gratuitous 3D

The figure below shows three curves. Pseudo 3D is used, but it is not clear why. Maybe to separate the three curves? Notice how difficult it is to determine the values of the curves at any given point:

This plot can be made better by simply using color to distinguish the three lines:

x <- read_csv("https://github.com/kbroman/Talk_Graphs/raw/master/R/fig8dat.csv") %>%
    as_tibble(.name_repair = make.names)

p <- x %>%
    gather("drug", "proportion", -log.dose) %>%
    ggplot(aes(
        x = log.dose, y = proportion,
        color = drug
    )) +
    geom_line()
p

This plot demonstrates that using color is more than enough to distinguish the three lines.

We can make this plot better using the functions we learned above

p + ggtitle("Survival proportion") +
    theme(
        plot.title = element_text(hjust = 0.5),
        text = element_text(size = 15)
    )

Legends

We can also move the legend inside the plot

p + ggtitle("Survival proportion") +
    theme(
        plot.title = element_text(hjust = 0.5),
        text = element_text(size = 15),
        legend.position = c(0.2, 0.3)
    )
Warning: A numeric `legend.position` argument in `theme()` was deprecated in ggplot2
3.5.0.
ℹ Please use the `legend.position.inside` argument of `theme()` instead.

We can also make the legend transparent

transparent_legend <- theme(
    legend.background = element_rect(fill = "transparent"),
    legend.key = element_rect(
        fill = "transparent",
        color = "transparent"
    )
)

p + ggtitle("Survival proportion") +
    theme(
        plot.title = element_text(hjust = 0.5),
        text = element_text(size = 15),
        legend.position = c(0.2, 0.3)
    ) +
    transparent_legend

Too many significant digits

By default, statistical software like R returns many significant digits. This does not mean we should report them. Cutting and pasting directly from R is a bad idea since you might end up showing a table, such as the one below, comparing the heights of basketball players:

heights <- cbind(
    rnorm(8, 73, 3), rnorm(8, 73, 3), rnorm(8, 80, 3),
    rnorm(8, 78, 3), rnorm(8, 78, 3)
)
colnames(heights) <- c("SG", "PG", "C", "PF", "SF")
rownames(heights) <- paste("team", 1:8)
heights
             SG       PG        C       PF       SF
team 1 68.88065 73.07480 81.80948 76.60455 82.23521
team 2 70.05272 66.86024 74.64847 72.70140 78.55640
team 3 71.33653 73.63946 81.00483 78.56787 77.86893
team 4 73.36414 81.01021 81.68293 76.90146 77.35226
team 5 72.63738 69.31895 83.66281 81.17280 82.39133
team 6 68.99188 75.50274 79.36564 75.77514 78.68900
team 7 73.51017 74.59772 82.09829 73.95492 78.32287
team 8 73.46524 71.05953 77.88069 76.44808 73.86569

We are reporting precision up to 0.00001 inches. Do you know of a tape measure with that much precision? This can be easily remedied:

round(heights, 1)
         SG   PG    C   PF   SF
team 1 68.9 73.1 81.8 76.6 82.2
team 2 70.1 66.9 74.6 72.7 78.6
team 3 71.3 73.6 81.0 78.6 77.9
team 4 73.4 81.0 81.7 76.9 77.4
team 5 72.6 69.3 83.7 81.2 82.4
team 6 69.0 75.5 79.4 75.8 78.7
team 7 73.5 74.6 82.1 74.0 78.3
team 8 73.5 71.1 77.9 76.4 73.9

Minimal figure captions

Recall the plot we had before:

transparent_legend <- theme(
    legend.background = element_rect(fill = "transparent"),
    legend.key = element_rect(
        fill = "transparent",
        color = "transparent"
    )
)

p + ggtitle("Survival proportion") +
    theme(
        plot.title = element_text(hjust = 0.5),
        text = element_text(size = 15),
        legend.position = c(0.2, 0.3)
    ) +
    xlab("dose (mg)") +
    transparent_legend

What type of caption would be good here?

When creating figure captions, think about the following:

  1. Be specific

A plot of the proportion of patients who survived after three drug treatments.

  1. Label the caption

Figure 1. A plot of the proportion of patients who survived after three drug treatments.

  1. Tell a story

Figure 1. Drug treatment survival. A plot of the proportion of patients who survived after three drug treatments.

  1. Include units

Figure 1. Drug treatment survival. A plot of the proportion of patients who survived after three drug treatments (milligram).

  1. Explain aesthetics

Figure 1. Drug treatment survival. A plot of the proportion of patients who survived after three drug treatments (milligram). Three colors represent three drug treatments. Drug A results in largest survival proportion for the larger drug doses.

Final thoughts data viz

In general, you should follow these principles:

  • Create expository graphs to tell a story (figure and caption should be self-sufficient; it’s the first thing people look at)

    • Be accurate and clear
    • Let the data speak
    • Make axes, labels and titles big
    • Make labels full names (ideally with units when appropriate)
    • Add informative legends; use space effectively
  • Show as much information as possible, taking care not to obscure the message

  • Science not sales: avoid unnecessary frills (especially gratuitous 3D)

  • In tables, every digit should be meaningful

Some further reading

  • N Cross (2011). Design Thinking: Understanding How Designers Think and Work. Bloomsbury Publishing.
  • J Tukey (1977). Exploratory Data Analysis.
  • ER Tufte (1983) The visual display of quantitative information. Graphics Press.
  • ER Tufte (1990) Envisioning information. Graphics Press.
  • ER Tufte (1997) Visual explanations. Graphics Press.
  • ER Tufte (2006) Beautiful Evidence. Graphics Press.
  • WS Cleveland (1993) Visualizing data. Hobart Press.
  • WS Cleveland (1994) The elements of graphing data. CRC Press.
  • A Gelman, C Pasarica, R Dodhia (2002) Let’s practice what we preach: Turning tables into graphs. The American Statistician 56:121-130.
  • NB Robbins (2004) Creating more effective graphs. Wiley.
  • Nature Methods columns

R session information

options(width = 120)
sessioninfo::session_info()
─ Session info ───────────────────────────────────────────────────────────────────────────────────────────────────────
 setting  value
 version  R version 4.4.1 (2024-06-14)
 os       macOS Sonoma 14.5
 system   aarch64, darwin20
 ui       X11
 language (EN)
 collate  en_US.UTF-8
 ctype    en_US.UTF-8
 tz       America/New_York
 date     2024-10-14
 pandoc   3.2 @ /Applications/RStudio.app/Contents/Resources/app/quarto/bin/tools/aarch64/ (via rmarkdown)

─ Packages ───────────────────────────────────────────────────────────────────────────────────────────────────────────
 package     * version date (UTC) lib source
 bit           4.5.0   2024-09-20 [1] CRAN (R 4.4.1)
 bit64         4.5.2   2024-09-22 [1] CRAN (R 4.4.1)
 cli           3.6.3   2024-06-21 [1] CRAN (R 4.4.0)
 colorout    * 1.3-0.2 2024-05-03 [1] Github (jalvesaq/colorout@c6113a2)
 colorspace    2.1-1   2024-07-26 [1] CRAN (R 4.4.0)
 crayon        1.5.3   2024-06-20 [1] CRAN (R 4.4.0)
 curl          5.2.3   2024-09-20 [1] CRAN (R 4.4.1)
 digest        0.6.37  2024-08-19 [1] CRAN (R 4.4.1)
 dplyr       * 1.1.4   2023-11-17 [1] CRAN (R 4.4.0)
 evaluate      1.0.1   2024-10-10 [1] CRAN (R 4.4.1)
 fansi         1.0.6   2023-12-08 [1] CRAN (R 4.4.0)
 farver        2.1.2   2024-05-13 [1] CRAN (R 4.4.0)
 fastmap       1.2.0   2024-05-15 [1] CRAN (R 4.4.0)
 forcats     * 1.0.0   2023-01-29 [1] CRAN (R 4.4.0)
 generics      0.1.3   2022-07-05 [1] CRAN (R 4.4.0)
 ggplot2     * 3.5.1   2024-04-23 [1] CRAN (R 4.4.0)
 ggthemes      5.1.0   2024-02-10 [1] CRAN (R 4.4.0)
 glue          1.8.0   2024-09-30 [1] CRAN (R 4.4.1)
 gtable        0.3.5   2024-04-22 [1] CRAN (R 4.4.0)
 hms           1.1.3   2023-03-21 [1] CRAN (R 4.4.0)
 htmltools     0.5.8.1 2024-04-04 [1] CRAN (R 4.4.0)
 htmlwidgets   1.6.4   2023-12-06 [1] CRAN (R 4.4.0)
 jsonlite      1.8.9   2024-09-20 [1] CRAN (R 4.4.1)
 knitr         1.48    2024-07-07 [1] CRAN (R 4.4.0)
 labeling      0.4.3   2023-08-29 [1] CRAN (R 4.4.0)
 lifecycle     1.0.4   2023-11-07 [1] CRAN (R 4.4.0)
 lubridate   * 1.9.3   2023-09-27 [1] CRAN (R 4.4.0)
 magrittr      2.0.3   2022-03-30 [1] CRAN (R 4.4.0)
 munsell       0.5.1   2024-04-01 [1] CRAN (R 4.4.0)
 pillar        1.9.0   2023-03-22 [1] CRAN (R 4.4.0)
 pkgconfig     2.0.3   2019-09-22 [1] CRAN (R 4.4.0)
 purrr       * 1.0.2   2023-08-10 [1] CRAN (R 4.4.0)
 R6            2.5.1   2021-08-19 [1] CRAN (R 4.4.0)
 readr       * 2.1.5   2024-01-10 [1] CRAN (R 4.4.0)
 rlang         1.1.4   2024-06-04 [1] CRAN (R 4.4.0)
 rmarkdown     2.28    2024-08-17 [1] CRAN (R 4.4.0)
 rstudioapi    0.16.0  2024-03-24 [1] CRAN (R 4.4.0)
 scales        1.3.0   2023-11-28 [1] CRAN (R 4.4.0)
 sessioninfo   1.2.2   2021-12-06 [1] CRAN (R 4.4.0)
 stringi       1.8.4   2024-05-06 [1] CRAN (R 4.4.0)
 stringr     * 1.5.1   2023-11-14 [1] CRAN (R 4.4.0)
 tibble      * 3.2.1   2023-03-20 [1] CRAN (R 4.4.0)
 tidyr       * 1.3.1   2024-01-24 [1] CRAN (R 4.4.0)
 tidyselect    1.2.1   2024-03-11 [1] CRAN (R 4.4.0)
 tidyverse   * 2.0.0   2023-02-22 [1] CRAN (R 4.4.0)
 timechange    0.3.0   2024-01-18 [1] CRAN (R 4.4.0)
 tzdb          0.4.0   2023-05-12 [1] CRAN (R 4.4.0)
 utf8          1.2.4   2023-10-22 [1] CRAN (R 4.4.0)
 vctrs         0.6.5   2023-12-01 [1] CRAN (R 4.4.0)
 vroom         1.6.5   2023-12-05 [1] CRAN (R 4.4.0)
 withr         3.0.1   2024-07-31 [1] CRAN (R 4.4.0)
 xfun          0.48    2024-10-03 [1] CRAN (R 4.4.1)
 yaml          2.3.10  2024-07-26 [1] CRAN (R 4.4.0)

 [1] /Library/Frameworks/R.framework/Versions/4.4-arm64/Resources/library

──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────