原有資料
| Region | Country | Reach | Headline | Source |
| NALA | LATAM | 12345 | ABC | aaa |
| NALA | LATAM | 12345 | ABC | aaa |
| NALA | LATAM | 12345 | ABC | aaa |
| NALA | LATAM | 12345 | ABC | aaa |
| NALA | LATAM | 12000 | CCC | aaa |
| NALA | LATAM | 12000 | CCC | aaa |
最終篩選資料
| Region | Country | Reach | Headline | Source |
| NALA | LATAM | 12345 | ABC | aaa |
| NALA | LATAM | 12000 | CCC | aaa |
目前我卡關地方是: 篩選條件
import pandas as pd
test = pd.read_excel('文件擺放位置.xlsx')
print(test)
tt = test.drop_duplicates()
print(tt)
tt.to_excel("匯出存放位置.xlsx",index=None,encoding="utf-8")
請再麻煩各位大師幫忙指引了
謝謝
import pandas as pd
test = pd.read_excel('文件擺放位置.xlsx')
print(test)
tt = test.drop_duplicates(subset=['Reach','Source'])
print(tt)
tt.to_excel("匯出存放位置.xlsx",index=None,encoding="utf-8")