Skip to main content
Skip table of contents

File Manipulation - Convert CSV

Overview

Convert one or more CSV files into a TSV, PSV, XLSX, Parquet, DTA, or HDF5 file.

The match type selected greatly affects how this Blueprint works.

This Template uses built-in Pandas methods to read in a CSV file and output it as another file type.

Variables

Name

Reference

Type

Required

Default

Options

Description

Destination File Format

MANIPULATION_DESTINATION_FILE_FORMAT

Select

tsv

Tab-Separated File (.tsv): tsv

Pipe-Separated File (.psv): psv

Excel File (.xlsx): xlsx

Parquet (.parquet): parquet

Stata (.dta): stata

HDF5 (.h5): hdf5

Type of file that you want the CSV file(s) converted into.

Local Folder Name

MANIPULATION_SOURCE_FOLDER_NAME

Alphanumeric

-

-

Name of the local folder on Platform where the target file lives. If left blank, will look in the home directory.

Local File Name Match Type

MANIPULATION_SOURCE_FILE_NAME_MATCH_TYPE

Select

exact_match

Exact Match: exact_match

Regex Match: regex_match

Determines if the text in "Local File Name" will look for one file with exact match, or multiple files using regex.

Local File Name

MANIPULATION_SOURCE_FILE_NAME

Alphanumeric

-

-

Name of the target file on Platform. Can be regex if "Match Type" is set accordingly.

New Folder Name

MANIPULATION_DESTINATION_FOLDER_NAME

Alphanumeric

-

-

Folder where the newly converted file(s) should be created on Platform. Leaving blank will place the file in the home directory. If the folder does not already exist, it will be created.

New File Name

MANIPULATION_DESTINATION_FILE_NAME

Alphanumeric

-

-

What to name the newly converted files on Platform. If left blank, defaults to the original file name(s) with an updated extension based on the selected file format.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.