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 Blueprint 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 Shipyard 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 Shipyard. 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 Shipyard. 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 Shipyard. If left blank, defaults to the original file name(s) with an updated extension based on the selected file format. |