1 \(\underline{Step\ 1}\)

The data used for this activity is comprised of de-identified Hepatitis C patient encounter records. Patients were screened at a local health facility within the Paso Del Norte region. The dataset is comprised of 564 entries and 17 variables. A quick look at the data shows several questionable inputs, these will require re-coding to be more useable when creating a data viz.

Adjustments were done to the race and ethnicity variables. These variables were collapsed into one, resulting in a joint variable (i.e. White_non_His). In addition to this, the gender (Male & Female) were re-coded as (0 & 1). It is also noted that several of the values entered comprise of both an alpha and numeric response (0-No / 1-Yes), these must be re-coded to numeric values only. All variable responses with similar characteristics should be addressed similarly. A final step in addressing some of the ambiguity within the dataset was conducted to collapse several of the levels, limiting the variables to a positive or negative response only.

A closer look at the full dataset also shows several missing data (NA’s). To address this issue, A count of all missing values. To accomplish this, the (R code1) provided below can be used. A Multivariate Imputation by Chained Equations “MICE” function. This allows for the replacement of missing values (imputation). MICE does this by populating the missing values (NA’s) by cross-referencing them with the adjacent values captured within the entire data set. This can be done with the (R code 1) provided below.

(R − Code 1)

2 \(\underline{Step\ 2}\)

2.1 Association Plots

As a low-level visualization, for this assignment a association plot was produced. This plot provides a visual representation of each level, allowing for the visualization of any concerns /abnormalities that may have occurred in the variable. Any noted abnormalities will be addressed at this point, and we will restart at step 1. From the heatplot below, we can see repationships between the variables.

3 \(\underline{Step\ 3}\)

This assignment evaluated five health centers (N=5) and the flow of patients that visited each site. Tufte’s Principles will be utilized to produce a well-accepted data visualization (DataViz).

The story to be told - In reference to the data set presented below, the DataViz will focus on telling the story of the number of patients counted/visited at five local health centers, over the first three years of the program’s implementation. The plot below shows an animated bar plot of HCV patients per health center.

4 \(\underline{Step\ 4}\)

4.1 First

To achieve “Graphical Integrity” (GI), all variations/manipulations to the dataset has been documented and articulated in this publication/presentation. All data formatting steps is presented along with its subsequent coding. Keeping in line with GI, all scales are clearly legible (i.e. labeled margins and scales will start from 0).

4.1.1 Second

Specific attention was paid to the layering of the variables. Precisely, several graphic devices were used to separate the categories. In addition to this, the layers were applied in a hierarchy approach to reduce confusion in the story being told. For this specific assignment, the graphs were layered to show HCV incidence per site in a hierarchy manner. Keen attention was paid to the color schemes and scale. An extra emphasis was placed on depicting small changes within the data. As we come to the end of this assignment a focus is be placed on the “Parallelism” of the datviz. A focus on isomorphism and visual juxtapositions revealing connectionshas been layered in to the animation plots below.

As in the past to avoided “Chart-junk”, a cookbook approach to datviz was first utilized to develop sound graphs. Once the graph was developed, a more inventive/liberal approach to datviz was applied. Specifically focusing on visual noise reduction, which may disrupt the story that is being told.

5 \(\underline{Step\ 5}\)

5.0.1 Story Bar Plot Improved

A grid background was added, to improve the plot. This allows for visualization of the scale of data. In addition to this, a title, X and Y labels, and a legend were added to assist the reading of the plot. The layering of a count was added to the bar representation of each site as it progresses into time.

a<-ggplot(data=dat1, aes(x=Site.Name, Client.ID..Unique..., fill=Site.Name))+ 
  geom_bar(stat="identity") +
  theme_bw()+
  geom_text(aes(label=Client.ID..Unique...), vjust=1, hjust=-0.1, color="black", size=3.5) +
  coord_flip() +
  labs(title = 'Patient Flow Per Site - Date: {frame_time}', x="Health Center(s)", y = "Patient Count By Site") +
  transition_time(Date) +
  ease_aes('sine-in-out')

animate(a, duration = 235, fps = 2, nframes = 1)

5.0.1.1 Story Plot Improved 2

An animated line plot was generated as an alternative to the bar plot. While the below graph provides a more accurate visualized change in the flow of patients per health center. The layering applied to the bar plot allows for the story of “patient flow” to be more easily visualized.

x<-ggplot(data=dat1, aes(x=Site.Name, Client.ID..Unique..., fill=Site.Name))+
    geom_line() +
    geom_point() +
    scale_color_viridis(discrete = F) +
    ggtitle('Patient Flow Per Site') +
    theme_ipsum() +
    ylab("Patient Count By Site") +
    transition_reveal(Date)

animate(x)