擅长:python、mysql、java
<p>字符串作为“对象”保存在熊猫中。您可以使用dataframe的info()方法来查看哪些列是整数、对象(对于字符串)、时间戳等:</p>
<pre><code>df.info()
</code></pre>
<p>对于您的问题,您可以使用apply方法并用所需的映射替换字符串,如下所示:</p>
<pre><code>def str_to_int_map(string, mapping):
return int(''.join([str(mapping.get(x, x)) for x in string]))
mapping = {"A": 1, "B": 2, "C": 3, "D": 4, "E": 5, "F": 6, "G": 7, "H": 8, "I": 9, "J": 10, "K": 11, "L": 12, "M": 13, "N": 14, "O": 15, "P": 16, "Q":17,"R":18, "S": 19, "T": 20,"U": 21, "V": 22, "W": 23, "X": 24, "Y": 25, "Z":26}
df['Course'] = df['Course'].apply(lambda x: str_to_int_map(x, mapping))
</code></pre>