Part of it was not setting root, but the topology is still too complex for Reingold-Tilford. Although, I guess without root, it should default. Setting root as follows:
import os
import igraph as ig
import pandas as pd
os.chdir("C:/Users/bizo2/Desktop")
df = pd.read_excel("edgelist3.xlsx")
g = ig.Graph.DataFrame(df)
visual_style = {}
visual_style["vertex_size"] = 30
visual_style["vertex_label"] = g.vs["name"]
layout = g.layout_reingold_tilford(mode="all", root=[3,6,10,14,18,22,26,30,33,36,40,43,46,49,52,55,58,62,65,69,72,76,79,81,85,89,93,97,100,103,107,110,114,117,120,123,126,129,132,135,139,142,145,147,151,154,157,160,164,167,171,175,179,183,186,190,193,197,201,205,208,211,214,217,221,224,227,230,234,237,240,244,248,252,255,259,262,265,268,272,275,278,281,284,287,291,295,298,302,306,309,313,317,321,324,327,331,334,338,342,345,348,351,354,357,361,365,369,373,376,380,384,387,391,394,397,401,405,409,412,416,419,422,426,430,433,437])
layout = g.layout("rt")
visual_style["layout"] = layout
visual_style["bbox"] = (50000,50000)
ig.plot(g, **visual_style)
gives
File "<stdin>", line 1, in <module>
File "C:\Users\bizo2\anaconda3\envs\myenv\lib\site-packages\igraph\__init__.py", line 1697, in layout
layout = method(self, *args, **kwds)
File "C:\Users\bizo2\anaconda3\envs\myenv\lib\site-packages\igraph\__init__.py", line 5122, in result
layout = func(*args, **kwds)
igraph._igraph.InternalError: Error at src/properties/dag.c:114: The graph has cycles; topological sorting is only possible in acyclic graphs. -- Invalid value
Can I force acyclic? With ‘mode=out’ or something?
cairo also seems to fail
File "<stdin>", line 1, in <module>
File "C:\Users\bizo2\anaconda3\envs\myenv\lib\site-packages\igraph\drawing\__init__.py", line 481, in plot
result = Plot(target, bbox, background=kwds.get("background", "white"))
File "C:\Users\bizo2\anaconda3\envs\myenv\lib\site-packages\igraph\drawing\__init__.py", line 144, in __init__
self._surface = cairo.ImageSurface(
cairo.Error: invalid value (typically too big) for the size of the input (surface, pattern, etc.)