Looks like an Excel datetime format, called serial date. Quick and dirty way to convert it:
>>> import datetime
>>> serial = 43111.0
>>> seconds = (serial - 25569) * 86400.0
>>> datetime.datetime.utcfromtimestamp(seconds)
datetime.datetime(2018, 1, 11, 0, 0)
More Related Contents:
- Converting datetime.date to UTC timestamp in Python
- Format timedelta to string
- How to convert local time string to UTC?
- Filtering Pandas DataFrames on dates
- Converting string with UTC offset to a datetime object [duplicate]
- Trying to mock datetime.date.today(), but not working
- Most recent previous business day in Python
- type object ‘datetime.datetime’ has no attribute ‘datetime’
- How to change the datetime tick label frequency for matplotlib plots
- python – datetime with timezone to epoch
- Python speed testing – Time Difference – milliseconds
- What exactly does the T and Z mean in timestamp?
- Comparing two date strings in Python
- Difference between Python datetime vs time modules
- Natural/Relative days in Python
- Why can’t I subclass datetime.date?
- Extract time from datetime and determine if time (not date) falls within range?
- Convert string “Jun 1 2005 1:33PM” into datetime
- Python time to age, part 2: timezones [duplicate]
- Python pandas convert datetime to timestamp effectively through dt accessor
- Which is the fastest way to extract day, month and year from a given date?
- Format of datetime in pyplot axis
- Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
- How to convert Python’s .isoformat() string back into datetime object [duplicate]
- Why does “%-d”, or “%-e” remove the leading space or zero?
- Python summing up time
- Ceil a datetime to next quarter of an hour
- Clean way to convert quarterly periods to datetime in pandas
- pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
- Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13