根据一列的值和另一列中列表的长度对数据帧进行排序

Question

在数据帧中，例如：

Employee      list_of_children              child

Jonathen      ['John', 'Bob','Jennifer']    John

Jonathen      ['John', 'Bob','Jennifer']    Bob

Jonathen      ['John', 'Bob','Jennifer']    Jennifer

Emily         ['Clark']                     Clark

Hans          ['Watson', 'Hans Jr']         Watson

Hans          ['Watson', 'Hans Jr']         Watson

如何对上面的数据帧进行排序，使孩子最少的员工排在第一位

Employee      list_of_children              child

Emily         ['Clark']                     Clark

Hans          ['Watson', 'Monica']         Watson

Hans          ['Watson', 'Monica']         Monica

Jonathen      ['John', 'Bob','Jennifer']    John

Jonathen      ['John', 'Bob','Jennifer']    Bob

Jonathen      ['John', 'Bob','Jennifer']    Jennifer

Answer 1

我们可以在得到len之后使用argsort

df = df.iloc[df['list_of_children'].str.len().argsort()]