search

leppott / ContDataQC

Quality control checks on continuous data. Example data is from a HOBO data logger with 30 minute intervals.
https://leppott.github.io/ContDataQC/
MIT License
20 stars 10 forks source link

QC - Add MonthDay column #111

Closed leppott closed 3 years ago

leppott commented 3 years ago

Is your feature request related to a problem? Please describe. Add one new column to the QC csv file – a MonthDay text field as shown below. It needs to be a text field and have 2-digits for both month and day (e.g., 01/04 instead of 1/4), otherwise it won’t sort properly. This column serves as our left hand column in the pivot table. Right now we are asking users to create that field. It’d be a nice step to skip if possible

Describe the solution you'd like During the QC step when add Month, Day, and Year columns add MonthDay.

Describe alternatives you've considered Can add in Excel after the fact from the Month and Day columns but nicer to have it already added.

Additional context image

leppott commented 3 years ago
  1. Add to QC (regular and File versions).
  2. Combine with date format from config.
  3. Add column name and any other info to the config file.
  4. Update the config file in its various locations in the package (e.g., Shiny).
leppott commented 3 years ago

MonthDay already exists in the config file.

ContData.env$myName.MoDa <- "MonthDay"

It is used in the stats operation.

Do not use a delimiter so always sorts correctly (as a number or character).

Text Editor (Notepad++) image

Excel will drop the leading zeros and if thinks it is a date will add the current year. Since the file is a CSV cannot save the class (number vs. text vs. date).

Excel image

leppott commented 3 years ago

Don't need to modify config file only the two QC scripts.

leppott commented 3 years ago

Added.

Excel image

Text Editor (Notepad++) image

leppott commented 3 years ago

Stats procedure is ok as it generates its own MonthDay. However, no stats are generated on MonthDay. Could be a future update.