I think you are using the spreadsheet format, Gephi also supports a CSV format.
Check http://gephi.github.io/users/supported-graph-formats

To import matrix csv format use File - Open menu item.

For xls files, you can just export them to csv from excel.

Thanks for the tip, but that does not answer my question about importing a CSV in an adjacency matrix format rather than an edge list.

Is that possible?

—Max

Sent from my phone, so please enjoy the autocorrect errors and uncharacteristic brevity.

On Oct 5, 2015, at 14:30, Eduardo Ramos [email protected] wrote:

I think you are using the spreadsheet format, Gephi also supports a CSV format.
Check http://gephi.github.io/users/supported-graph-formats

To import matrix csv format use File - Open menu item.

For xls files, you can just export them to csv from excel.

—
Reply to this email directly or view it on GitHub.

The CSV importer supports Matrix formatting, isn't this what you need? http://gephi.github.io/users/supported-graph-formats/csv-format/

That seems to be incorrect.

When I import an adjacency matrix CSV in the Data Laboratory window, I get the attached error.

When I try to open it under File:Open, it still reads it as just an edge list in source—>target format. (see second attached screenshot)

Can you be more precise how I would access the functionality you are describing? The documentation page you linked to is not at all clear. I'm attaching the CSV in case it helps.

—Max

Max Freund • [email protected] • (909) 632-1624

On Oct 8, 2015, at 11:15 AM, Eduardo Ramos [email protected] wrote:

The CSV importer supports Matrix formatting, isn't this what you need? http://gephi.github.io/users/supported-graph-formats/csv-format/ http://gephi.github.io/users/supported-graph-formats/csv-format/
—
Reply to this email directly or view it on GitHub #1143 (comment).

Hi Max,
Could you share a sample of your file?

I am able to correctly import a matrix CSV formatted like the example in that page:
;A;B;C;D;E
A;0;1;0;1;0
B;1;0;0;0;0
C;0;0;1;0;0
D;0;1;0;1;0
E;0;0;0;0;0

Hi Eduardo,

I sent my file as an attachment to my last message (sent Oct 9). Here it is again.

My last message also included screenshots of the errors I got when I tried to import it.

—Max

Max Freund • [email protected] • (909) 632-1624

On Oct 21, 2015, at 2:17 PM, Eduardo Ramos [email protected] wrote:

Hi Max,
Could you share a sample of your file?

I am able to correctly import a matrix CSV formatted like the example in that page:
;A;B;C;D;E
A;0;1;0;1;0
B;1;0;0;0;0
C;0;0;1;0;0
D;0;1;0;1;0
E;0;0;0;0;0

—
Reply to this email directly or view it on GitHub #1143 (comment).

It seems mail attachments are not processed by github, so they are not available here.
Please try to comment directly in github.

Ah, good to know.

Since Github doesn't allow me to attach a csv or xlsx, here's a link to download the data file:
https://www.dropbox.com/s/78aqxbt8wyngzrn/Communication.csv?dl=0

Here are the screenshots from when I tried to import it.

The file is not found, but that kind of CSV file has to be imported with menu File - Open, instead of import spreadhseet.

CSV format is different than spreadsheet format, we will clarify this in the next release.

Ah yes, that is very confusing. Also, the documentation does not say that the matrix has to be just the edges, without any node labels or numbering to identify the node. If you later import the edge attributes, that could complicate things if the nodes listed in the matrix are not in exactly the same order as the edge attributes.

In the short term, it would be great if the documentation wiki were clarified.

Yes, import spreadsheet is aimed at directly importing tabular data into data laboratory tables, meaning
that you are populating either nodes or edges table at each import.

We will improve the explanation of this import.

So then... how does one go about importing attributes (node names, lat/long, etc.) to the nodes found in the adjacency matrix? So far, I can only get it to import if all my nodes are labeled 1, 2, 3, 4, 5... which is not helpful. I need the attributes.

Maybe I am wrong...
But a good way to achieve what you want is to import the matrix into R (you can use RStudio).
Then you can use the library "reshape2" and the command melt...to melt the matrix into a regular table...
Then you export the results to csv...and use it in excel if you want :)
Is it something like this, that you are looking for?

Actually this should now be possible in Gephi 0.9.2 (nightly build available at https://github.com/gephi/gephi/#nightly-builds). CSV and XLS import is unified in a single importer with auto-detection of format and other improvements.

Marking as implemented in #1282

Hi,
I am new user to gephi. I am trying it out for fMRI data which is in the form of correlation matrix. I am not able to find sufficient tutorial for how to load data in correlation matrix form/adjacency form. Attached is the excel file that I want to make a graph of. Can you let me know how to arrange it and how to load the data ? Thanks...
DataSet2_Edges.xlsx
DataSet2_Node.xlsx

How can i import correaltion matrix into Gephi. I had already plot my network co-corrence on gephi but i want my edges to be based on positive and negative correlation and not on weight. Please how can i go about this.