对两列进行排序，并使用pandas为来自dataframe的排序值创建新列

import pandas as pd

data = {'列1': [value1, value2, value3, ...],
        '列2': [value1, value2, value3, ...]}
df = pd.DataFrame(data)

df_sorted = df.sort_values(by=['列1', '列2'], ascending=[True, False])

df_sorted['排序值'] = range(1, len(df_sorted) + 1)

import pandas as pd

data = {'列1': [value1, value2, value3, ...],
        '列2': [value1, value2, value3, ...]}
df = pd.DataFrame(data)

df_sorted = df.sort_values(by=['列1', '列2'], ascending=[True, False])
df_sorted['排序值'] = range(1, len(df_sorted) + 1)