EPIPOI: A user-friendly analytical tool for the extraction and visualization of temporal parameters from epidemiological time series
© Alonso and McCormick; licensee BioMed Central Ltd. 2012
Received: 13 March 2012
Accepted: 9 October 2012
Published: 15 November 2012
There is an increasing need for processing and understanding relevant information generated by the systematic collection of public health data over time. However, the analysis of those time series usually requires advanced modeling techniques, which are not necessarily mastered by staff, technicians and researchers working on public health and epidemiology. Here a user-friendly tool, EPIPOI, is presented that facilitates the exploration and extraction of parameters describing trends, seasonality and anomalies that characterize epidemiological processes. It also enables the inspection of those parameters across geographic regions. Although the visual exploration and extraction of relevant parameters from time series data is crucial in epidemiological research, until now it had been largely restricted to specialists.
EPIPOI is freely available software developed in Matlab (The Mathworks Inc) that runs both on PC and Mac computers. Its friendly interface guides users intuitively through useful comparative analyses including the comparison of spatial patterns in temporal parameters.
EPIPOI is able to handle complex analyses in an accessible way. A prototype has already been used to assist researchers in a variety of contexts from didactic use in public health workshops to the main analytical tool in published research.
EPIPOI can assist public health officials and students to explore time series data using a broad range of sophisticated analytical and visualization tools. It also provides an analytical environment where even advanced users can benefit by enabling a higher degree of control over model assumptions, such as those associated with detecting disease outbreaks and pandemics.
KeywordsEpidemiology Time series Trends Seasonality Anomalies Data visualization
Government, non-governmental agencies and research groups regularly monitor the health status of populations with diverse geographical and temporal resolutions in addition to varying levels of clinical detail (from mortality records to DNA sequencing of particular pathogens) . This invaluable documentation has enabled the development of elucidative studies about the causes of disease, increasing the likelihood of appropriate decision-making for public health.
Epidemiological data is frequently indexed in space (the locality where the event took place) and time and therefore, if systematically collected, many insightful and relevant patterns, outliers and parameters can be uncovered. For examples of the utility of spatio-temporal analysis one might consider the identification of the mortality attributed to epidemics [2–5] or exploring the spatial patterning of disease burden [6–9]. Much of this information, however, tends to be hidden to all but specialists with access to complex analytical tools. This complexity not only hinders a broader base of public health workers to further understand their own data (which can be critical in the preparation of responses for epidemics), but also inhibits the crosschecking of analyses and assumptions by people who understand the biology though perhaps not the computational programs used.
Here a freely available program, called "EPIPOI" (Epidemiological Parameter Investigation from Population Observations Interface), is presented which facilitates the visual exploration and description of several time series properties in a user-friendly and interactive way. Prototypes of EPIPOI have already been used in several of our studies [5, 7, 10, 11] and have benefitted from this iterative experience. The development of the software was initiated in the context of the Fogarty International Center’s project the Multinational Influenza Study of Mortality and Seasonality (MISMS, http://www.origem.info/misms), where it was used for the inspection of pneumonia and influenza datasets. Its accessibility and utility was trialed by participants of several MISMS workshops around the world. More recently, EPIPOI was extended to assist in the analysis of the other vital statistics datasets within The Etiology, Risk Factors, and Interactions of Enteric Infections and Malnutrition and the Consequences for Child Health (Mal-ED) project (http://mal-ed.fnih.org).
A number of excellent resources can be found online that do similar tasks to EPIPOI, however none combine the various specialist tasks into a single interface or present results in a manner that might offer additional insights beyond the raw analytical results – of particular interest in EPIPOI is the comparison of time series parameters in geographic space. For example, Pelat et al. provide an excellent tool for periodic regression with a particular focus on predicting and identifying epidemics and Torrence and Campo  have an online tool to perform wavelet analysis (which EPIPOI has benefited from). In both cases only a single time series can be analyzed at a time, and consequently users must know how to manipulate extracted results in such a way to allow further comparison (indeed even recognizing that further comparison across time series might be made). Perhaps surprisingly, the closest existing software– PAST  – was developed for paleontology. PAST is able to visualize, fit and extract seasonal harmonics, but falls short of attempting to visualize time series parameters in the context of other comparable time series.
What follows is a brief technical introduction and discussion of features of EPIPOI, with further practical instructions and a repository for the program available at http://www.epipoi.info.
Overview of EPIPOI
EPIPOI has been written and compiled in Matlab (The Mathworks Inc) taking advantage of many built-in and second-party (including the authors) functions that are used to identify relevant information from time series. The immediate focus of our analyses is epidemiological, but nothing prevents users from other fields (e.g. ecology, economics) from finding EPIPOI analytically convenient and useful.
Figures displayed on the graphic user interface can, in the same way as numeric results, be generated at any stage of the analyses (and can be exported in several file formats).
Preparation of data
EPIPOI accepts inputs from Microsoft Excel (because of its familiarity to most users) and then manipulates data internally to extract and export relevant parameters and processed data in formats ready to be exported back to Excel.
Time series file
Users can load the example dataset provided on the EPIPOI website or use it as a template for their own data. The spreadsheet containing the data is organized in a simple structure: after a single header row, the first column is for the year, the second for a finer resolution time unit (e.g. months, weeks or days), and thereafter each column is dedicated to a series of observations (see the example on the EPIPOI website for an illustration). These time series need to cover the whole date range of years without any data gaps, though missing observations can be filled with NaN (the Matlab shorthand for “Not a Number”). All dates and observations must be sorted in ascending chronological order (i.e. oldest in the uppermost row and most recent at the bottom). If the data has an additional categorization (for instance age or gender), different worksheets of the time series file can be used to explore this "third dimension" of the data (time and -usually- space represent the other two dimensions). We encourage the user to explore this resource whenever possible (see the website for further details on how to do it).
In case each time series (column) of the "Time series file" corresponds to a different geographic location, a second file - the "geolocation file" - containing the latitudes and longitudes of each location is needed because EPIPOI can then display the temporal parameters of those series in geographic space as well. The geolocation file does not have headers, and only needs three columns: the names of the sites (which should be identical to the ones in the time series file) and then the latitudes and the longitudes (in decimal degrees). An optional forth column can be added with names of major groupings, such as country or province names as this additional information can be color coded in the maps and scatter plots.
Overview of the analytical capabilities
Time series can be described by three components: a trend, their seasonality and the anomalies [4, 15, 16]. Each of these components can be of interest depending on the research question. Trend analyses inspect whether diseases have long term patterns, for example whether incidence is increasing or decreasing. Seasonal variation is useful for understanding how and when epidemics usually occur, and to provide insights on environmental or behavioral drivers of such patterns. Finally, anomalies can illustrate, for instance, morbidity and mortality figures in particularly severe epidemics (or pandemics) as compared to those figures expected based on the trend and regular seasonal and inter-annual variance in surrounding years [4, 5].
EPIPOI also allows all parameters describing the components of time series from different locations to be plotted and analyzed spatially. For example, it can show that the timing of the annual peak of a disease changes along a latitudinal gradient , or radially from a certain point .
The interface is a pivotal part of the program, transforming a set of exploratory and analytical tasks - which would usually involve the use of several programs or the development of specific functions by specialists – into simple steps performed in few minutes by any user. Options are presented in a way such as to walk the user through basic steps before they can perform more complex analysis, thereby ensuring that they have both an appreciation of patterns within their data and are alerted to the increasing assumptions in more sophisticated analytical stages.
As soon as users load their time series, a plot of the data is presented (including a map, when appropriate) and several relevant parameters are automatically extracted. Those parameters can be compared across time series (see "scatterplot" button, figure 1) and exported (both numerically and graphically). Although the default input values can already provide users with insightful information, it is usually the case that further tuning the program’s options will provide even more valuable information. For instance, all data is used to build the default model, but it might be the case that the time series includes atypical years that should be excluded (not only to improve the description of typical years, but also to identify key features of irregular ones).
Long-term changes in the average of a time series can be described in EPIPOI using a polynomial regression (the user can determine the polynomial order, with cubic as the default) (Figure 1). For instance, the coefficient of a linear trend term can be compared geographically to identify regions with an increase or decrease of a certain disease.
In some cases, the trend is of no analytical interest - for instance, when the research question concerns relative intra-annual seasonal dynamics so that detrending (i.e. subtracting the trend from the time series) can also be performed with a cubic spline , which does not output parameters but is a highly flexible option to describe complex long term patterns.
In the average seasonal signature of the original data year-to-year variations (trends and anomalies) are removed (or ignored, because they are negligible), but seasonal variations within the year are preserved. This seasonal signature could be obtained simply by interpolating the monthly (or weekly) averages of the time series. However, EPIPOI decomposes the time series into three sinusoids that can be related back to natural phenomena – 12-monthly, 6-monthly and 3-monthly cycles. These cycles make up a partial Fourier series (Figure 1, "harmonic parameters" box) [18, 19], an approach that is not dissimilar to a periodic regression , but provides the trigonometric parameters as amplitude and phase rather than regression coefficients of sine and cosine functions. This approach enables the use of parameters of the individual harmonics themselves to quantify epidemics [4, 21], or to identify putative, biologically relevant, descriptors of seasonality [18, 22–24].
Finally, an important aspect of the investigation of the seasonal parameters is that the main period of analysis must be reasonably ‘stationary’ (i.e. no overall trends in the mean, the variance or the timing or peaks with time). If, for instance, the timings of the peaks in a later period are progressively shifted from an earlier period, users should split the series into smaller -and stationary - units and perform the analyses separately for each one of them.
Once the trend and seasonality are described, anomalies or residuals must be considered. As mentioned, depending on the nature of the study they might be either the focus of analysis or ignored as noise. Examples of the former include determining excess mortality due to pandemic influenza compared to regular influenza seasons [5, 25], or excess deaths of a disease that occurs in specific periods every year . The latter approach has been used in influenza modeling to estimate baseline mortality using the trend and seasonal components of mortality series, but excluding those weeks or months that are known (from laboratory data) to encompass seasonal epidemics. The key assumption of this method is that variation from year to year in the disease of interest (in this case influenza) overshadows the inter-annual variation in the timing of occurrence of all remaining pathogens.
It is important to highlight that, of the analyses available in EPIPOI, the treatment of anomalies is certainly the most sensitive to choices made by the user (such as the exclusion of specific time periods), hence awareness about the assumptions made and their limitations is required. This is not something particular to EPIPOI. By definition, the identification of departures from a model will depend crucially on the model formulation itself. It is worth noting that the goodness of fit of a model is based on the magnitude of anomalies, so anomalies are minimized in the modeling process.
Alternatively, anomalies might be considered biased observations or one-off outbreaks. In such cases, data can be optionally smoothed using digital or moving average filters (from the "transformation” drop-down menu).
EPIPOI also makes wavelet analysis available (courtesy of code from Torrence and Compo ). Wavelet analysis is a sophisticated technique that describes the power of sinusoidal patterns of a time series with different frequencies (like the 1-year, 6-month and 3-month harmonics of the seasonal analysis, but including a continuum of other periodicities). In EPIPOI, its main utility is to determine how those periodicities might be changing over time. For instance, shifts from a periodicity of predominantly one year to two years, resulting perhaps from an intervention  or from changing climatic drivers  – might be detected.
If the scatterplot option is chosen in the anomalies mode, the timing and magnitude of anomalies (both above and below the optional prediction interval, and from either the excluded periods or the whole series) are available for inspection on the plot of the time series.
Results and discussion
Reproducibility of results has been advocated as a fundamental pillar of the scientific method . With EPIPOI this possibility is taken to its full meaning for epidemiologic time analyses because any user can not only reproduce (and even improve) the analyses we have previous performed, but also apply, compare and test the same methods with other datasets. In so doing, EPIPOI expands the number of users that can perform these analyses and can be instrumental in helping process epidemiological data currently available yet still unexplored in many countries.
EPIPOI packages a number of useful resources for the exploration and visualization of temporal patterns that ought to be part of a first step in any analysis , but are largely confined to those with knowledge of specialist software.
This ease of exploring parameters resulting even from complex analysis warrants, on the other hand, constant awareness of the various transformations and assumptions introduced in the analytical process (as detrending, or exclusion of periods from the model). This latter feature is a methodological advantage over approaches that rely simply on goodness of fit. In EPIPOI the user can, for instance, identify the tension or bias that data from a particular period produces in the model, leading to a refinement of the analyses (e.g. was a particular pathogen or strain circulating at that time? is this phenomena structured geographically? were all age groups affected similarly?).
EPIPOI does not, however, cover all analytical possibilities that can be of relevance in the investigation of epidemiological time series. For instance, EPIPOI does not calculate the reproductive number of a pathogen, nor does it currently allow the inclusion of additional variables (e.g., climatologic or other putative risk factors) in the model. Some of these limitations are restricted to the current version, and will be addressed in future releases. But others stem from our reluctance to interfere with the simplicity and friendliness of the user experience. Finally, there are also analytical possibilities that we did not include for epistemological reasons. Chiefly, we have been frequently asked why EPIPOI does not make predictions. Although it would be possible to include an option to extrapolate model results, we believe EPIPOI is a tool to better explore and understand relevant descriptive information in empirical data. Error rates grow very rapidly as models project into the future and new conditions can suddenly change the premise upon which they were built  such that public health decisions should be based on evidence and insight, rather than reliant solely on on models (especially when their underpinning assumptions and limitations are difficult to check and/or understand).
Overall, EPIPOI has already proved useful to public health practitioners (trialed at MISMS workshops around the globe), contributing to several research studies [5, 7, 10, 11] emphasizing a need and desire for wider access to such a tool. We believe it can be used on a larger scale and perhaps in fields not originally anticipated. Feedback from users and the constant need to stretch analytical possibilities should encourage the development of new versions.
The accessibility of free and user-friendly tools for exploratory analysis of spatio-temporal data, including data visualization, has been limited. It is hoped that EPIPOI can address this imbalance and make available hitherto specialist tools in an intuitive format, so that a wider array of public health practitioners can explore their own epidemiological time series.
Availability and requirements of the current version (1.0)
Project name: EPIPOI
Project home page: http://www.epipoi.info
Operating system: 64-bit Windows PC and Macs (10.6.4 and above)
Programming language: Matlab (The Mathworks Inc)
Other requirements: Matlab or the Matlab Compiler Runtime (MCR). The EPIPOI software, the link to the MCR and further instructions and learning material can be found at the EPIPOI website
Any restrictions to use by non-academics: None, provided that - as is the case with academics - the proper citation to the current article (and when relevant, to the website) is provided.
EPIPOI is available at http://www.epipoi.info. The authors are grateful to the Department of Vital Statistics from the Brazilian Ministry of Health for providing the mortality data used as an example dataset. We thank Cynthia Schuck-Paim, Jennifer Weisent and Camille Pelat for their valuable comments on manuscript. The development of this tool has been possible using the support of MISMS project, MAL-ED funded by the Bill and Melinda Gates Foundation, and the Premio Santander Universidades. Torrence and Compo (Torrence and Compo 1998) graciously made codes which have been integrated in EPIPOI to perform wavelet analyses freely available. This tool has certainly benefited from comments from users. We are grateful for this and hope to keep receiving such feedback in the future (for this, please go to http://www.epipoi.info).
- Lee LM, Thacker SB: Public health surveillance and knowing about health in the context of growing sources of health data. Am J Prev Med. 2011, 41: 636-640. 10.1016/j.amepre.2011.08.015.View ArticlePubMed
- Simonsen L, Clarke MJ, Williamson GD, Stroup DF, Arden NH, Schonberger LB: The impact of influenza epidemics on mortality: introducing a severity index. Am J Public Health. 1997, 87: 1944-1950. 10.2105/AJPH.87.12.1944.PubMed CentralView ArticlePubMed
- Viboud C, Boëlle P-Y, Pakdaman K, Carrat F, Valleron A-J, Flahault A: Influenza epidemics in the United States, France, and Australia, 1972–1997. Emerging Infect Dis. 2004, 10: 32-39. 10.3201/eid1001.020705.PubMed CentralView ArticlePubMed
- Serfling RE: Methods for current statistical analysis of excess pneumonia-influenza deaths. Pub Health Rep. 1963, 78: 494-506. 10.2307/4591848.View Article
- Schuck-Paim C, Viboud C, Simmonsen L, Miller MA, Moura FEA, Fernandes RM, Carvalho ML, Alonso WJ: Were equatorial regions less affected by the 2009 influenza pandemic? The Brazilian experience. PLoS ONE. 2012, 7: e41918-10.1371/journal.pone.0041918.PubMed CentralView ArticlePubMed
- Viboud C, Bjørnstad ON, Smith DL, Simonsen L, Miller MA, Grenfell BT: Synchrony, Waves, and Spatial Hierarchies in the Spread of Influenza. Science. 2006, 312: 447-451. 10.1126/science.1125237.View ArticlePubMed
- Alonso WJ, Viboud C, Simonsen L, Hirano EW, Daufenbach LZ, Miller MA: Seasonality of influenza in Brazil: a traveling wave from the Amazon to the subtropics. Am J Epidemiol. 2007, 165: 1434-1442. 10.1093/aje/kwm012.View ArticlePubMed
- Cummings DAT, Irizarry RA, Huang NE, Endy TP, Nisalak A, Ungchusak K, Burke DS: Travelling waves in the occurrence of dengue haemorrhagic fever in Thailand. Nature. 2004, 427: 344-347. 10.1038/nature02225.View ArticlePubMed
- Grenfell BT, Bjørnstad ON, Kappey J: Travelling waves and spatial hierarchies in measles epidemics. Nature. 2001, 414: 716-723. 10.1038/414716a.View ArticlePubMed
- McCormick BJJ, Alonso WJ, Miller MA: An exploration of spatial patterns of seasonal diarrhoeal morbidity in Thailand. Epidemiol Infect. 2012, 140: 1236-1243. 10.1017/S0950268811001919.View ArticlePubMed
- Alonso WJ, Acuña-Soto R, Giglio R, Nuckols J, Leyk S, Schuck-Paim C, Viboud C, Miller MA, McCormick BJJ: Spatio-temporal patterns of diarrhoeal mortality in Mexico. Epidemiol Infect. 2012, 140: 91-99. 10.1017/S0950268811000562.View ArticlePubMed
- Periodic Regression. http://marne.u707.jussieu.fr/periodic,
- A Practical Guide to Wavelet Analysis. http://paos.colorado.edu/research/wavelets,
- Hammer O: Palaeontological Statistics (PAST). 2010, Oslo
- Legendre P, Legendre L: Numerical ecology. 1998, Amsterdam, The Netherlands: Elsevier Science, 20-
- Cleveland RB, Cleveland WS, McRae JE, Terpenning I: STL: A seasonal-trend decomposition procedure based on loess. J Official Stat. 1990, 6: 3-73.
- de Boor C: A Practical Guide to Splines. 1978, New York: Springer-VerlagView Article
- Rogers DJ, Hay SI, Packer MJ: Predicting the distribution of tsetse flies in West Africa using temporal Fourier processed meteorological satellite data. Annals Trop Med Parasitol. 1996, 90: 225-242.
- Rogers DJ: Models for vectors and vector-borne diseases. Adv Parasitol. 2006, 62: 1-35.View ArticlePubMed
- Pelat C, Boelle PY, Cowling BJ, Carrat F, Flahault A, Ansart S, Valleron AJ: Online detection and quantification of epidemics. BMC Med Info Decision Making. 2007, 7: 29-10.1186/1472-6947-7-29.View Article
- Housworth J, Langmuir AD: Excess mortality from epidemic influenza, 1957–1966. Am J Epidemiol. 1974, 100: 40-48.PubMed
- Rogers DJ, Randolph SE, Snow RW, Hay SI: Satellite imagery in the study and forecast of malaria. Nature. 2002, 415: 710-715. 10.1038/415710a.PubMed CentralView ArticlePubMed
- Purse BV, McCormick BJJ, Mellor PS, Baylis M, Boorman J, Borras D, Burgu I, Capela R, Caracappa S, Collantes F: Incriminating bluetongue virus vectors with climate envelope models. J Appl Ecol. 2007, 44: 1231-1242. 10.1111/j.1365-2664.2007.01342.x.View Article
- Olsson L, Eklund L: Fourier Series for analysis of temporal sequences of satellite sensor imagery. Int J Remote Sensing. 1994, 15: 3735-3741. 10.1080/01431169408954355.View Article
- Ansart S, Pelat C, Boelle P-Y, Carrat F, Flahault A, Valleron A-J: Mortality burden of the 1918–1919 influenza pandemic in Europe. Influenza Other Respi Viruses. 2009, 3: 99-106. 10.1111/j.1750-2659.2009.00080.x.View Article
- Simonsen L, Reichert TA, Viboud C, Blackwelder WC, Taylor RJ, Miller MA: Impact of influenza vaccination on seasonal mortality in the US elderly population. Arch Intern Med. 2005, 165: 265-272.View ArticlePubMed
- Torrence C, Compo GP: A practical guide to wavelet analysis. Bull Am Met Soc. 1998, 79: 61-78. 10.1175/1520-0477(1998)079<0061:APGTWA>2.0.CO;2.View Article
- Johansson MA, Cummings DAT, Glass GE: Multiyear Climate Variability and Dengue—El Niño Southern Oscillation, Weather, and Dengue Incidence in Puerto Rico, Mexico, and Thailand: A Longitudinal Data Analysis. PLoS Med. 2009, 6: e1000168-10.1371/journal.pmed.1000168.PubMed CentralView ArticlePubMed
- Diggle PJ, Zeger SL: Editorial. Biostat. 2010, 11: 375-375. 10.1093/biostatistics/kxq029.View Article
- Erbas , Hyndman R: Data visualisation for time series in environmental epidemiology. J Epidemiol Biostat. 2001, 6: 433-443. 10.1080/135952201317225462.View ArticlePubMed
- Taleb N: The black swan : the impact of the highly improbable. 2007, New York: Random House
- The pre-publication history for this paper can be accessed here:http://www.biomedcentral.com/1471-2458/12/982/prepub
This article is published under license to BioMed Central Ltd. This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/2.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.