Import CSV Data

Eduardo Ramos edited this page Jan 29, 2018 · 4 revisions

Introduction

This manual shows what steps are necessary to import CSV files into Gephi with data laboratory, which will expect that each row of the file is a node or an edge.

Note that the import can be done at any moment, the workspace does not need to be empty. You should know some general aspects of the import process:

  • You may choose which columns to import. The only exceptions are 'Source' and 'Target' for edges tables, which are mandatory and can't be deselected
  • If a column title already exists in the workspace you will be able to use it but the data type of the column can't be changed, and imported data will be parsed to fit the existing column type
  • Data for each row and column will be parsed to the given/existing column data type when possible. If this is not possible for a given cell, then it will be set to a null value
  • You can choose what table to import the rows to (nodes or edges), but the behaviour and requirements are different. Be aware of what options you have selected before executing the import process

Next we'll learn how to use the import wizard to customize the data to our needs based on the options available.

Launching the import CSV wizard and first step

Start by clicking 'Import CSV' button in Data Laboratory as shown in the picture

launch-import-csv-wizard

Then the import wizard will open and you are presented with some generic, table independent options.

import-csv-step1

In this step you will indicate the format of the CSV file and can preview the resulting table.

  • First specify a CSV file that is not empty
  • Then choose the values separator from some common options and the encoding/charset of the file
  • Finally select the table to import the rows and columns of the file. Edges table files require, at minimum, columns labeled 'Source' and 'Target' (which can be case insensitive)

Last step - Choosing columns details and table specific options

This final step offers some common options and behaviour descriptions for both nodes tables or edges tables:

  • You can mark what columns to use and select their type when they don't exist yet
  • If no node/edge Id column is provided or it is empty for some row, an automatic id will be assigned

Importing to nodes table

When importing to nodes table you can also indicate if you want to update a node's data instead of creating a new node when a node with that id already exists.

import-csv-step2-nodes

Importing to edges table

In case of importing to edges table, the behaviour is a bit different:

  • 'Source' and 'Target' node Ids are mandatory for all rows
  • Edge type is optional and its default is 'Directed'

import-csv-step2-edges

Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.