Pandas Dataframe - 使用基于3个独立条件的部分字符串合并数据集

I am trying to left join two data sets based on a four digit code in each. One data set has the codes filled in to varying degrees (2,3, or all 4 digits) with trailing zeroes as needed. I am trying to left join two data sets based on