Python3.x 按长度和字母数字对Pandas 数据帧列进行排序

我希望我没弄错你的问题.您可以try :

lst = [
    10,
    100110,
    222754430,
    777000,
    "TEST10",
    800022110,
    210,
    1960,
    30,
    "TERM20",
    22100,
    22300,
    487854750,
    "TEST20",
    2200010,
    220,
    20,
    22200,
    1100,
    2200020,
]


def key_fn(val):
    if isinstance(val, str):
        return len(val), False, val
    else:
        s = str(val)
        return len(s), True, s

output = sorted(lst, key=key_fn)
print(output)

打印:

[
    10,
    20,
    30,
    210,
    220,
    1100,
    1960,
    22100,
    22200,
    22300,
    "TERM20",
    "TEST10",
    "TEST20",
    100110,
    777000,
    2200010,
    2200020,
    222754430,
    487854750,
    800022110,
]

编辑:要将其应用于框架，您可以执行以下操作:

def key_fn(series):
    def __to_int(val):
        try:
            return int(val)
        except:
            return val

    def __inner(val):
        val = __to_int(val)

        if isinstance(val, str):
            return len(val), False, val
        else:
            s = str(val)
            return len(s), True, s

    return pd.Series([__inner(val) for val in series], index=series.index)


df = df.sort_values(by=["column1"], key=key_fn)
print(df)

打印:

      column1
0          10
16         20
8          30
6         210
15        220
18       1100
7        1960
10      22100
17      22200
11      22300
9      TERM20
4      TEST10
13     TEST20
1      100110
3      777000
14    2200010
19    2200020
2   222754430
12  487854750
5   800022110