/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

0 vote225 views1 answer
Filter field set in django formds
Python Django
3 votes193 views2 answers
Np argmin top n
Python
8 votes178 views1 answer
Positive lookahead regex python
Python
6 votes188 views4 answers
Flask get with parameters
Python
1 vote242 views1 answer
Flask get value of radio button
Python Flask
0 vote214 views2 answers
Run matlab code in python
Python
0 vote194 views1 answer
How to make bak files with python
Python
1 vote228 views1 answer
Django template tags capitalize
Python Django
0 vote177 views1 answer
?: (admin.W411) 'django.template.context_processors.request' must be enabled in DjangoTemplates (TEMPLATES) in order to use the admin navigation sidebar.
Python
0 vote170 views1 answer
All objects and constants needed to use the ldap3 library can be imported from the ldap3 namespace
Python