/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 vote247 views1 answer
Micropython free space esp32 esp2866
Python
1 vote241 views1 answer
How to add a fuction in python
Python
1 vote242 views1 answer
Seconds in a month
Python
1 vote252 views1 answer
Font awesome icon does not show
Python
1 vote256 views1 answer
Combining series to a dataframe
Python
0 vote238 views1 answer
X = y < z and z > y or y > z and z < y python
Python
0 vote241 views1 answer
Lamda in f string
Python
1 vote228 views1 answer
Variance of array python
Python
0 vote240 views1 answer
_getfullpathname: path should be string, bytes or os.PathLike, not list
Python
0 vote250 views1 answer
Pytohn reset all dictionary values to 0
Python