/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

2 votes210 views2 answers
AttributeError: module 'django.contrib.auth.views' has no attribute 'login'
Python Django
0 vote161 views1 answer
405 status code django
Python
11 votes176 views2 answers
How to get frequency of each elements in a python list
Python
3 votes165 views1 answer
Python print float in scientific notation
Python
4 votes183 views2 answers
Python simplify fraction
Python
0 vote159 views1 answer
Bs4 innerhtml
Python
11 votes167 views1 answer
Python check if int is between two values
Python
0 vote162 views1 answer
Why am i not able to import wtf flask
Python
7 votes174 views1 answer
Replace cell pandas
Python
3 votes185 views1 answer
Python csv reader set delimiter
Python