Hi,

these two commands might help:

data = Import["~/Desktop/VEtest.xlsx"]

Graph[Table[Property[data[[1]][[i, 2]], VertexSize -> 0.1*data[[1]][[i, 1]]], {i, 1, Length[data[[1]]]}], 
 Table[data[[2]][[i, 1]] \[UndirectedEdge] data[[2]][[i, 2]], {i, 1, Length[data[[2]]]}]]

They give something like this:

The standard graph measures should work:

 g = Graph[Table[Property[data[[1]][[i, 2]], VertexSize -> 0.1*data[[1]][[i, 1]]], {i, 1, Length[data[[1]]]}],
    Table[data[[2]][[i, 1]] \[UndirectedEdge] data[[2]][[i, 2]], {i, 1, Length[data[[2]]]}]];

GraphDiameter[g]

which gives 4.

Cheers, Marco

Tá fáilte romhat!

Interesting by the way that the Wolfram Cloud thinks that this is English:

Classify["Language","Go raibh maith agat!"]

gives:

 Entity[Language, English]

Here in Aberdeen they speak Doric and "you are welcome" would be:

"nae bather"

(no bother) which the machine learning in the Cloud also believes to be English. I suppose that it isn't trained on Irish or Doric and Scots texts.

Cheers, Marco