python代替vlookup_用字典替换熊猫中的VLookup（然后替换）？

我想用字典替换Pandas数据帧中的值

DataFrame=games-u-q-s.csv：blue1 blue2 blue3 blue4 blue5 red1 red2 red3 red4 red5 winner

8 432 96 11 112 104 498 122 238 412 0

119 39 76 10 35 54 25 120 157 92 0

57 63 29 61 36 90 19 412 92 22 0

第1-10列包含champId，其中winner列作为标签

字典=冠军.csv在

^{pr2}$

并将其另存为dataset_feature_champion_number.csv

我想将champId转换为champNum，并将预期输出如下：blue1 blue2 blue3 blue4 blue5 red1 red2 red3 red4 red5 winner

125 11 59 70 124 36 129 20 135 111 0

23 40 77 53 95 67 73 37 132 91 0

69 13 116 81 22 68 127 111 91 8 0

代码如下：import csv

import os

import numpy as np

import pandas as pd

def createDictionary(csvfile):

with open(csvfile, mode='r') as data:

reader = csv.reader(data)

dict = {int(rows[0]):int(rows[1]) for rows in reader}