title: Convert HH:MM:SS and MM:SS to seconds in same column in Pandas
body: <p>I am trying to convert a timestamp string into an integer and having trouble.</p>
  <p>The column in my dataframe looks like this:</p>
  <pre class="lang-none prettyprint-override"><code>time
  30:03
  1:15:02
  </code></pre>
  <p>I have tried <code>df['time'].str.split(':').apply(lambda x: int(x[0]) * 60 + int(x[1]))</code> but that only works if every value in the column is HH:MM:SS but my column is mixed. Some people took 30 minutes to finish the task and some took an hour, etc.</p>