Data Destinations
whonet-file
Creates an Epicollect5 form from a WHONET lab configuration file.
whonet-epicollect-form
Creates an Epicollect5 form from a WHONET lab data.
upload-to-microreact
Creates Microreact projects.
update-google-spreadsheet
Saves data to a Google Spreadsheet. The Spreadsheet should be shared to with `data-flo@data-flo.iam.gserviceaccount.com` and given `can edit` permission.
Data Sources
dropbox-file
Imports a file from Dropbox.
whonet-lab-file
Loads data from a WHONET lab configuration file.
dbf-file
Reads data from a dBASE (`.dbf`) file.
sql-server-database
Connect to and query a SQL Server database and convert the result to a datatable; SELECT statements only.
ariba-file
Imports a card summary file produced by ARIBA (https://github.com/sanger-pathogens/ariba).
epicollect-project
Extracts data from an Epicollect5 project.
figshare-file
Imports a file from Figshare.
ftp-file
Use the File Transfer Protocol to import a file.
google-drive-file
Imports a Google sheet and convert it to a datatable.
google-spreadsheet
Loads data from a Google Spreadsheet. Private sheets should be shared to with `data-flo@data-flo.iam.gserviceaccount.com`.
microreact-project
Extracts data from a Microreact project.
mysql-database
Connect to and query a MySQL database and convert the result to a datatable; SELECT statements only.
Data Tables
datatable-to-csv
Converts a datatable to a CSV string.
extend-datatable
Add a column to a datatable.
change-column-case
Converts the case of text values of a datatable column.
spreadsheet-file
Imports a spreadsheet file and converts to a datatable. Supported file formats: `.xlsx`, `.xlsm`, `.xlsb`, `.xls`, `.xls`, `.xls`, `.xls`, `.ods`, `.fods`, `.csv`, `.txt`, `.sylk`, `.html`, `.dif`, `.dbf`, `.rtf`, `.prn`, and `.eth`.
fill-series
Fills empty values of a datatable column with series of values.
filter-blank-values
Finds rows in a datatable that match a search string or regular expression.
split-date-column
Splits date values into new columns.
filter-rows
Finds rows in a datatable that match a search string or regular expression.
find-and-replace-column-values
Replaces values in source column with some or all matches of a pattern replaced by a replacement. The pattern can be a test or a regular expression. If pattern is a text, only the first occurrence will be replaced. Replacement values are added to target column.
split-datatable-rows
Finds rows in a datatable that match a search string or regular expression.
slice-datatable
Returns a portion of a datatable into a new datatable selected from `begin` to `end`.
format-date-column
Splits date values into new columns.
forward-geocoding
Forward geocode a place into latitude & longitude.
columns-concatenation
Concatenate a columns values into a new column.
add-column
Adds a new column to an existing datatable.
csv-file-to-datatable
Imports a CSV file and converts to a datatable.
reverse-geocoding
Forward geocode a place into latitude & longitude.
join-datatables
Joins rows of two datatables that have the same value for a specified column.
replace-value
Finds and replaces a value in specified columns of a datatable. The pattern can be a test or a regular expression. If pattern is a text, only the first occurrence will be replaced.
replace-column-values
Replaces values in source column with some or all matches of a pattern replaced by a replacement. The pattern can be a test or a regular expression. If pattern is a text, only the first occurrence will be replaced. Replacement values are added to target column.
rename-columns
Renames an existing column in a datatable.
rename-column
Renames an existing column in a datatable.
merge-rows
Add a column to a datatable.
csv-to-datatable
Converts a CSV string to a datatable.
datatable-columns
Converts a datatable to a list of said datatables columns.
remove-columns
Removes specified columns from a datatable.
Graph Manipulation
graph-to-dot
Converts a graph to a DOT string.
datatable-to-graph
Converts a datatable to a graph.
force-directed-layout
Applies forces to a graph to produce a layout based on node and edge relationships.
dot-to-graph
Parses a DOT string as a graph.
List Manipulation
list-element
Returns an element of list at a specified index.
append-to-list
Adds one element to the end of a list.
datatable-to-list
Creates a list from values of a datatable column.
prepend-to-list
Adds one element to the beginning of a list.
slice-list
Returns a portion of a list into a new list selected from begin to end.
sort-list
Sorts elements in a list.
find-value
Finds a value in a list that match a search string or regular expression.
merge-lists
Merges two lists into one.
list-to-datatable
Converts a list to a datatable.
filter-list
Finds values in a list that match a search string or regular expression.
Map Manipulation
datatable-to-map
Creates a map from a datatable.
lookup-map-value
Looks up a value in a map.
Text Manipulation
file-to-text
Converts a file to text.
split-text
Splits a text into a list of texts using a specified separator text to determine where to make each split.
text-to-file
Converts text a text to a file stream.
search-text
Searches for a pattern in a text using a regular expression.
concatenate-text
Concatenates text to the left and/or the right of the input, then returns the combined text as an output.
URL Manipulation
text-to-url
Creates an URL from a input text.
url-builder
Creates an URL from a protocol, hostname, port, and pathname.