title: timestamp parsing
body: <p>I have a huge dataset and I am trying to parse timestamp column to have the following format:
  <code>YYYY-MM-DD HH:MM:SS:DEC</code> but the output I have in the dataframe have something like: <code>210309_131046520_11</code>.</p>
  <p>Hence: I want to split the output column to have the following column:</p>
  <pre><code>date,  day,  month,  year, dec,  hh,  mm, ss
  </code></pre>
  <p>eg: <code>210309_131046520_11</code></p>
  <p><code>date</code> 21-03-09<br />
  <code>day</code> 09<br />
  <code>month</code> 03<br />
  <code>year</code> 2021<br />
  <code>dec</code> 520<br />
  <code>hh</code> 13<br />
  <code>mm</code> 10<br />
  <code>ss</code> 46<br /></p>
  <p>I tried to use <code>datetime</code> modules but nothing seems to be helpful. Can someone help?</p>
  <p>Example of my timestamp column:</p>
  <pre><code>0      210309_131046520_11.sgy
  1      210309_131046520_05.sgy
  2      210309_131046528_02.sgy
  3      210309_131046528_12.sgy
  4      210309_131049712_07.sgy
  ...
  162    210309_132658584_07.sgy
  163    210309_132659632_10.sgy
  164    210309_132701232_05.sgy
  165    210309_132704256_02.sgy
  166    210309_132707136_12.sgy
  </code></pre>
  <p>Example of my date column:</p>
  <pre><code>0      131046520
  1      131046520
  2      131046528
  3      131046528
  4      131049712
  ...
  162    132658584
  163    132659632
  164    132701232
  165    132704256
  166    132707136
  </code></pre>
  <p>One thing I attempted:</p>
  <p>Using <code>split</code>:</p>
  <pre><code>s_df[&quot;date&quot;] = s_df[&quot;timestamp&quot;].apply(lambda row: row.split(&quot;_&quot;)[1])
  </code></pre>
  <p>Output:</p>
  <pre><code>TypeError: list indices must be integers or slices, not str
  </code></pre>