adaps, adaps2, and adapsBATCH process raw Automated Data Processing System (ADAPS) .rdb files from the U.S. Geological Survey (USGS) National Water Information System (NWIS). For these functions, it is only for continuous ADAPS data of the following parameters: discharge (00060), FNU turbidity (63680), and NTRU turbidity (63676 from 63680).
1 2 3 4 5 6 7 8 9
adaps(file = tk_choose.files(default = "", caption = "Select file(s) to open & hold down Ctrl to choose more than 1 file", multi = TRUE, filters = matrix(c("ADAPS file", ".rdb", "ADAPS file", ".RDB"), 4, 2, byrow = TRUE)), interactive = TRUE, overwrite = TRUE) adapsBATCH(path = tk_choose.dir(caption = "Select directory with the ADAPS .rdb files"), overwrite = TRUE) adaps2(file, overwrite = TRUE)
Input ADAPS .rdb file(s) to be selected through a file dialog.
If interactive is
Directory path of ADAPS .rdb files to be selected through a directory dialog. The user will be asked where to find the ADAPS .rdb files & then the user will be asked where to save the ADAPS .xlsx files.
adaps function opens single or multiple raw ADAPS .rdb file(s) to modify the format and then exports the file(s) in .xlsx format. This is done for a single file or multiple files that the user selects with a file dialog.
adaps2 function opens a single raw ADAPS .rdb file to modify the format and then exports the file in .xlsx format. This is done for a single file that the user selects without a file dialog.
adapsBATCH function opens raw ADAPS .rdb files, from a directory, to modify the format and then exports the files in .xlsx format. This is done in a BATCH mode (whole directory of ADAPS .rdb files) using a directory dialog.
adaps, adaps2, and adapsBATCH functions perform the same processes on the raw ADAPS .rdb files: 1) Read in the file and remove the 1st 4 or 5 lines depending on whether NTRU data are present or not, 2) create 4 or 5 columns (depending on whether NTRU data are present or not) based on the 1st 4 or 5 lines, and 3) export the modified file in .xlsx format.
The following lines are representative of the .rdb format used in the files that these functions can operate on. Note: ntru may not be present. If so, then there will only be 3 cases of 16N in the last row. The last row will be removed in the final spreadsheet.
ADAPS .xlsx file(s)
r - How can I check if a file is empty? - Stack Overflow answered by Konrad Rudolph and edited by Geekuna Matata on Apr 23 2014. See http://stackoverflow.com/questions/23254002/how-can-i-check-if-a-file-is-empty.
r - Better error message for stopifnot? - Stack Overflow answered by Andrie on Dec 1 2011. See http://stackoverflow.com/questions/8343509/better-error-message-for-stopifnot.
RDocumentation: TclInterface tcltk. See http://www.rdocumentation.org/packages/tcltk/versions/3.3.1/topics/TclInterface.
James Wettenhall & Philippe Grosjean, File Open/Save dialogs in R tcltk, December 01, 2015. See http://www.sciviews.org/recipes/tcltk/TclTk-file-open-save-dialogs/.
r - read csv files and perform function, then bind together - Stack Overflow answered by bjoseph on Jan 8 2015. See http://stackoverflow.com/questions/27846715/read-csv-files-and-perform-function-then-bind-together.
multiple output filenames in R - Stack Overflow asked and edited by Gabelins on Feb 1 2013. See http://stackoverflow.com/questions/14651594/multiple-output-filenames-in-r.
r - Regex return file name, remove path and file extension - Stack Overflow answered and edited by Ananda Mahto on Feb 25 2013. See http://stackoverflow.com/questions/15073753/regex-return-file-name-remove-path-and-file-extension/15073919.
R help - How to change the default Date format for write.csv function? answered by William Dunlap on Dec 28, 2009. See http://r.789695.n4.nabble.com/How-to-change-the-default-Date-format-for-write-csv-function-td989826.html.
RDocumentation: strptime base. See http://www.rdocumentation.org/packages/base/versions/3.3.1/topics/strptime.
convert date and time string to POSIX in R - Stack Overflow commented by cryo111 on Sep 18 2013. See http://stackoverflow.com/questions/18874400/convert-date-and-time-string-to-posix-in-r/18874863.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
## Not run: library(ie2misc) # Example to check the input file format # Copy and paste the following code into the R console if you # wish to see the ADAPS .rdb input file format. # Note the number of lines and the row headings. file.show(system.file("extdata", "spring_creek_partial.rdb", package = "ie2misc"), title = paste("spring_creek_partial.rdb")) # opens the .rdb file using the default text editor # Examples to change (an) ADAPS .rdb file(s) interactively and # non-interactively adaps2(system.file("extdata", "spring_creek_partial.rdb", package = "ie2misc")) adaps() # default where interactive = TRUE # Follow the file dialog instructions adaps(interactive = FALSE) # Follow the file dialog instructions # Example to change a directory of ADAPS .rdb files adapsBATCH() # Follow the file dialog instructions ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.