/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 vote142 views1 answer
Python format new
Python
6 votes144 views5 answers
Pandas remove whitespace
Python
0 vote151 views1 answer
Delete df rows where column value = 0: mult col's
Python
0 vote140 views2 answers
Pygame center text in rect
Python
0 vote142 views1 answer
How to create random tensor with tensorflow
Python
3 votes151 views1 answer
Get common elements from two lists
Python
1 vote142 views1 answer
SerialClient.py", line 41, in <module> import queue ImportError: No module named queue
Python
4 votes161 views1 answer
Django pandas queryset
Python
1 vote146 views6 answers
How to hello world in python
Python
1 vote145 views1 answer
Join pyspark stackoverflow
Python