speedR:An R-package for interactive GUI-based data import, filtering and complex ready-to-use code generation to speed up your productivity. speedR recognizes file formats like Excel (.xls and .xlsx), open office calc, .csv and .txt files automatically.
speedR depends on Java Runtime Edition 6. To install Java, please go to java.com
Please run this code in R to install speedR:
Once speedR and its dependiecies are installed, run the following code to start the speedR's GUI:
speedR has 4 sections as marked in the following figure.
|speedR allows easy access to data in the R workspace by providing an interface to open data from R and to return modified data to R. R objects can easily be accessed via the built-in object browser where all matrices like objects can be opened by simply clicking them. The content of the object browser can be refreshed by clicking the "Refresh" button. The following figure displays the object browser window. Leaf nodes on the tree represent data in the current R workspace. Double clicking on a node makes the data available via the filtering-table.|
|speedR enables data import from a wide range of sources such as Excel (all versions), open office .calc, .csv and .txt files. Unknown data formats will be treated like text files. The importer can be opened by clicking the importer shortcut button located on the right top corner of the "Object Browser" window (see figure above).|
|Data import consists of a two step wizard "select data" and "edit table", the two figures below respectively.|
|The speedR filter engine (see figure below) accepts multiple filter levels which are hierarchically applied to the data, starting with the first filter level. A filter level is defined from all filter settings of the same line in the filter editor. Each filter level is assigned to an editable default color; data matching that filter level criteria are labeled with that filter level color. Hit counts for each filter level are displayed left to the corresponding filter level in the "Show" column (see figure below). The filtered table can be added to the R workspace or exported to the file system by clicking the export button in the upper right corner (see figure below), the user will be prompted for a variable or file name, respectively. speedR is equipped with a simple expression syntax which makes it easy to write powerful filter conditions. Depending on the data type, proper filter expressions are offered in a dropdown menu when clicking a cell in the filter editor.|
|While writing the filter expressions, speedR translates these filter expressions into an equivalent R function (see figure below). This function uses only function from base package and doesn't depend on speedR.|
speedR is equipped with a simple expression syntax which makes it easy to write powerful filter conditions. Depending on the data type, proper filter expressions are offered in a dropdown menu when clicking a cell in the filter editor.
The project summary page: you can find here:.