按名称排序并在Dataframe中联接

import pandas as pd

# 创建一个示例数据框
data = {'名称': ['A', 'B', 'C', 'D'],
        '数值': [1, 2, 3, 4]}
df = pd.DataFrame(data)

# 按名称排序
df_sorted = df.sort_values(by='名称')

print(df_sorted)

  名称  数值
0  A   1
1  B   2
2  C   3
3  D   4

import pandas as pd

# 创建示例数据框
data1 = {'名称': ['A', 'B', 'C', 'D'],
         '数值1': [1, 2, 3, 4]}
df1 = pd.DataFrame(data1)

data2 = {'名称': ['A', 'B', 'C', 'D'],
         '数值2': [5, 6, 7, 8]}
df2 = pd.DataFrame(data2)

# 数据框联接
df_merged = pd.merge(df1, df2, on='名称')

print(df_merged)

  名称  数值1  数值2
0  A    1    5
1  B    2    6
2  C    3    7
3  D    4    8