Python pandas part 6

2022 iThome 鐵人賽

DAY 25

AI & Data

了解Data Science系列第 25 篇

14th鐵人賽

jimmychi

團隊大腦已超載

2022-10-10 17:03:22

541 瀏覽

分享至

沿續上一篇dataframe
數據切割

print(employee_df.loc[:2, 'name':'email'])

自定義運算
把欄位一次取出做運算並產生一個新的值

employee_df.loc[(employee_df['salary']>  42000), 'salary_level'] = 'High'
employee_df.loc[(employee_df['salary']<=  42000) & (employee_df['salary']>=  40000), 'salary_level'] = 'normal'
employee_df.loc[(employee_df['salary']<  40000), 'salary_level'] = 'low'
print(employee_df)