Singleton Remover CSV by John M. Quick
Singleton Remover CSV allows users to browse and select a single .csv file for singleton removal analysis. The analysis process assumes that the first column of the .csv file contains a set of valid IDs and that the second column contains a larger set of IDs. The IDs in the second column are iterated through and compared with the valid IDs in the first column. Matches are stored, while mismatches are ignored. Any additional columns beyond the IDs are stored along with matches, thus allowing for a variety of datasets to be analyzed so long as the first two columns contain IDs for comparison. Once all IDs have been compared, the stored matches are written to a .csv file with a user-specified name and location.
The SingletonRemoverCSV.air program may be installed using Adobe Air Application Installer. Alternatively, SingletonRemoverCSV_v0-3.fla allows the program to be modified and compiled directly from Flash CS5 or higher.
Once the program is launched, follow these steps.
- Click on the button. A file selection window will appear.
- Select a .csv file for analysis.
- The .csv file will be loaded and the analysis will begin.
- Once the file has finished processing, a save window will appear.
- Choose a filename and location, then save to output your processed .csv file.
Note: Depending on the size of the file, it may take up to a few minutes to complete the analysis.
Note: You may use the included testData.csv file to test the program and see how it works.
Singleton Remover CSV is © 2014 by John M. Quick.
Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.