I have trying to select and colour selected groups of edges in my graph. To do this I have been trying to import edge attributes and filter by these. To do this I create a .csv with source, target and attribute columns for all edges in the network. When I import this using the Data Laboratory the attribute column appears but it is empty and for some reason the weights column in the Data Laboratory has increased uniform ally by one for all of the edges.
I have tried importing both strings and integers in the attribute column and the result is the same.
If you have a fix for this or an alternative solution I would love to hear it.
Selecting Multiple Edges
Re: Selecting Multiple Edges
Hi,
Can you post a sample of your csv so that we can have a look? It might be a simple spelling mistake in the header, for example.
Best,
Clement
Can you post a sample of your csv so that we can have a look? It might be a simple spelling mistake in the header, for example.
Best,
Clement
-
- Posts:3
- Joined:15 Apr 2014 17:10 [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
Re: Selecting Multiple Edges
Here are the first 10 lines of the .csv
Thanks
Oliver
Thanks
Oliver
- Attachments
-
- Example.csv
- (341Bytes)Downloaded 226 times
-
- Posts:68
- Joined:21 Jan 2012 18:34
- Location:Washington, DC, USA [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
Re: Selecting Multiple Edges
Hi obbila,
I've had some problems importing edge weights in CSV spreadsheets before. On import, some of the values in the "Weight" column would be changed slightly. For example, if all my edge weights were 1.0, most of the rows would have the value 1.0 in the "Weight" column, but other rows might have the value 3.0, 5.5, or 8.0. I didn't figure out what the problem was, though. I did figure out a workaround. I created another column in my spreadsheet called "Weight2" and those values, on import, never got garbled. So, when I imported a big spreadsheet into Gephi, I just used the "Copy data to another column" button and overwrote the values in "Weight" with the values in "Weight2".
I'm not sure that this is your problem, but I thought I'd float it by you anyway.
Good luck!
I've had some problems importing edge weights in CSV spreadsheets before. On import, some of the values in the "Weight" column would be changed slightly. For example, if all my edge weights were 1.0, most of the rows would have the value 1.0 in the "Weight" column, but other rows might have the value 3.0, 5.5, or 8.0. I didn't figure out what the problem was, though. I did figure out a workaround. I created another column in my spreadsheet called "Weight2" and those values, on import, never got garbled. So, when I imported a big spreadsheet into Gephi, I just used the "Copy data to another column" button and overwrote the values in "Weight" with the values in "Weight2".
I'm not sure that this is your problem, but I thought I'd float it by you anyway.
Good luck!
Re: Selecting Multiple Edges
Hi,
I could import the file without any problem (see screenshot). Did that by just importing the file through the datalab ("import spreadsheet"), without changing any parameter. The problem might lay in a line below in your file?
Best,
Clement
I could import the file without any problem (see screenshot). Did that by just importing the file through the datalab ("import spreadsheet"), without changing any parameter. The problem might lay in a line below in your file?
Best,
Clement
-
- Posts:3
- Joined:15 Apr 2014 17:10 [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
Re: Selecting Multiple Edges
Hi Clement
Sorry to be a bore but I still cannot work out what I am doing wrong. Here is a number of screenshots showing the settings I use to create the example network and then import the edge attribute spreadsheet. I get the same result as before. Would you be able to check my settings I have to make sure I have not accidentally changed any?
Here is what I do
1. Start Gephi.app and open a graph file the import settings I have for this are in the screenshot: After import the data laboratory looks like this in the edges tab: 2. In the Data laboratory I import the spreadsheet Example.csv (attached above). For the import the general options look like this: and the import settings look like this: 3. At the end of it this is how my data laboratory looks: Thanks
Sorry to be a bore but I still cannot work out what I am doing wrong. Here is a number of screenshots showing the settings I use to create the example network and then import the edge attribute spreadsheet. I get the same result as before. Would you be able to check my settings I have to make sure I have not accidentally changed any?
Here is what I do
1. Start Gephi.app and open a graph file the import settings I have for this are in the screenshot: After import the data laboratory looks like this in the edges tab: 2. In the Data laboratory I import the spreadsheet Example.csv (attached above). For the import the general options look like this: and the import settings look like this: 3. At the end of it this is how my data laboratory looks: Thanks