Avatar

Adrian Williams

  • Total activity 274
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 105

Activity overview

Latest activity by Adrian Williams
  • Avatar

    Adrian Williams commented,

    Hi Donald, 1. Apologies for the broken link. The information on installing CRAN packages can be found in the product's integrated help in the following topic:     Reference > Installing CRAN packag...

  • Avatar

    Adrian Williams created a post,

    Fuzzy De-duplication of Name Data

    A user recently asked for some help with the use of the Fuzzy Join node and I thought it may be useful to the other users in the Dataverse community. The requirement was to identify potential dupli...

  • Avatar

    Adrian Williams created a post,

    Outlier Detection Using Modifed Z-Score

    When preparing data for analysis, it is best practice to profile your data to identify any outliers - but what is an outlier? An outlier is an observation whose value is markedly different from the...

  • Avatar

    Adrian Williams created a post,

    Conditional Data Entry Custom Node

    When preparing data you may need to create a new field whose value depends on whether or not the value in another data field matches a defined condition - for example to implement logic like:  If '...

  • Avatar

    Adrian Williams created a post,

    Using Composite Properties to Parameterize a Node

    When creating custom nodes that are based on the Transform node, you may want to parameterize your node so that values can be configured from an input property of the node rather than editing the u...

  • Avatar

    Adrian Williams created a post,

    Extract the Date Element from a Datetime Field

    A Dataverse user recently asked how to extract the date element from a datetime field. This can be achieved relatively easily using some Python scripting in the Transform node as follows: In the Tr...

  • Avatar

    Adrian Williams created a post,

    Expanding a List into Multiple Columns

    When preparing data you may have to handle a field that contains a list of values that are separated by a delimiter. A previous article described how to expand the list of values to produce a recor...

  • Avatar

    Adrian Williams created a post,

    Working With Untidy Date Values

    When analyzing data it is frequently necessary to ingest data that contains string representations of date values. Unfortunately, the format of the date values can vary depending on the source of t...

  • Avatar

    Adrian Williams created a post,

    Aggregate Counts of Known Categorical Values

    When working with categorical data, the GroupBy functionality of the Aggregate node can be used to count the number of occurrences of a particular categorical value in a data set. However, the Aggr...

  • Avatar

    Adrian Williams created a post,

    Rename Fields Custom Node

    When building a data flow and analysing data a frequent requirement is to rename fields, for example, to make them more descriptive. You can rename fields (and perform a wide range of other tasks) ...