/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

1 vote210 views1 answer
Python custom class indexing
Python
0 vote198 views1 answer
Django http response 204
Python
-1 vote178 views1 answer
Check runtime python
Python
9 votes179 views2 answers
How to install packages inside thepython script
Python
0 vote180 views1 answer
Python types generator
Python
3 votes197 views1 answer
Np append row
Python
0 vote306 views1 answer
How to send Email verification codes to user in Firebase using Python
Python
0 vote167 views1 answer
How to read numbers in csv files python
Python
0 vote233 views1 answer
Instal django impoer expor
Python Django
0 vote178 views1 answer
Python count how many times a word appears in a string
Python