/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

1 vote302 views2 answers
Flask bootstrap
Python Flask
10 votes255 views4 answers
How to make a variable in python
Python
2 votes258 views2 answers
Python include file
Python
2 votes253 views1 answer
Python how to unnest a nested list
Python
5 votes256 views1 answer
What is seaborn in python
Python
4 votes260 views4 answers
Pandas rename specific column
Python
0 vote299 views1 answer
Matplotlib get padding from bbox
Python
0 vote267 views1 answer
Pyaduio linux
Python
1 vote319 views1 answer
Save np array as mat file
Python
0 vote266 views1 answer
Install python on windows subsystem for linux
Python