/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

17 votes272 views10 answers
Javascript loop
Python
0 vote297 views1 answer
Difference between __gte and __lte in Django
Python
-1 vote260 views1 answer
Python graph
Python
2 votes257 views1 answer
List comprehension python 3 hackerrank solution
Python
1 vote275 views1 answer
Grouping products for sales
Python
2 votes251 views2 answers
Python infinite l00p
Python
7 votes281 views1 answer
Python marker size
Python
0 vote256 views1 answer
While attempts > 0:
Python
0 vote289 views2 answers
How to make a stopwatch in python
Python
10 votes269 views2 answers
Django import settings
Python