擅长:python、mysql、java
<p>您可以使用<code>Pandas</code>并使用<code>age</code>数据更新{<cd2>}。通过将两个数据帧的索引分别设置为<code>ID</code>和{<cd5>},然后更新{<cd2>}中的age列。之后,重新设置索引,使<code>ID</code>再次成为列。在</p>
<pre><code>from StringIO import StringIO
import pandas as pd
info = StringIO("""Last Name,First Name,ID,phone,adress,age X [Total age: 100] |009076
abc, xyz, 1234, 982-128-0000, pqt,
bcd, uvw, 3124, 813-222-1111, tre,
poi, ccc, 9087, 123-45607890, weq,""")
age = StringIO("""student_id,age_1
3124,20
9087,21
1234,45""")
info_df = pd.read_csv(info, sep=",", engine='python')
age_df = pd.read_csv(age, sep=",", engine='python')
info_df = info_df.set_index('ID')
age_df = age_df.set_index('student_id')
info_df['age X [Total age: 100] |009076'].update(age_df.age_1)
info_df.reset_index(level=0, inplace=True)
info_df
</code></pre>
<p>输出:</p>
^{pr2}$