/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 vote170 views1 answer
Randian angle to degrees using numpy
Python
1 vote166 views1 answer
Unique words from pandas
Python
4 votes117 views1 answer
Install unittest python
Python
0 vote160 views1 answer
Sys executable juypter is incorrect visual code
Python
1 vote165 views1 answer
Pttsx3 pip
Python
-1 vote173 views1 answer
How split text in python by space or newline with regex
Python
0 vote182 views1 answer
Conda install pypy
Python
0 vote176 views1 answer
Onetoone vs foreign key django
Python
26 votes176 views1 answer
Execute command in python script
Python
3 votes169 views1 answer
Tkinter labelframe
Python