Creates a sub folder in a parent folder in Google Drive. The parent folder should be shared with `data-flo@data-flo.iam.gserviceaccount.com` and given `can edit` permission.

Creates a Microreact project.

Creates DBF files from a datatable.

Exports a datatable to a SQLite DB file.

Sends a JSON encoded HTTP request.

Sends an email message via a SMTP server.

Imports data from a SQLite file.

Uploads metadata to COG-UK CLIMB via the Majora API See https://docs.covid19.climb.ac.uk/majora-api.

Exports data to an existing Google Sheets spreadsheet. Private spreadsheets should be shared with `data-flo@data-flo.iam.gserviceaccount.com` and given `can edit` permission.

Updates a project on a Microreact server.

Saves a file to a folder in Google Drive. The folder should be shared to with `data-flo@data-flo.iam.gserviceaccount.com` and given `can edit` permission.

Saves a list of files to a folder in Google Drive. The folder should be shared to with `data-flo@data-flo.iam.gserviceaccount.com` and given `can edit` permission.

Creates Microreact projects.

Creates an Epicollect5 form from a WHONET lab data.

Creates an Epicollect5 form from a WHONET lab configuration file.

Calculates the time difference (in a specified unit of measurement) between two datatable columns. (reference column - value column)

Sums rows in specified columns

Groups rows by specified columns and puts them in a collection.

Aggregates values in specified columns grouped by rows.

Sums values in specified columns.

Imports a card summary file produced by ARIBA (https://github.com/sanger-pathogens/ariba).

Converts data from a dBASE (`.dbf`) file to a datatable.

Imports a file from the web.

Imports a file from Dropbox.

Imports data from an Epicollect5 project.

Imports a file from Figshare (https://figshare.com/).

Use the SSH File Transfer Protocol or File Transfer Protocol to import a file. **FTP server** When specifying the URL for connection to a FTP server use the syntax ``` ftp:://[username:password@]hostname.com/path/to/file.txt ``` username and password are optional. If you omit the `username:password@` then `anonymous` will be used for both username and password **SFTP server** When specifying the URL for connection to a SFTP server use the syntax ``` sftp:://username:password@hostname.com/path/to/file.txt ``` username and password are required.

Imports a file from Google Drive

Imports data from a Google Sheets spreadsheet. Private sheets should be shared with `data-flo@data-flo.iam.gserviceaccount.com`.

Imports the metadata table from a Microreact project.

Imports data from a MySQL database.

Imports data from an ODBC database.

Imports data from an Oracle Database and returns the results as a datatable.

Imports data from a PostgreSQL database.

Imports a remote file from a remote network server.

Imports a file from an S3 compatible endpoint,

Imports a file from a shared network drive using standard SMB/CIFS protocol.

Retrieves a list of files from a shared network drive using standard SMB/CIFS protocol

Imports data from a spreadsheet file.

Imports data from a Microsoft SQl Server database.

Exports data to an Epicollect5 project.

Retrieves a file from a SMB/CIFS server.

Loads data from a WHONET lab configuration file.

Stores a file to a remote network server.

Adds a new column to an existing datatable.

Adds random noise to specified latitude/longitude columns in a datatable.

Converts the case of text values in a datatable column.

Concatenate values from two or more columns, and/or adds a text prefix, and/or adds a text suffix into a new column.

Compares values in specified columns.

Imports a CSV file and converts to a datatable.

Imports a CSV file and converts to a datatable.

Converts delimited text (e.g. comma-separated values) to a datatable.

Creates a list of datatable column names.

Converts a datatable to a CSV string.

Exports a datatable to a CSV file.

Removes a list of columns from datatable.

Add a column to a datatable.

Fills empty values of a datatable column with series of values.

Filters blank rows in a datatable column.

Removes columns whose name contains a string or matches a regular expression from a datatable.

Finds rows in a datatable that match a search pattern.

Finds rows in a datatable that match a numeric comparison using the `>`, `>=`, `<` or `<=` operators.

Replaces values in source column with some, or all matches of a text/pattern being replaced by a new text/pattern. The pattern can be a text or a regular expression. If the pattern is a text, only the first occurrence will be replaced. Replacement values are added to 'replace' column.

Formats date/time values within a datatable column.

Converts location names in a datatable column to latitude & longitude.

Reshapes rows from wide format to long format. See http://www.milanor.net/blog/reshape-data-r-tidyr-vs-reshape2.

Generates and adds UUID values to a datatable column.

Joins two datatables based on a common column between them.

Renames an existing column in a datatable.

Appends rows of two datatables into a new datatable based on common column names.

Removes specified columns from a datatable.

Removes duplicate rows from a datatable.

Renames an existing column in a datatable.

Renames existing columns in a datatable.

Replaces blank values in a datatable column.

Replaces values in a column with some or all matches of a pattern replaced by a new value. The pattern can be a text or a regular expression. If pattern is a text, only the first occurrence will be replaced. Replacement values can be added to a new column.

Finds and replaces a value in specified columns of a datatable. The pattern can be a text or a regular expression. If pattern is a text, only the first occurrence will be replaced.

Converts latitude & longitude in datatable columns to location names.

Returns the value of datatable column at a specified row.

Selects a list of columns from a datatable in a specified order.

Selects rows, based on position, from a datatable

Sorts a datatable by one or more columns

Splits values in a column into a number of columns using a specified separator to determine where to make each split.

Finds rows in a datatable that match a pattern. The pattern can be a text or a regular expression.

Splits date values into new columns.

Reshapes rows in long format to wide format.

Creates a graph structure from a datatable containing edge data.

Creates a graph structure from text in DOT language format

Applies a force-directed graph drawing algorithm (https://en.wikipedia.org/wiki/Force-directed_graph_drawing) on a specified graph.

Exports a graph as a text file in DOT format.

Adds a collection to another collection.

Adds a datatable to a collection.

Adds a list to a collection.

Adds a number to a collection.

Adds a text to a collection.

Creates an empty collection.

Creates a datatable from JSON text.

Creates a list from JSON text.

Merges the entries of two collections.

Creates JSON text from YAML text.

Adds one or more text values to the end of a list.

Creates a list from values of a datatable column.

Finds values in a list that match a pattern.

Finds a value in a list that matches a search pattern.

Returns an element of a list at a specified index.

Converts a list to a single-column datatable.

Converts a list of text to a list of files.

Appends two lists into one.

Adds one element to the beginning of a list.

Replaces each value in a list of text based on a pattern. The pattern can be a text or a regular expression.

Selects values, based on position, from a list

Sorts elements in a list.

Splits a list into two lists at the first instance of a specified separator element.

Removes duplicate values in a list.

Adds a text value to a map.

Creates a map from a datatable.

Finds a key in a map and returns the paired (associated) value.

Searches for a pattern in a text using a regular expression.

Concatenates two texts

Converts a date/time value to text in a specified format.

Converts a file to text.

Lists the leaf labels from a Newick tree.

Replaces values in a text with some or all matches of a pattern replaced by a new value. The pattern can be a text or a regular expression. If pattern is a text, only the first occurrence will be replaced.

Searches for a pattern in a text using a regular expression.

Splits a text into a list of texts using a specified separator text to determine where to make each split.

Creates text using a Mustache template (https://mustache.github.io/).

Exports text as a file.

Converts an URL to text.

Creates an URL from an input text.

Creates an URL from a protocol, hostname, port, and pathname.