/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 votes130 views1 answer
Os.getlogin() python
Python
3 votes125 views1 answer
Python re match
Python
4 votes154 views1 answer
Python path to python executable
Python
0 vote168 views1 answer
How to extract integers from string python
Python
0 vote147 views1 answer
Label default text value python
Python
0 vote156 views1 answer
Pandas replace values from another dataframe
Python
0 vote152 views1 answer
Change a color on touch roblox
Python
0 vote158 views1 answer
Arithmetic encoding python
Python
0 vote160 views1 answer
List Get a Element-2
Python
0 vote184 views1 answer
How to interrupt a loop in python
Python