Recode Date/Time Variable

Description

Recode a date or time meta-data variable to create a new variable, for example in order to use larger time units (month, week...).

Details

This dialog allows creating a new variable from a date or time variable, by specifying a new time format in which the values of the new variable will be expressed.

Typical use cases include:

  • Create a month variable from a full date: Use format “%Y-%m” to get four-digit year and two-digit month; or “%y %B” to get two-digits year and full month name.

  • Create a week variable from a full date: Use format “%U” to get the week number in the year starting on Sunday, or “%W” for the week number in the year starting on Monday.

  • Create a date variable from a time variable: Use format “%Y-%m-%d” to get four-digit year, two-digit month and two-digit day.

The format codes allowed are those recognized by strptime (see ?strptime), in particular:

‘%a’

Abbreviated weekday name in the current locale. (Also matches full name.)

‘%A’

Full weekday name in the current locale. (Also matches abbreviated name.)

‘%b’

Abbreviated month name in the current locale. (Also matches full name.)

‘%B’

Full month name in the current locale. (Also matches abbreviated name.)

‘%d’

Day of the month as decimal number (01-31).

‘%H’

Hours as decimal number (00-23).

‘%I’

Hours as decimal number (01-12).

‘%m’

Month as decimal number (01-12).

‘%M’

Minute as decimal number (00-59).

‘%U’

Week of the year as decimal number (00-53) using Sunday as the first day 1 of the week (and typically with the first Sunday of the year as day 1 of week 1). The US convention.

‘%W’

Week of the year as decimal number (00-53) using Monday as the first day 1 of the week (and typically with the first Monday of the year as day 1 of week 1). The UK convention.

‘%p’

AM/PM indicator in the locale. Used in conjunction with ‘%I’ and not with ‘%H’.

‘%S’

Second as decimal number (00-61).

‘%y’

Year without century (00-99).

‘%Y’

Year with century.

“Time units” are chosen automatically according to the values of the time variable: it is set to the smallest unit in which all time values can be uniquely expressed. For example, if free dates are entered, the unit will be days; if times are entered but minutes are always 0, hours will be used; finally, if times are fully specified, seconds will be used as the time unit. The chosen unit appears in the vertical axis label of the plot.

Three measures of term occurrences are provided (when no variable is selected, “category” below corresponds to the whole corpus):

  • Row percent corresponds to the part of chosen term's occurrences over all terms found in a given category (i.e., the sum of word counts of all documents from the category after processing) at each time point. This conceptually corresponds to line percents, except that only the columns of the document-term matrix that match the given terms are shown.

  • Column percent corresponds to the part of the chosen term's occurrences that appear in each of the documents from a given category at each time point. This measure corresponds to the strict definition of column percents.

  • Absolute counts returns the relevant part of the document-term matrix, but summed for a given time point, and after grouping documents according to their category.

The rolling mean is left-aligned, meaning that the number of documents reported for a point reflects the average of the values of the points occurring after it. When percents of occurrences are plotted, time units with no occurrence in the corpus are not plotted, since they have no defined value (0/0, reported as NaN); when a rolling mean is applied, the values are simply ignored, i.e. the mean is computed over the chosen window without the missing points.

See Also

setCorpusVariables, meta, zoo, xyplot, varTimeSeriesDlg, recodeTimeVarDlg