/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 vote214 views1 answer
Where to import messages in django
Python
0 vote216 views1 answer
Python tkinter importieren
Python
7 votes221 views3 answers
Clear all python cache
Python
1 vote224 views1 answer
Python set timezone of datetime
Python
0 vote210 views1 answer
How to get foregine key field from models
Python
0 vote205 views1 answer
How to change array of arrays to simpe array
Python
0 vote207 views1 answer
How to get the top 100 frequent words on a python dataframe colummn
Python
1 vote217 views1 answer
Bezier curve python
Python
0 vote224 views1 answer
Flask template split string
Python Flask
3 votes210 views1 answer
Pandas fill na with value from another column
Python