Recipe filters @ HXL Proxy

Original data: http://64511-id.tv53.ru

Recipe filters Help

Cut columns [x]

Cut columns

Help Remove columns from your dataset.

Label

Includes: include only these tags (comma-separated)

Excludes: include everything but these tags (comma-separated).

Remove columns without HXL hashtags
Rename column [x]

Rename column

Help Rename and retag an existing column.

Label

Original hashtag pattern

Choose only columns with this text header (optional)

New hashtag and attributes

New text header.
(new filter)

New filter

Choose filter type to add

Help Add a new column (with a constant value) to the data.

Label

Tag for new column.

Fixed value for new column.

Display header for new column.

Add new column to front

Help Combine multiple HXL datasets.

Label

Exclude columns not in original dataset.

URL of additional dataset Remove URL
… or pick a dataset from HDX or Dropbox or Google Drive

Add another URL

Append only rows matching this query

Help Combine multiple HXL datasets using an external list.

Label

Exclude columns not in original dataset.

URL of the external list
… or pick a dataset from HDX or Dropbox or Google Drive

Append only rows matching this query

Help Clean up your dataset by standardising dates and numbers, removing whitespace, etc.

Label

Normalise whitespace for these hashtags

Standardise lat/lon for these hashtags

Convert to uppercase for these hashtags

Convert to lowercase for these hashtags

Standardise dates for these hashtags

Format for cleaned dates (optional)

Standardise numbers for these hashtags

Format for cleaned numbers (optional)

Purge malformed dates, numbers, and lat/lon during cleaning.

Clean data only in rows matching this query

Help Aggregate HXL data to generate reports or protect private data.

Label

Tag pattern(s) for column(s)
Count unique combinations of values from columns matching one or more of these tag patterns (comma-separated). If blank, count unique combinations of values from all columns.

Row query
Count values from rows matching this row query. If blank, count values from all rows.

Aggregate values to generate

Aggregation type

Source column

Output column header

Output column hashtag

Remove aggregate

Add aggregator

Help Remove columns from your dataset.

Label

Includes: include only these tags (comma-separated)

Excludes: include everything but these tags (comma-separated).

Remove columns without HXL hashtags

Help Remove duplicate rows from a dataset.

Label

Tags to look at for deduplication (if blank, all columns must match for a duplicate).

Deduplicate only rows matching this query

Help Expand lists by duplicating rows

Label

Expand lists in these columns
If blank, expand lists in all columns containing the +list attribute

List separator string
Defaults to "|" if unspecified.

Correlate list values in multiple columns
If checked, correlate the list items in multiple columns; otherwise, generate their Cartesian product (one row for each possible combination). Has no effect if you select only a single column.

Expand lists only in rows matching this query

Help Normalise data from "wide" to "narrow" using the headers as labels. This filter uses the special +label attribute to identify columns.

Label

Attribute for former header text.

Attribute for original value.

Help Fill empty cells from previous values in the same column.

Label

Tag patterns for filling (blank means fill all).

Fill only in rows matching this query

Help Denormalise data from "narrow" to "wide".

Label

Labels column:

Values column:

Help Extract a value from a JSON expression in a cell using a JSONPath expression.

Label

JSONPath expression for extracting a value.

Tag patterns for applying the JSONPath (blank means apply to all).

Apply only to rows matching this query

Flatten multiple results (separated by " | ")

Help Add columns from another dataset, based on common keys.

Label

URL of merge dataset (pull extra data from here)
… or pick a dataset from HDX or Dropbox or Google Drive

Shared keys (values that are the same in both datasets)

Tags to copy from other dataset

Use existing columns where possible.

Overwrite existing values.

Help Rename and retag an existing column.

Label

Original hashtag pattern

Choose only columns with this text header (optional)

New hashtag and attributes

New text header.

Help Replace values in the dataset.

Label

Text or pattern to replace

Use a regular expression pattern.

Replacement text

Replace only in these columns

Replace only in rows matching this query

Help Replace values using an external mapping table.

Label

URL of the external mapping table
… or pick a dataset from HDX or Dropbox or Google Drive

Replace only in rows matching this query

Help Include rows that match any of the following queries

Label

Queries (e.g. adm1=Bomo)

Invert query (include rows that don't match any of the queries)

Help Sort the records in a HXL dataset

Label

Use these tags for sorting.

Reverse order

Strip text headers

Never cache

Filename (no ext)

Max rows

Error!

The HXL Proxy does not allow data from this domain. If your data is on HDX, you can use the dataset or resource URL with the HXL Proxy. Otherwise, please send requests to allow new humanitarian-data domains to hdx@un.org. http://64511-id.tv53.ru