/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 vote339 views2 answers
OLE DB
Python
1 vote342 views1 answer
Find first date python
Python
14 votes328 views6 answers
If condition python
Python
6 votes342 views5 answers
Django logout
Python Django
0 vote391 views1 answer
TypeError: __init__(): incompatible constructor arguments. The following argument types are supported: 1. tensorflow.python._pywrap_file_io.BufferedInputStream(arg0: str, arg1: int)
Python
0 vote318 views1 answer
Scoop bucket add extras
Python
23 votes435 views2 answers
Flask or django
Python Flask
2 votes300 views1 answer
Upper input python
Python
0 vote338 views2 answers
@methodclass in python
Python
1 vote309 views1 answer
Decrease hours in datetime python
Python