title: Convert nanoseconds to days, hours, min and seconds
body: <p>I'm working in python with a pandas df and trying to convert a column that contains nanoseconds to a time with days, hours, minutes and seconds, but I'm not succeeding.</p>
  <p>My original df looks like this:</p>
  <pre><code>ID         TIME_NANOSECONDS     
  1          47905245000000000                       
  2          45018244000000000                       
  3          40182582000000000                     
  </code></pre>
  <p>The result should look like this:</p>
  <pre><code>ID         TIME_NANOSECONDS          TIME
  1          47905245000000000         554 days 11:00:45.000000000               
  2          45018244000000000         521 days 01:04:04.000000000 
  3          40182582000000000         465 days 01:49:42.000000000          
  </code></pre>
  <p>I've found some answers that advised to use timedelta, but following code, returns a date, which is not what I want.</p>
  <pre><code>temp_fc_col['TIME_TO_REPAIR_D'] = datetime.timedelta(temp_fc_col['TIME_TO_REPAIR'], unit='ns')
  </code></pre>
  <p>alternatively,</p>
  <pre><code>temp_fc_col['TIME_TO_REPAIR_D'] = (timedelta(microseconds=round(temp_fc_col['TIME_TO_REPAIR'], -3)
  </code></pre>
  <p>Returns an error: unsupported type for timedelta microseconds component: Series. Probably, because this staement can only process one value at a time.</p>