按一列的子字符串对Pandas Dataframe进行排序 [英] Sort Pandas Dataframe by substrings of a column

问题描述

给出一个数据框:

    name             email
0   Carl    [e-mail]
1    Bob     [e-mail]
2  Alice   [e-mail]
3  David  [e-mail]
4    Eve     [e-mail]

如何根据电子邮件的域名(按字母顺序，升序)对邮件进行排序，然后在每个域组中根据"@"之前的字符串对邮件进行排序?

How can it be sorted according to the email's domain name (alphabetically, ascending), and then, within each domain group, according to the string before the "@"?

对以上内容进行排序的结果应为:

The result of sorting the above should then be:

    name             email
0    Bob     [e-mail]
1    Eve     [e-mail]
2  David  [e-mail]
3  Alice   [e-mail]
4   Carl    [e-mail]

推荐答案

选项1
sorted + reindex

Option 1
sorted + reindex

df = df.set_index('email')
df.reindex(sorted(df.index, key=lambda x: x.split('@')[::-1])).reset_index()

              email   name
0     [e-mail]    Bob
1     [e-mail]    Eve
2  [e-mail]  David
3   [e-mail]  Alice
4    [e-mail]   Carl

---

选项2
sorted + pd.DataFrame
或者，您可以通过重新创建新的DataFrame来放弃选项1中的reindex调用.

---

Option 2
sorted + pd.DataFrame
As an alternative, you can ditch the reindex call from Option 1 by re-creating a new DataFrame.

pd.DataFrame(
    sorted(df.values, key=lambda x: x[1].split('@')[::-1]), 
    columns=df.columns
)

    name             email
0    Bob     [e-mail]
1    Eve     [e-mail]
2  David  [e-mail]
3  Alice   [e-mail]
4   Carl    [e-mail]

这篇关于按一列的子字符串对Pandas Dataframe进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！