/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 vote277 views1 answer
Python switch case 3.10 Structural Pattern Matching
Python
13 votes273 views2 answers
Python last letter of string
Python
1 vote313 views2 answers
ImportError: No module named easydict
Python
1 vote306 views1 answer
Microbit python documentation
Python
0 vote287 views1 answer
Trim strings python
Python
0 vote308 views1 answer
Numpy euclidean distance matrix broadcasting
Python
9 votes334 views4 answers
Pandas print full dataframe
Python
4 votes254 views3 answers
Infinite while loop in python
Python
1 vote266 views1 answer
Python all letters capital
Python
0 vote293 views1 answer
List of files to zip python
Python