擅长:python、mysql、java
<p>你能做到的</p>
<pre><code>def select(row):
keystring = 'dep_'+str(row['dep'])
result = []
for one in row['data']:
if (one!=keystring)&('dep' in one):
result.append(one)
return result
df['data'] =df.apply(lambda x:select(x),axis=1)
df['datalength'] = df['data'].map(lambda x:len(x))
result = df[df['datalength']>0][df.columns[:3]]
print(result)
user data dep
1 2 [the_dep_45, 34_dep] 45
2 3 [dep_89] 91
</code></pre>