python-3.x - 如何使用 Python 使用与其他数据框不同的单元格值在数据框中创建新列

Question

考虑以下数据框：

d = {'采购文件':[33772149,33773956,33774567,33775678,33776890],'项目':['G-019014PD5','G-019014PD5','G-019014PD5','G-019014PD5',' G-019014PD5'], '订单日期':['2017-01-10','2017-04-10','2017-06-10','2018-03-10','2018-051-10 '], 'GR 日期':['2017-01-10','2017-05-10','2017-09-10','2018-04-10','2018-07-10'], '工作包'：[1238419,1345678,14567856,1367858,1256987]，
'材料'：[70440,70456,70869,70657,70440]，'GIC'：[7331,7334,7326,7326,7331]，'值':[20380.80,1345678.70,45678.90,23456.87,65780.85],'货币':['BRL','COP','CLF','PEN','USD'],'GR 月':[1,5,9,4,7], 'GR 年':[2017,2017,2017,2018,2018]}

E2E=pd.DataFrame(data=d,index=[0,1,2,3,4])

f = {'类型':[2017,2017,2017,2017,2017,2018,2018,2018,2018,2018],'货币':['BRL','CLF','COP','PEN', 'USD','BRL','CLF','COP','PEN','USD'],'1':[4.4052,85.5316,1324.95,580.46,1.234,4.6052,85.7316,1356.95,582.46,1.234] ，'2'：[4.4052,85.5316,1324.95,580.46,1.234,4.6052,85.7316,1356,1356.95,582.46,1.234] 1.234]，'4'：[4.4052,85.5316,1324.95,580.46,1.234,4.6052,85.7316,1356,1356.95,582.46,1.46,1.234] 582.46,1.234]，'6'：[4.4052,85.5316,1324.95,580.46,1.46,1.234,4.6052,85.7316,1356,1356.95,95,582.46,1.46,1.234]1356.95,582.46,1.234]，'8'：[4.4052,85.5316,1324.95,580.46,1.46,1.234,4.6052,85.7316,1356,1356.95,95,95,582.46,1.46,1.46,1.234] 85.7316,1356.95,582.46,1.234]，'10'：[4.4052,85.5316,1324.95,580.46,1.46,1.234,4.6052,85.7316,1316,1316,1356.956.956.956.955,582.46.46.46.46.46.46.46.46，1.46.46.46.46 ,，11.46.46.46.46.46,1.46,1.46,1.46.46.46 ,，11.1.44,1.46.46.46.46.46 ,，11.46.46.46.46.46,1.46.46.bout。 4.6052,85.7316,1356.95,582.46,1.234],'12':[4.4052,85.5316,1324.95,580.46,1.234,4.6052,85.7316,1356.95,582.46,1.234]}95,582.46,1.234], '12':[4.4052,85.5316,1324.95,580.46,1.234,4.6052,85.7316,1356.95,582.46,1.234]}95,582.46,1.234], '12':[4.4052,85.5316,1324.95,580.46,1.234,4.6052,85.7316,1356.95,582.46,1.234]}

数据=pd.DataFrame(数据=f)

我需要在 E2E 中创建一个新列，在DatawhereData['Type] = E2E['GR Year] and Data['Currency']=E2E['Currency]和Data column = E2E ['GR Month'].

我已经尝试了许多不同的方法，但都没有成功。你能告诉我如何实现这一目标吗？

标签： python-3.xjupyter-notebook