update用法:用一个dataframe更新另一个dataframe
import pandas as pd
data1 = {'Code': [1, 2, 3],
'Name': ['Company1', 'Company2', 'Company3'],
'Value': [200, 300, 400]}
df1 = pd.DataFrame(data1)
df1
| Code | Name | Value |
---|
0 | 1 | Company1 | 200 |
1 | 2 | Company2 | 300 |
2 | 3 | Company3 | 400 |
data2 = {'Code': [2], 'Name': ['Company2'], 'Value': [1000]}
df2 = pd.DataFrame(data2)
df2
| Code | Name | Value |
---|
0 | 2 | Company2 | 1000 |
update 函数是以index去匹配的,所以先把要匹配的字段转成index
df1.set_index(['Code','Name'], inplace=True)
df1
| | Value |
---|
Code | Name | |
1 | Company1 | 200 |
2 | Company2 | 300 |
3 | Company3 | 400 |
df2.set_index(['Code','Name'], inplace=True)
df2
| | Value |
---|
Code | Name | |
2 | Company2 | 1000 |
直接更新
df1.update(df2)
df1
| | Value |
---|
Code | Name | |
1 | Company1 | 200 |
2 | Company2 | 1000 |
3 | Company3 | 400 |
可以将index再转成列
df1 = df1.reset_index()
df1
| Code | Name | Value |
---|
0 | 1 | Company1 | 200 |
1 | 2 | Company2 | 1000 |
2 | 3 | Company3 | 400 |