/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 vote195 views1 answer
Python message from teams
Python
0 vote255 views1 answer
Python non public method
Python
0 vote186 views2 answers
Importerror: cannot import name
Python
-1 vote214 views1 answer
How to make a variable in python 3
Python
0 vote203 views1 answer
Change x axis frequency
Python
10 votes318 views1 answer
Is not none python
Python
82 votes222 views6 answers
Create virtualenv python3
Python
2 votes244 views1 answer
Write a value of a string in a sentence in python
Python
19 votes157 views2 answers
Append dataframe pandas
Python
2 votes230 views1 answer
How to pipe using sybprosses run python
Python