Gephi forums

Data Import / Export • Exporting GEXF from Python networkx: label problem

2021-11-06T18:45:34+01:00

Dear friends,
I am building a graph with python's networkx library and then writing it out with tne nx.write_gexf(G, filename) function.

The graph is a multigraph with the nodes being authors and an edge added each time it coauthors with someone else.

Upon importing all goes well, I simply SUM the edges if there are more than one between two nodes and all the date is to be found in the data laboratory but I find that the Label column is empty and there is ANOTHER Label column added with the names.

This is how I iterate through my authors (pis) dataframe and build the nodes:

for index, row in pis.iterrows():
G.add_node(row['scid'], Label=row['name'], hindex=row['hindex'], lastyear=row['recentyear'], cits=row['cits'], role='PI', affil="IIT")

What am I doing wrong? Can't I directly have the labels filled for me?

The solution right now is manual: use the copy from another column and copy the "Label" column in the real Label column but it is a bit cumbersome.

Thanks a lot.

Statistics:Posted by rjalex — 06 Nov 2021 18:45

Data Import / Export • Please help importing from CVS

2021-01-04T12:57:26+01:00

Dear friends,
I have a CVS file roughly made like this:

Name, ID, Role, ManagerID
Robert, 001, Technician, 004
Ann, 002, Seller, 004
John, 003, Seller, 005
Daniela, 004, Manager, 007

From which I'd need to build a graph with nodes 001,002,003,004 and the Names as the nodes labels.
I also would like to use the Role content to partition/colour the graph.

The directed edges would show that 001 and 002 report to 004 (not quite sure if I would represent the 005 and 007 nodes since I don't have data for them but could use them to generate edges).

From the online documentation I am not sure to understand how to convert the source CSV file in such a way that it not only builds a node and an edges list, but would also bring in the nodes attributes such as Role.

Thank you very much. Happy 2021.

Statistics:Posted by rjalex — 04 Jan 2021 12:57

Data Import / Export • Adjacency list, but all combinations

2019-01-31T13:19:10+01:00

I have tried looking for an answer, but to no avail. My problem is the following: I have a number of names and I would like to construct a network of with their connections. Generally, they work in groups of three. So, let's assume they follow this scheme:

CODE:

ROW 1: Alice, Bob, CarolROW 2: John, Kate, Laura

My problem is that, the way I understand it, this would make Alice-> Bob; Alice -> Carol. Not, however Bob -> Carol.

In order to do that right from the outset, I would need to have additional rows with the different combinations. In other words, I would need:

CODE:

ROW 1: Alice, Bob, CarolROW 2: Bob, Alice, CarolROW 3: Carol, Alice, Bob

I am not sure, however, how this could be done. Can anybody suggest a solution?

Thanks!

Statistics:Posted by CaseLawMiner — 31 Jan 2019 13:19

Data Import / Export • How do I translate this list into a network in gephi?

2019-01-29T02:15:13+01:00

Hello,

I need your help with the following.

I have a list of more than 10,000 business projects. Each project has several participants and I want to analyze the collaboration networks of these participants.

The data is organized in a .csv file in the following way:

Project 1: Company 1; Company 2; Company 3 *
Project 2: Company 3; Company 5; Company 6; Company 10
Project 3: Company 10; Company 1

* It means that in project 1 the links are (Company 1-Company 2, Company 1- Company 3, Company 2-Company 3). etc.

How do I translate this list into a network in gephi?
Is there any way to enter the data in this format list? Or should I build an adjacency list or a quadratic matrix? Is there a quick and automatic way to move from this list to an adjacency list?
Any guidance will be welcome!

Thank you !

Statistics:Posted by cecitomassini — 29 Jan 2019 02:15

Data Import / Export • Re: Generating GraphML File

2018-06-18T09:51:31+01:00

What does your exported graphml from gephi look like? It should be fine.

Just import an 'edges table' kind of CSV to gephi. That will create edges and its necessary nodes, then just export to graphml.

Statistics:Posted by eduramiba — 18 Jun 2018 09:51

Data Import / Export • Re: Generating GraphML File

2018-06-14T19:37:01+01:00

I have convert the inp file to CSV and imported to gephi, but it is not working like what I expected. The Epanet file has nodes and pipes (edges). The graphML file should first introduces nodes and secondly (source and target) for the pipes or links. The following is an example of it:

If you don't mind, can I send you the inp file please.

Thank you very much for your kind and continues help.

Statistics:Posted by karwan1986 — 14 Jun 2018 19:37

Data Import / Export • Re: Generating GraphML File

2018-06-13T21:37:50+01:00

Well you can just import the CSV to Gephi and then export it as graphml

Statistics:Posted by eduramiba — 13 Jun 2018 21:37

Data Import / Export • Re: Generating GraphML File

2018-06-13T21:28:03+01:00

Dear eduramiba

First of all, super thanks for replying........

I just need GraphML File form, since I am doing clustering with it. And also, the inp file has larger number of nodes and likes, using GraphML File helps to easy lunched with Gepghi than CSV form. Could you please make your suggestion to create a GraphML File for and an inp file.

Thank you

Statistics:Posted by karwan1986 — 13 Jun 2018 21:28

Data Import / Export • Re: Generating GraphML File

2018-06-13T11:19:53+01:00

You can try to use epanet2csv tool to convert to CSV and import as spreadsheet edges table in Gephi.

Statistics:Posted by eduramiba — 13 Jun 2018 11:19

Data Import / Export • Generating GraphML File

2018-06-13T11:08:36+01:00

Dear All

I have an Epanet Inp file. I need to generate GraphML File for that inp file, to configure it in Gephi. What would be the best an easy way to generate GraphML file please. Many thanks for any advice.

Reagrds
Karwan

Statistics:Posted by karwan1986 — 13 Jun 2018 11:08

Data Import / Export • Re: Creating a simple person to location network (with dates?)

2018-05-28T09:01:33+01:00

Hi,

The CSV/excel tutorials here should help you: https://seinecle.github.io/gephi-tutorials/

Statistics:Posted by eduramiba — 28 May 2018 09:01

Data Import / Export • Creating a simple person to location network (with dates?)

2018-05-25T17:01:34+01:00

Dear All,

I have a list of people and locations and would like to see how many of them are connected by having been in common locations. I've attached an image of my google sheet (obv not all information needs to be uploaded to Gephi.)

For those familiar, this is a back end for a GIS.

The next step would be to add the dates that each person was in a location to see any overlaps. However, that can wait.

How would I set up my csvs to create the basic network.

(And if anyone has any ideas about the dates, would love to hear how.

(Note: I am BRAND new at this so I need instructions to be as simple as possible. Thanks so much!)

Statistics:Posted by DHistorian — 25 May 2018 17:01

Data Import / Export • Re: Importing data from online forums

2018-05-11T10:21:28+01:00

You should use the exporting to CSV / excel capabilities of the form and then try to import that data as spreadsheet into Gephi.

Check some of the csv tutorials here https://seinecle.github.io/gephi-tutorials

Statistics:Posted by eduramiba — 11 May 2018 10:21

Data Import / Export • Importing data from online forums

2018-05-10T05:09:47+01:00

Hi everyone, I just downloaded gephi recently for a project and I was just wondering if it is possible to import data from another online forum. I'm not very tech savvy so please be kind!

Some background: I'm doing research for a class on online forums, and I'd like to see how connected the users in that forum are to each other (anonymously, I just want to see the patterns of the nodes). Is there a way I can import data from that site into gephi in order to see how the nodes are connected, or is this asking for too much? I'm not sure how to go about solving this problem in general so any advice about programs or anything is sincerely appreciated!

Statistics:Posted by pancake-fanatic — 10 May 2018 05:09

Data Import / Export • Re: Importing a Single Node Attribute

2018-05-04T15:53:07+01:00

It seems your id column was not deteted as the standard id column but a different one. Make sure characters in it are standard i and standard d in ascii and not others.

Anyway, your CSV works fine for me in Gephi 0.9.2 (and i is upper case instead of lower case, seems to be a different file).

Statistics:Posted by eduramiba — 04 May 2018 15:53

Data Import / Export • how to import adjacency file with node weights

2018-05-01T11:44:57+01:00

I have developed an adjacency file for co-authorship in the Research Centre. I would like the adjacency network to reflect the weights of the nodes. I developed the weights to reflect the number of papers the authors are involved in.
Please could someone take a look at the attachments and set them out to enable me to develop the Gephi piot? thank you.

Node Weights.csv

RESEARCHCenterCoauthor.csv

Statistics:Posted by Kwabena Takyi — 01 May 2018 11:44

Data Import / Export • Re: Importing edge data seems to clear label data for nodes

2018-05-01T10:01:49+01:00

Thank you - I had not noticed that the imports took me to separate workspaces. When checking the previous workspace I can see that the node data is all there.

Statistics:Posted by Thomas.Bourchier — 01 May 2018 10:01

Data Import / Export • Re: Importing edge data seems to clear label data for nodes

2018-04-30T10:57:41+01:00

Hi,

When you import the second file, make sure to merge it into the existing workspace, and not create a new one.

Statistics:Posted by eduramiba — 30 Apr 2018 10:57

Data Import / Export • Importing edge data seems to clear label data for nodes

2018-04-29T15:44:39+01:00

Hi,

Sorry but I am new to Gephi and so I might be misunderstanding how to import data. My plan is to create a project using the attached CSV files via 'Import Spreadsheet'. I import the node data first (from nodes.csv) and all seems well with no errors reported; in particular the data in the Label column is there okay. However when I then import the edge data (from edges.csv), the Label column for the node data is empty. Am I doing something fundamentally wrong here? I have spent quite a bit of time checking the documentation, checking the format of my files and looking at this forum and Google. I seem to be stuck so any help will be much appreciated. Do you see the same behaviour?

I am using Gephi 0.9.2 on Mac OS 10.13.4. I created my CSV files using Calc in LibreOffice 5.4.5.1.

Thank you.

Nodes.csv

Edges.csv

Statistics:Posted by Thomas.Bourchier — 29 Apr 2018 15:44

Data Import / Export • Re: Can't find structure to import data

2018-04-09T16:41:54+01:00

Many thanks for your help.

Statistics:Posted by cm4004 — 09 Apr 2018 16:41