DRB Driver CSV

drb-driver-csv is a Python plugin for DRB, representing DRB driver allowing to recognize and to browse CSV (Comma-Separated Values) data.

Installation

pip install drb-driver-csv

Quick Started

from drb.drivers.csv import CsvNodeFactory

# generate the CSV node (DRB resolver can be used also)
node = CsvNodeFactory().create('url/to/csv/data.csv')

# select a row first row by index
row = node[0]
# select a row first row by name
row = node['row_0']

# select first value in a row by index
row[0]
# select a value in a row by name
row['header']

# retrieve value from row: 5, column 1
node[5][1].value

Driver

The drb-driver-csv reads a CSV data like it having a header, so the first row is the second line of the CSV data.

Each node defined in this driver represent a unitary part or whole content of a CSV data:

More details in the following section.

Nodes

CsvBaseNode

The CsvBaseNode wraps another DRB node (base_node) representing the CSV data and allows to provide an entry point to the CSV content.

Attributes

The CsvBaseNode has no attribute.

Children

Each child of the CsvBaseNode repersenting a row of the CSV content. Those children are accessible via:

• index (int): CSV row index
• name (str): generic name following the pattern row_N:
  • row_ is a string constant
  • N is the row index (int)

Implementations

The CsvBaseNode inherits from the base_node, plus a pandas.DataFrame implementation to see the data as array.

Learn more about pandas.

CsvRowNode

A CsvRowNode represent a row from a CSV content.

Attributes

The CsvRowNode has no attribute.

Children

A child of a CsvRowNode is a node containing the value for the associate header. Those children can be accessible via:

• index (int): using header index
• name (str): using the header name

Implementations

The CsvBaseNode has no implementation.

CsvValueNode

A CsvValueNode represent a cell value from a CSV content. The associated value is accessible via the value property

Attributes

A CsvValueNode has no attribute.

Children

A CsvValueNode has no child.

Implementations

A CsvValueNode has no implementation

Factory

The drb-driver-csv provide a factory csv generating only CsvBaseNode.

Topic

The drb-driver-csv comes also with a DRB topic allowing to resolve and to recognize CSV data.

graph RL
    A([CSV<br/>c03d4f6b-d147-4eeb-8433-72fcdabbef9f])

uuid	from	label	category	factory
c03d4f6b-d147-4eeb-8433-72fcdabbef9f	∅	CSV	FORMATTING	csv