Could use some HELP

[S. J]

Would anyone be willing to help me?

I am trying to set up a NETWORK for  ARTIST that sampled other ARTIST

I have combed my data through www.the-breaks.com,  yes, the data is not perfect.

I more or less would like to know if my data is at least on the right track to put in CYTOSCAPE. 

Any thoughts or ideas are appreciated.

I am using Tab-delimited data to put into EXEL.

I will post a screen of the data.  and or will attach file if anyone cares to look at my DATA

[Lucas Wall]

S.J.

Cytoscape needs a column called Source and another called Target to create the edges of a network.

Go with a simple example first, then add more of your data to it until you get the full dataset into it.

My two cents.

Lucas

Lucas E. Wall CEO & Founder tablelead 571-308-8764

------------------------------------------ 

Confidentiality. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

ᐧ

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/cytoscape-helpdesk/09d22068-6cbf-471a-a8f3-af534e6933cf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Alex Pico]

Hi SJ,

Lucas is exactly right. In fact, it’s good practice in making any data table to have clearly defined rows and columns (not just for Cytoscape). And the spreadsheet you have so far breaks some of these “best practices”, making it no so useful for any sort of analysis.  

Visually, your table makes sense of course, but that’s only because the human reader can interpret your spacing and knows something already about the domain and meaning of the entries.  An analytical tool doesn’t have this prior context and creativity.

Some basic suggestions:

 1. Each column should contain a single, consistent type of data (e.g., strings, numbers, booleans, or lists of these). Your current table follows this pretty well already (expect for all the spaces… see #2).

 2. Each row should contain the same pattern of information. Sure there might be different values or even missing values, but all rows should effectively be defined the same and independent from other rows. Your current table, for example, is structured list an indented list, which again is human-readable, but analytical tools won’t “know” which rows are nested into other rows. And even if they did, most tools wouldn’t know how to handle this.

Deciding how to structure your table depends on how you want to use the data. Here’s an example assuming you want to connected nodes of artists  using your same data.  I’m using A to refer to the original and B to the version with sample

ArtistA  |  ArtistB  |  AlbumA  |  SongA  |  SongB  | GenreB    <—(Note: I don’t see AlbumB in your table; I’m assuming Genre is for the sample)

——————————————————————————————————————

A Taste of Honey  |  Souls of Mischief  |  A Taste of Honey: (Capitol 1978)  |  You  |  Airborne Rangers  |  R&B

A Taste of Honey  |  Ice Cube  |  A Taste of Honey: (Capitol 1978)  |  Distant  |  Gangsta’s Fairy Tale 2  |  R&B

A Taste of Honey  |  Brooke Valentine  |  A Taste of Honey: (Capitol 1978)  |  Boogie Oogie Oogie  |  Boogie Oogie Oogie  |  R&B

A Taste of Honey  |  Fabolous  |  A Taste of Honey: (Capitol 1978)  |  Boogie Oogie Oogie  |  Boogie Oogie Oogie  |  R&B

A Taste of Honey  |  Yo-Yo  |  A Taste of Honey: (Capitol 1978)  |  Boogie Oogie Oogie  |  Boogie Oogie Oogie  |  R&B

A Taste of Honey  |  Bob Sinclair  |  A Taste of Honey: (Capitol 1978)  |  Boogie Oogie Oogie  |  My Only Love  |  R&B

Yes, there is a lot more redundancy, but each row can be interpreted by tools clearly and independently. This table could directly be imported into Cytoscape, for example, via the Network Import from File option, where the first two columns are source and target, and the other columns are all edge attributes.

 - Alex

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/cytoscape-helpdesk/09d22068-6cbf-471a-a8f3-af534e6933cf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

<network_node.PNG><edge.PNG>