/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

2 votes344 views3 answers
Pytorch check if using gpu
Python
75 votes324 views6 answers
How to reverse string in python
Python
0 vote329 views1 answer
Read stripped lines from a file python
Python
0 vote299 views1 answer
Python series get value
Python
3 votes327 views1 answer
Scan space seperated integers in python using map
Python
0 vote348 views1 answer
Python read file between two strings
Python
4 votes325 views2 answers
Uuid regex
Python
0 vote333 views1 answer
Convert sentence to words python
Python
1 vote367 views1 answer
Discord python wait for user input
Python
1 vote340 views1 answer
Python information
Python