/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

6 votes325 views3 answers
Infinty in python
Python
1 vote320 views2 answers
Keras sequential layer
Python
0 vote310 views1 answer
Primary key auto increment python django
Python
1 vote323 views1 answer
Read bytes from file python
Python
1 vote315 views1 answer
Matplotlib latex non italic indices
Python
0 vote313 views1 answer
Python update header row
Python
4 votes351 views2 answers
Python socket recv timeout
Python
30 votes323 views3 answers
How to get decimal part of a double in python
Python
0 vote306 views1 answer
A python string
Python
21 votes346 views3 answers
How to create an empty list of certain length in python
Python