Make NetworkX node attributes into Pandas Dataframe columns

Question

I have a Networkx graph called G created below:

import networkx as nx
G = nx.Graph()
G.add_node(1,job= 'teacher', boss = 'dee')
G.add_node(2,job= 'teacher', boss = 'foo')
G.add_node(3,job= 'admin', boss = 'dee')
G.add_node(4,job= 'admin', boss = 'lopez')

I would like to store the node number along with attributes, job and boss in separate columns of a pandas dataframe.

I have attempted to do this with the below code but it produces a dataframe with 2 columns, 1 with node number and one with all of the attributes:

graph = G.nodes(data = True)
import pandas as pd
df = pd.DataFrame(graph)

df
Out[19]: 
    0                                      1
0  1  {u'job': u'teacher', u'boss': u'dee'}
1  2  {u'job': u'teacher', u'boss': u'foo'}
2  3    {u'job': u'admin', u'boss': u'dee'}
3  4  {u'job': u'admin', u'boss': u'lopez'}

Note: I acknowledge that NetworkX has a to_pandas_dataframe function but it does not provide a dataframe with the output I am looking for.

Answer 1

Here's a one-liner.

pd.DataFrame.from_dict(dict(graph.nodes(data=True)), orient='index')