<p>程序试图比较中的每一行中的值学生.csv与导师.csv. 但是,我从您需要的理解是加入StaffCode列上的两个数据集。因此,常规的csv读写可能很难做到,我建议使用熊猫,这将有助于。这是密码。</p>
<pre><code>import pandas as pd
stu = pd.read_csv('./data/students.csv')
tutors = pd.read_csv('./data/tutors.csv')
stu.head()
Out[19]:
RegGroup
0 XXFLI
1 XXRTH
2 XXPOD
3 XXDFI
4 XXLNO
tutors.head() # i added a column as 'Staff Name' for fun
Out[20]:
StaffCode Staff Name
0 FLI Fly Li
1 RTH Ruth G
2 POD Podrick
3 DFI Daren Fli
4 LNO Lenord
# extract the last three characters as 'StaffCode'
stu['StaffCode'] = stu.apply(lambda row: row['RegGroup'][-3:], axis=1)
stu.head()
Out[22]:
RegGroup StaffCode
0 XXFLI FLI
1 XXRTH RTH
2 XXPOD POD
3 XXDFI DFI
4 XXLNO LNO
stu_new = pd.merge(stu, tutors, how='left', on=['StaffCode']) # merge it on the StaffCode column and do some cool stuff
stu_new.head()
Out[24]:
RegGroup StaffCode Staff Name
0 XXFLI FLI Fly Li
1 XXRTH RTH Ruth G
2 XXPOD POD Podrick
3 XXDFI DFI Daren Fli
4 XXLNO LNO Lenord
</code></pre>
<p>只是代码</p>
^{pr2}$