带有dict值的Pandas分组依据

import pandas as pd

# 创建一个示例DataFrame
data = {'Name': ['Alice', 'Bob', 'Charlie', 'David', 'Eve'],
        'Age': [25, 30, 35, 40, 45],
        'City': ['New York', 'London', 'Paris', 'Tokyo', 'Sydney'],
        'Salary': [5000, 6000, 7000, 8000, 9000]}
df = pd.DataFrame(data)

# 创建一个字典作为分组依据
group_dict = {'New York': 'USA', 'London': 'UK', 'Paris': 'France', 'Tokyo': 'Japan', 'Sydney': 'Australia'}

# 使用字典进行分组
grouped = df.groupby(group_dict)

# 打印每个分组的内容
for group, data in grouped:
    print("Group:", group)
    print(data)
    print()

# 输出结果：
# Group: Australia
#   Name  Age    City  Salary
# 4  Eve   45  Sydney    9000
#
# Group: France
#       Name  Age   City  Salary
# 2  Charlie   35  Paris    7000
#
# Group: Japan
#    Name  Age   City  Salary
# 3  David   40  Tokyo    8000
#
# Group: UK
#   Name  Age    City  Salary
# 1   Bob   30  London    6000
#
# Group: USA
#    Name  Age      City  Salary
# 0  Alice   25  New York    5000