RE: [cytoscape-helpdesk] cytoscape and exel

[Barry Demchak]

Luis –

 

It sounds like you’re pretty close. Can you send your Excel file (or a part of it) and let me have a look?

 

Thanks.

 

From: cytoscape...@googlegroups.com [mailto:cytoscape...@googlegroups.com] On Behalf Of luis arantes
Sent: Wednesday, April 06, 2016 7:18 AM
To: cytoscape-helpdesk
Subject: [cytoscape-helpdesk] cytoscape and exel

 

hi,

i'm a football coach and i am trying to use cytoscape to sports analysis. i want to creat a file to view how many passes player Amake to player B, C , D and so one. I'am sending this message because i can not input a exel file, i am seeing tutorials but i do not understand yet how to do it. My exel file only have a table with the source, the edge (thats pass), and a desteny. Can you tell me if that something wrong with my exel file or i am just doing everything wrong?

 

Beste regards and thanks for help.

--
You received this message because you are subscribed to the Google Groups "cytoscape-helpdesk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpd...@googlegroups.com.
To post to this group, send email to cytoscape...@googlegroups.com.
Visit this group at https://groups.google.com/group/cytoscape-helpdesk.
For more options, visit https://groups.google.com/d/optout.

[luis arantes]

[luis arantes]

this is my exel file table

[luis arantes]

[luis arantes]

this is my exel file table.

[luis arantes]

exel file table

[luis arantes]

Sorry, the original exel file from the guy who try to teach me this has another  table, one of them where we insert passes from who to who. i don't know if this is important or not. 

Thank you

[Barry Demchak]

Luis –

 

Your spreadsheet file has three sheets in it … the first one is artful, but cannot be understood by Cytoscape.

 

To make this easier, I extracted the second sheet into its own spreadsheet file and imported that instead. It worked fine.

 

Additionally, I used “origem” as the source, “destino” as the destination, and used the Advanced tab to define the edge interaction as “passe”. I think this reflects the structure you’re trying to achieve.

 

Finally, I allowed your “passe” column to be imported as an edge attribute.

 

The resulting network is attached.

 

I think you might then use the Styles tab to make edges thicker when the edge’s “passe” column is higher. I’ll leave the styling to you, though.

 

This technique would apply to the third sheet in your file, too … I’ll leave that to you if you’re interested.

 

Best of luck!

 

 

From: cytoscape...@googlegroups.com [mailto:cytoscape...@googlegroups.com] On Behalf Of luis arantes

Sent: Wednesday, April 06, 2016 7:27 AM
To: cytoscape-helpdesk

--