/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 vote204 views1 answer
Django require_POST body
Python Django
12 votes186 views3 answers
How to open any application using python
Python
-1 vote195 views1 answer
How to give values to all users with discord api python grepper
Python
0 vote182 views1 answer
Python import multiple csv
Python
1 vote191 views1 answer
Small factorial codechef solution
Python
0 vote195 views1 answer
Python reference parent module
Python
2 votes197 views2 answers
Python Decompress gzip File
Python
0 vote183 views2 answers
Value is not a valid dict (type=type_error.dict) response_model fastapi
Python
0 vote191 views1 answer
Django populate form from database
Python
3 votes200 views2 answers
Getting text input pygame python
Python