/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

36 votes228 views6 answers
Reset_index pandas
Python
12 votes256 views6 answers
Pandas drop duplicates
Python
0 vote231 views1 answer
Opencv export image
Python
0 vote238 views1 answer
Django-oauth
Python Django
-3 votes252 views1 answer
Django socketio web chat example
Python Django
1 vote227 views1 answer
Incognito in selenium
Python
0 vote243 views1 answer
Celery timezone setting django
Python Django
107 votes228 views6 answers
Python do while loop
Python
0 vote232 views1 answer
Remove percentage in python
Python
0 vote234 views1 answer
Check tf verison
Python