/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

54 votes185 views5 answers
Sort dict by value python 3
Python
0 vote213 views1 answer
Sample one point from distribution python
Python
0 vote200 views2 answers
Compiling python code
Python
10 votes158 views1 answer
Python string methods
Python
5 votes188 views2 answers
Import get_object_or_404
Python
37 votes214 views6 answers
Upgrade package python
Python
18 votes270 views4 answers
Matplotlib histogram
Python
6 votes173 views2 answers
Python max
Python
0 vote210 views2 answers
Pandas apply check for string length in column
Python
0 vote234 views1 answer
Convert 2 level nested list to one level list in python
Python