/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

4 votes197 views1 answer
Check if an application is running python
Python
0 vote229 views1 answer
What should I do when the keras image datagenerato is nit working
Python
7 votes195 views2 answers
How to revert a list python
Python
1 vote206 views1 answer
Renpy scene vs show
Python
0 vote227 views1 answer
Onlinecourses.osppro.com
Python
2 votes291 views4 answers
Numpy reshape (n ) to (n 1)
Python
0 vote195 views1 answer
1036 solution python
Python
22 votes193 views4 answers
Empty dataframe
Python
123 votes187 views6 answers
Rename column in dataframe
Python
5 votes220 views5 answers
Fibonacci series program in python
Python