Title

Reading in Binary Data and Creating an R User Interface

Author Info

Malika J. OnstadFollow
Brett Amidan, Pacific Northwest National Laboratory
Kimberly Freeman

Recommended Citation

January 1, 2014.

Abstract

The Bonneville Power Administration (BPA) employs Phasor Measurement Units (PMUs) to measure variables such as Voltage, Frequency, and Phasor Angles every sixtieth of a second. These measurements result in terabytes of data which are analyzed to detect abnormalities in the power grid. Recently BPA has switched the data file format from DST to PDAT. A function does not currently exist to read in PDAT files in order to prepare the data for analysis. In order to do this the raw PMU data must be sorted and extracted to ensure its accuracy prior to analysis. This research worked to produce a method of reading in a PDAT file and converting it to an Rdata file that is used for analysis of the PMU data. Although the function is not working yet, when it is it will allow for BPA to have real time analysis of PMU data.

The historical prices of Mutual Funds and Exchange-Traded Funds (ETF) over their years of existence also create a large amount of data to analyze historical trends and predict future performance. The advancements in the R programming language allow for a more interactive User Interface (UI). This project worked on creating an interactive UI to be used in comparing Mutual Funds and ETFs using the R package “Shiny”. This allowed for interactive plots that provide additional information related to the desired fund. This investigation furthers the use of statistical anomaly detection analysis and plotting, such as that which is used in the BPA PMU analysis.

Disciplines

Numerical Analysis and Scientific Computing

Mentor

Brett Amidan

Lab site

Pacific Northwest National Laboratory (PNNL)

Funding Acknowledgement

This material is based upon work supported by the S.D. Bechtel, Jr. Foundation and by the National Science Foundation under Grant No. 0952013 and Grant No. 0833353. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the authors and do not necessarily reflect the views of the S.D. Bechtel, Jr. Foundation or the National Science Foundation. This project has also been made possible with support of the National Marine Sanctuary Foundation. The STAR program is administered by the Cal Poly Center for Excellence in Science and Mathematics Education (CESaME) on behalf of the California State University (CSU).