CTRL + K
Stories
Agents
Bricks
Constellab Space LogoSpace
Login
Back to bricks list
Introduction Getting Started
Architecture
Technical Documentation
Tasks
Barplot Plotly Boxplot Plotly Conda env agent Converter Create a sugar type of food Create folder from files Create json dict Create lab note Create note resource Create robot Decompress file Describe Download an scenario Download resource from a S3 bucket Download resource from external source Eat task Env agent Extract column tags to new row Extract column values to row tags Extract row tags to new column Extract row values to column tags Fly task Folder exporter Fs node extractor Generate lab note from note resource GenerateStreamlitTestApp Histogram Plotly Input Input from task output JSON Dict exporter JSON Dict importer Line Plotly Mamba env agent Melt Merge note resources Move robot Output Pip env agent Python agent R conda env agent R mamba env agent Resource exporter Resource importer Resource picker Resource set exporter Resource stacker Robot add Scatterplot Plotly Select a scenario Select note Select note template Send a scenario to a lab Send the resource to a lab Shell wait Smart interactive plot generator Smart json transformer Smart multi tables transformer Smart plot generator Smart table transformer Streamlit agent Streamlit conda agent Streamlit env agent Streamlit mamba agent Streamlit pip env agent Switch2 Table column aggregator Table column aggregator filter Table column annotator Table column concat Table column data numeric filter Table column data text filter Table column operation mass Table column operations Table column scaler Table column tag aggregator Table column tag unfolder Table column tags deleter Table column tags selector Table columns deleter Table columns selector Table exporter Table importer Table replace Table row aggregator Table row aggregator filter Table row annotator Table row concat Table row data numeric filter Table row data text filter Table row scaler Table row tag aggregator Table row tag unfolder Table row tags deleter Table row tags selector Table rows deleter Table rows selector Table scaler Table transposer Task Task Plotly Text exporter Text importer The travel of `Astro` Transformer Unzip and load resource Update note resource Upload resource to S3 Viewer Violinplot Plotly Wait Wait task Write to file Zip resource [Support] Update process typing name [Support] Update resource typing name Version

Table importer

IMPORTER
12 times
91.67 %
480 milliseconds
Typing name :  TASK.gws_core.TableImporter Brick :  gws_core

Import file to Table

Generic task that take a file as input and return a resource

Override the import_from_path method to import the file to the destination resource

Input

File
File

Output

Table
2d excel like table
Table

Configuration

file_format

Optional

File format

Type : stringAllowed values : auto xlsx xls csv tsv tab txt Default value : auto

delimiter

Optional

Delimiter character. Only for parsing CSV files

Type : stringAllowed values : auto tab space , ; Default value : auto

header

Optional

Row to use as the column names. By default the first row is used (i.e. header=0). Set header=-1 to not read column names.

Type : int

format_header_names

Optional

If true, the column and row names are formatted to remove special characters and spaces (only '_' are allowed).

Type : bool

index_column

Optional Advanced parameter

Column to use as the row names. By default no index is used (i.e. index_column=-1).

Type : intDefault value : -1

decimal

Optional Advanced parameter

Character to recognize as decimal point (e.g. use ‘,’ for European/French data).

Type : stringDefault value : .

nrows

Optional Advanced parameter

Number of rows to import. Useful to read piece of data.

Type : int

comment

Optional Advanced parameter

Character used to comment lines. Set empty to disable comment lines.

Type : stringDefault value : #

encoding

Optional Advanced parameter

Encoding of the file, 'auto' for automatic detection.

Type : stringDefault value : auto

metadata_columns

Optional Advanced parameter

Columns data to use to tag the rows of the table

Type : ListMaximum occurrences number : -1

column

Optional Advanced parameter

Metadata column to use to tag rows

Type : string

keep_in_table

Optional Advanced parameter

Set True to keep the column in the final table; False otherwise

Type : boolDefault value : true