/Python/Convert all date columns using pd.datetime

Convert all date columns using pd.datetime

def lookup(s):
    """
    This is an extremely fast approach to datetime parsing.
    For large data, the same dates are often repeated. Rather than
    re-parse these, we store all unique dates, parse them, and
    use a lookup to convert all dates.
    """
    dates = {date:pd.to_datetime(date) for date in s.unique()}
    return s.apply(lambda v: dates[v])

to_datetime: 5799 ms
dateutil:    5162 ms
strptime:    1651 ms
manual:       242 ms
lookup:        32 ms

Source: stackoverflow.com

Similar codes

15 votes64 views5 answers
Pandas profiling
Python
1 vote82 views1 answer
Np install python
Python
0 vote72 views1 answer
Selenium open inspect
Python
1 vote63 views1 answer
Python auto reload module ipython
Python
0 vote82 views1 answer
KeyError: 'ProfilePage'
Python
0 vote67 views1 answer
Negative indexing in Python
Python
0 vote68 views1 answer
Django changing boolean field from view
Python
0 vote60 views1 answer
Featch detail of subscription in stripe api
Python
51 votes99 views6 answers
Pandas reorder columns
Python
0 vote79 views1 answer
K means image classification
Python