title: splitting column value in to three with two delimiter in pandas
body: <p>I have written an excel file with one column with values of:</p>
  <pre><code>col1
  22125051|2/136|Possible Match
  nan|3/4|Not Match
  22125051|1/26|Match
  </code></pre>
  <p>these data are initially in different columns but I want to get the value of the said columns and put the data into one, and I did it by using .apply() and .join() then I added a delimiter | to separate the values</p>
  <p>now I want to split the column per value then put it in to specific column in an existing .xlsx file.
  say <code>df3 = pd.read_excel('type_primary_data.xlsx')</code>
  and .columns[37], .columns[39], .columns[40]</p>
  <h2>Desired ouput</h2>
  <pre><code>svc_no       port      Result
  
  22125051     2/136     Possible Match
  nan          3/4       Not Match
  22125051     1/26      Match
  </code></pre>
  <p>I am not sure what is the best way to do this in pandas.</p>
  <h1>UPDATE</h1>
  <p>turns out that I need to match the adsl column to an existing .xlsx file
  so, as the adsl matched with the said column I also wanted to get the svc_no and comparison result along with the matched adsl.</p>
  <h3>my ouput should be</h3>
  <pre><code>adsl         svc_no       port      Result
  3/4          nan          3/4       Not Match
  1/26         22125051     1/26      Match
  2/136        22125051     2/136     Possible Match
  </code></pre>