Hackers and Slackers: Data Science for Badasses
Author image

Matthew Alhonte

103 Posts
Super villain in somebody's action hero movie. Snkia experienced a radioactive freak accident at a young age which rendered him part-snake and strangely adept at python.

Importing Excel Datetimes Into Pandas

Pandas & Excel, Part 1

Different file formats are different!  For all kinds of reasons!

A few months back, I had to import some Excel files into a database. In this process I learned so much about the delightfully unique way Excel stores dates & times!  

The basic datetime will be a decimal number, like 43324.909907407404.  The number before the decimal is the day, the number afterwards is the time.  So far, so good - this is pretty common for computers.  The date is

Pandas Author imageMatthew Alhonte August 13