擅长:python、mysql、java
<pre><code>import pandas as pd
row =[['abcx','abcy'],
['efg','abcz'],
['higj','UK']]
df= pd.DataFrame(row)
df.columns = ['c_name', 'f_name']
print df[df['c_name'].str.contains('abc', case=False)]
delta_df =df[~df['c_name'].str.contains('abc', case=False)]
print delta_df[delta_df['f_name'].str.contains('abc', case=False)]
</code></pre>
<p>输出</p>
^{pr2}$