README.md
In dmwarn/CruiseCheckeR: Provide Tools to Evaluate Data Quality
CruiseCheckeR
CruiseCheckeR is an R package written to provide a tool for examining data intended for entry in the U.S.G.S. Great Lakes Science Center RVCAT database. The data stored in this database includes a more broad suite of sample types than is currently supported by this package. At present, the package is only useful for trawl data.
The typical process of getting data into the RVCAT database has included appending of new data followed by visualization of data to look for errors or problems. Researchers provide either csv files or Oracle dmp files to the GLSC database manager, who would append the data to the appropriate tables. Subsequently, researchers would use a variety of tools to examine the accuracy, correctness, and completeness of data. The two things these tools have in common are 1) they require the researcher to query the data from the RVCAT database and 2) they have been used on data AFTER they are appended to the database.
Because the tools have been used primarily after they are appended, this has mean that any corrections have to be made to the database. This package includes the function CruiseCheckeR(), which allows the user to visualize data prior to appending to the database and also allows the user to visualize data in csv files prior to the appending process.
The use of the database query feature for Oracle databases of this package requires installation of Oracle Instant Client and Oracle Database Client. Instructions for making these functional can be found at http://cran.cnr.berkeley.edu/web/packages/ROracle/INSTALL). The process was inspired by the content posted and referenced at https://support.rstudio.com/hc/en-us/articles/217800798-Can-we-connect-R-and-RStudio-to-our-Oracle-Database-. A minimal requirement over and above the Oracle software mentioned above is package DBI (https://cran.r-project.org/web/packages/DBI/index.html). There are additional packages that can be used. CruiseChecker() uses DBI::dbConnect() and dbplyr::in_schema (https://cran.r-project.org/web/packages/dbplyr/index.html) to carry out queries.
dmwarn/CruiseCheckeR documentation built on Oct. 11, 2020, 9:56 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
CruiseCheckeR
CruiseCheckeR is an R package written to provide a tool for examining data intended for entry in the U.S.G.S. Great Lakes Science Center RVCAT database. The data stored in this database includes a more broad suite of sample types than is currently supported by this package. At present, the package is only useful for trawl data.
The typical process of getting data into the RVCAT database has included appending of new data followed by visualization of data to look for errors or problems. Researchers provide either csv files or Oracle dmp files to the GLSC database manager, who would append the data to the appropriate tables. Subsequently, researchers would use a variety of tools to examine the accuracy, correctness, and completeness of data. The two things these tools have in common are 1) they require the researcher to query the data from the RVCAT database and 2) they have been used on data AFTER they are appended to the database.
Because the tools have been used primarily after they are appended, this has mean that any corrections have to be made to the database. This package includes the function CruiseCheckeR(), which allows the user to visualize data prior to appending to the database and also allows the user to visualize data in csv files prior to the appending process.
The use of the database query feature for Oracle databases of this package requires installation of Oracle Instant Client and Oracle Database Client. Instructions for making these functional can be found at http://cran.cnr.berkeley.edu/web/packages/ROracle/INSTALL). The process was inspired by the content posted and referenced at https://support.rstudio.com/hc/en-us/articles/217800798-Can-we-connect-R-and-RStudio-to-our-Oracle-Database-. A minimal requirement over and above the Oracle software mentioned above is package DBI (https://cran.r-project.org/web/packages/DBI/index.html). There are additional packages that can be used. CruiseChecker() uses DBI::dbConnect() and dbplyr::in_schema (https://cran.r-project.org/web/packages/dbplyr/index.html) to carry out queries.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.