title: Split and sort value in dataframe
body: <p>I have a raw data dataframe for example:</p>
  <pre><code>      Data
  0   XZ_1A-2A
  1   XZ_3C
  2   XZ_4B-5A
  3   XZ_18A-20C
  </code></pre>
  <p>And I want to split (and delete <code>XZ_</code>) it to be</p>
  <pre><code>      Data        T1      T2
  0   XZ_1A-2A      1A      2A
  1   XZ_3C         3C
  2   XZ_4B-5A      4B      5A
  3   XZ_18A-20C   18A     20C
  </code></pre>
  <p>Then sort by number</p>
  <pre><code>       T1      T2
  0      2A      1A
  1      3C
  2      5A      4B
  3     20C     18A     
  </code></pre>
  <p>Thanks for your help.</p>
  <hr />
  <h3>[fixed]</h3>
  <p>Update_1:<br />
  When input data:</p>
  <pre><code>      Data
  0   XZ_17A-1A
  1   XZ_5C
  2   XZ_3A-28A
  </code></pre>
  <p>and compile with</p>
  <pre><code>df= (df['Data'].str.split('_|-',expand=True)[[1,2]]).rename(columns={1:'T2',2:'T1'}).fillna('')
  asc=pd.DataFrame(np.sort(df[['T1','T2']],axis=1)) 
  des= asc[asc.columns.values[::-1]]
  </code></pre>
  <p>I got the output</p>
  <pre><code>     1    0
  0   1A  17A
  1   5C  
  2   3A  28A 
  </code></pre>
  <hr />
  <p>Update_2:<br />
  If there are more than 2 items (about 1~5) in simgle row, how to sort it?</p>
  <pre><code>       Data
  0   XZ_17A-1A
  1   XZ_5C
  2   XZ_3A-28A
  3   XZ_5A-19A-42C   
  4   XZ_3A-28A-41A-42A
  </code></pre>