/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

155 votes197 views6 answers
Python check if file exists
Python
0 vote103 views1 answer
Python append filename to path
Python
8 votes93 views3 answers
Is alphabet python
Python
0 vote114 views1 answer
Download face_cascade.detectMultiScale
Python
78 votes111 views6 answers
Python sort dict by value
Python
5 votes165 views1 answer
Add bearer token in python request
Python
0 vote111 views1 answer
Calculate the euler totient of a number python
Python
0 vote118 views1 answer
Np.linalg.eigvals positive check python
Python
0 vote102 views1 answer
Jet 4 access python password
Python
0 vote61 views1 answer
Is python not a real programing laguage because lines dont end in ;
Python