Operator catalog

More tags45

All operators

Showing 1–40 of 104
OperatorVersionsExecutorTrustDownloadsActions
piflow_add_day_idAuthor dacp-examplesPiFlow · Data processing

Spark EcoFlow: sort year/month/day/hour; add id and day_id. Params: partitionNum string. Inputs materialized, max 128 MiB / one million rows.

jvm189.9 KiB6
piflow_add_day_stateAuthor dacp-examplesPiFlow · Data processing

EcoFlow sunrise/sunset day/night classifier using longitude, latitude and day_id (day-of-year); hour uses Beijing time. Params: longitude, latitude as strings. Spark batch, 128 MiB input limit.

jvm190.2 KiB5
piflow_add_uuid_stopAuthor dacp-examplesPiFlow · Data processing

Prepend a distinct 32-character hexadecimal UUID per row. Params: column (new column name).

python9.2 KiB5
piflow_all_fields_clean_neo4jAuthor dacp-examplesPiFlow · Graphs

Convert scalar fields to text and remove double quotation marks. Preserve nulls.

python35.7 KiB2
piflow_average_temperatureAuthor dacp-examplesPiFlow · Statistics

Convert Fahrenheit readings to Celsius and compute one mean per sensor and one-second event-time window.

python35.7 KiB3
piflow_batch_field_threshold_cleanAuthor dacp-examplesPiFlow · Data processing

EcoFlow inclusive threshold cleaning. left: records to clean; right: field,min_value,max_value,flag_value threshold records. No params. Fixes upstream Row-to-string field matching; field names must match exactly. Spark may coerce affected column types.

jvm189.6 KiB5
piflow_bisecting_kmeans_predictionAuthor dacp-examplesPiFlow · Machine learning

Apply a trained Spark bisecting k-means model to Arrow records and append prediction.

jvm22.6 KiB4
piflow_bisecting_kmeans_trainingAuthor dacp-examplesPiFlow · Machine learning

Train a Spark bisecting k-means model on Arrow records and emit the trained model as a ZIP byte stream.

jvm21.2 KiB3
piflow_card_code_cleanAuthor dacp-examplesPiFlow · Data cleaning

Normalize the configured identity column for document type 1. Preserve all other document numbers.

python30.2 KiB3
piflow_column_checkAuthor dacp-examplesPiFlow · Data processing

Validate full ordered column names against a reference and return left input. Params: none. Inputs: left, right. Left-input buffering limit: 128 MiB. Does not check physical units.

python8.6 KiB5
piflow_complement_by_memcacheAuthor dacp-examplesPiFlow · Data processing

Replace selected columns on a lookup key hit. Rows without a matching key keep their original values.

python35.7 KiB3
piflow_consistency_checkAuthor dacp-examplesPiFlow · Data processing

Left-join reference keys; prepend flagField=0 for matches, 1 otherwise. Params: flagField, correlationColumn (comma-separated). Duplicate reference keys retain join multiplicity. 128 MiB input limit each.

python9.7 KiB5
piflow_convert_schemaAuthor dacp-examplesPiFlow · Data processing

Rename columns; does not cast data types. Params: schema, e.g. station_id->station,temperature->air_c.

python9.1 KiB5
piflow_convert_schema_typeAuthor dacp-examplesPiFlow · Data conversion

Convert all input fields to text or cast selected fields to string and 32-bit integer.

python43.0 KiB2
piflow_csv_string_parserAuthor dacp-examplesPiFlow · CSV · Data conversion

Parse headerless UTF-8 CSV text bytes to string records. Params: delimiter, schema; absent schema generates _0, _1, etc. Input stream replaces PiFlow string property.

python8.3 KiB5
piflow_current_and_post_value_interpolationAuthor dacp-examplesPiFlow · Data processing

Interpolate two consecutive missing same-hour daily observations between valid endpoints. Requires year,month,day,hour. Params fields,qualityControlMarkerValue string. Fixes ignored marker and upstream absolute-difference error to support decreasing series.

jvm190.8 KiB5
piflow_custom_viewAuthor dacp-examplesPiFlow · Visualization · CSV

Custom view exported as UTF-8 CSV byte stream with a header. Replaces upstream HDFS visualization file with an output stream; no params, no rendering.

python9.3 KiB5
piflow_data_sortAuthor dacp-examplesPiFlow · Data processing

Globally sort a bounded input on one or more fields. Ascending order places nulls first, and descending places them last.

python35.7 KiB3
piflow_decision_tree_predictionAuthor dacp-examplesPiFlow · Machine learning

Apply a trained Spark decision tree model to Arrow records and append prediction.

jvm22.5 KiB5
piflow_decision_tree_trainingAuthor dacp-examplesPiFlow · Machine learning

Train a Spark decision tree model on Arrow records and emit the trained model as a ZIP byte stream.

jvm21.2 KiB4
piflow_decompress_gzipAuthor dacp-examplesPiFlow · Archives

Decode the gzip member stream and return bytes. A tar.gz input returns the decompressed TAR bytes.

python19.9 KiB3
piflow_discretizationAuthor dacp-examplesPiFlow · Statistics

Assign zero-based numeric bins using upstream equal-width unit cuts or exact equal-frequency quantiles.

python12.6 KiB4
piflow_distinctAuthor dacp-examplesPiFlow · Data processing

Deduplicate records across Arrow batches; retains the first row per key. Params: optional columnNames; empty means all columns. Key-state limit: 128 MiB.

python9.0 KiB5
piflow_docx_parserAuthor dacp-examplesPiFlow · Documents

Extract nonempty text paragraphs from the main document part of a DOCX package, in document order.

python19.9 KiB3
piflow_dr_coordinate_rotationAuthor dacp-examplesPiFlow · Data processing

EcoFlow double coordinate rotation. Params map covariance/wind columns and output Fc,Le,Hs,u_star names. Nonzero horizontal wind required; outputs five-decimal strings. Original Breeze matrix algorithm.

jvm193.7 KiB5
piflow_drop_fieldAuthor dacp-examplesPiFlow · Data processing

Remove record columns incrementally. Params: columnNames (comma-separated string); absent names ignored.

python9.2 KiB5
piflow_email_cleanAuthor dacp-examplesPiFlow · Data cleaning

Convert full-width characters, lowercase the address and return an empty string for malformed addresses. Replace the selected string columns while preserving other fields.

python12.6 KiB4
piflow_evaluate_json_pathAuthor dacp-examplesPiFlow · JSON

Extract one field from each JSON object. Dot-separated paths traverse nested objects; missing fields return null.

python19.9 KiB3
piflow_excel_parserAuthor dacp-examplesPiFlow · Excel

Read the first sheet of each XLS or XLSX Item. Normalize first-row headers and merge string columns by name.

python699.8 KiB3
piflow_excel_readAuthor dacp-examplesPiFlow · Data conversion

XLSX byte stream to string records (no inference), dates as ISO strings, blanks null, cached formula values only. Params optional header boolean(default true),dataAddress [Sheet!]A1[:F35]. Replaces filePath with source bytes. Limits compressed/expanded128MiB and one million selected cells; materializes workbook bytes, preserves worksheet selection. No legacy XLS.

python519.3 KiB8
piflow_excel_writeAuthor dacp-examplesPiFlow · Data conversion

Records to XLSX byte stream; replaces filePath/saveMode with a new workbook output. Params optional header boolean(default true),dataAddress start cell e.g. Sheet1!A1 (no bounded write ranges). Dates become ISO text, formula-looking strings remain text. Bounded128MiB/one million rows; temporary XLSX serialization, not constant-memory streaming. Vendored openpyxl3.1.5/et_xmlfile2.0.0.

python518.5 KiB5
piflow_excel_write_multiple_sheetsAuthor dacp-examplesPiFlow · Excel

Write one worksheet for each of the left and right record inputs, and return one XLSX stream.

python538.5 KiB3
piflow_excel_write_sortAuthor dacp-examplesPiFlow · Excel

Sort records on the selected columns and emit an XLSX byte stream with data written at the requested cell.

python560.2 KiB2
piflow_field_type_conversionAuthor dacp-examplesPiFlow · Data conversion

Cast selected fields to double precision, 32-bit integer or fixed-precision decimal. Preserve other columns.

python35.7 KiB2
piflow_flatten_xml_parserAuthor dacp-examplesPiFlow · XML

Flatten a selected XML parent and optionally emit one row per child of a nested collection.

python19.9 KiB3
piflow_folder_csv_parserAuthor dacp-examplesPiFlow · CSV

Read CSV items from one folder. Skip a first row matching the configured schema and preserve field text.

python30.5 KiB4
piflow_folder_json_parserAuthor dacp-examplesPiFlow · JSON

Read JSON objects and arrays from one folder and concatenate by field name.

python30.5 KiB3
piflow_forkAuthor dacp-examplesPiFlow · Streams

Duplicate each input batch to two fixed ports, left and right. No params. Adaptation: explicit ports replace PiFlow dynamic outports.

python8.5 KiB7
piflow_front_and_back_values_are_validAuthor dacp-examplesPiFlow · Data processing

EcoFlow same-hour interpolation using valid preceding and following days. Requires day_id,hour. Params fields and qualityControlMarkerValue integer string; fixes upstream ignored marker.

jvm190.8 KiB5
piflow_gaussian_mixture_predictionAuthor dacp-examplesPiFlow · Machine learning

Apply a trained Spark Gaussian mixture model to Arrow records and append prediction.

jvm22.6 KiB4