熊猫拆分成多列

import pandas as pd

# 创建一个示例数据表格
data = {'City': ['Beijing', 'Shanghai', 'Guangzhou', 'Chengdu'],
        'Population': [21540000, 24240000, 14040000, 16040000]}
df = pd.DataFrame(data)

# 根据人口数量将城市拆分为高人口城市和低人口城市
df['Population_Category'] = pd.cut(df['Population'], bins=[0, 20000000, df['Population'].max()], 
                                   labels=['Low Population', 'High Population'])

# 输出拆分结果
print(df)

        City  Population Population_Category
0    Beijing    21540000    High Population
1   Shanghai    24240000    High Population
2  Guangzhou    14040000     Low Population
3    Chengdu    16040000     Low Population