Data Import

[Webbykk]

Hi there,
I am attempting to use Gephi and have my data set up for use in social network analysis programs.

I therefore have a one mode weighted undirected (edge) matrix in excel which I have converted to csv and I am attempting to import it as my edge table. I have already set up the node file in the Data Laboratory, so yah over that step. My problem is that when I import my table it is not recognizing any source or target data. Do I have to type a edge list rather than use a matrix? If so will it recognize that it is undirected? If not can you advise what I might do to get my columns right with the headings.

Any help greatly appreciated.

Thanks Webbykk

[admin]

Hi,

A matrix is not an edge table, which is an edge list with attributes.

Import your data using File > Import > CSV, and be sure you use one of these formats:
https://gephi.org/users/supported-graph ... sv-format/

[Webbykk]

Hi,
Thanks for that. I have looked at the formats, and the matrix one is what I need to get to.

I have an excel spreadsheet which is a matrix with weighted edges saved as a csv file.

My problem then is that the matrix is not recognized as a matrix format with commas as separators when I import it.

How do I get it to look like the matrix in the format examples?

It is still looking for source and target data when I import just my excel spreadsheet.

I am pretty hopeless at this (as you can tell) and just need a bit more help in how to get the data in a format that I can import it into Gephi as my edge data.

Thanks, Webbykk

[admin]

Can you share your current data file?

[Webbykk]

Hi there

Ok able to share. Node ID is top row and side column. Weights are shown. Matrix is undirected. Here it is.

Thanks

Webbykk

[admin]

Just replace commas by semi-columns using a text editor, and it works.

The Source - Target format is described here:
https://gephi.org/users/supported-graph ... readsheet/

[Webbykk]

Hi again,

Thanks for that but I am still lost?

There are no commas in my excel spreadsheet, so do mean convert it to a different format first?

I am not sure what a text editor is that you might be referring to?

More step by step instructions for dummies is required, sorry.

I understand Gephi wants it in the format you keep pointing me to, but just don't know how to get there from an excel spreadsheet.

Webbykk

[admin]

CSV files are plain text format. When you open it in a text editor like Notepad++, columns are encoded with a comma by default, but Gephi requires semi-columns instead.

[Aggwanji]

What is wrong with the following edges list? I can't import it into Gephi.
Source Target Exports Imports Total trade
Algeria UMA $136.90 $360.50 $497.40
Angola SADC $72.30 $253.80 $326.10
Benin ECOWAS $27.20 $202.40 $229.60
Botswana SADC $521.00 $946.00 $1,467.00
Burkina Faso ECOWAS $3.30 $26.20 $29.50
Burundi COMESA $853.50 $1,523.30 $2,376.80
Cameroon ECCAS $356.20 $714.40 $1,070.60
Cape Verde ECOWAS $1,564.70 $2,187.80 $3,752.50
Central African Republic ECCAS $715.50 $833.50 $1,549.00

[eduramiba]

What is wrong with the following edges list? I can't import it into Gephi.
Source Target Exports Imports Total trade
Algeria UMA $136.90 $360.50 $497.40
Angola SADC $72.30 $253.80 $326.10
Benin ECOWAS $27.20 $202.40 $229.60
Botswana SADC $521.00 $946.00 $1,467.00
Burkina Faso ECOWAS $3.30 $26.20 $29.50
Burundi COMESA $853.50 $1,523.30 $2,376.80
Cameroon ECCAS $356.20 $714.40 $1,070.60
Cape Verde ECOWAS $1,564.70 $2,187.80 $3,752.50
Central African Republic ECCAS $715.50 $833.50 $1,549.00

That format is ready for Spreadsheet import in data laboratory.
Remember to select edges table and space as separator in first step.

Eduardo.