/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 vote287 views2 answers
Pandas groupby aggregate quantile
Python
0 vote334 views1 answer
Python Write code that asks users to enter the year they were born. Print out how many years old they will turn in 2019.
Python
0 vote321 views1 answer
Read a csv and plot in python
Python
1 vote321 views1 answer
How many columns can a pandas dataframe have
Python
6 votes335 views2 answers
Django read mesage
Python Django
0 vote335 views1 answer
How to sort variable in specifiic order in python
Python
0 vote328 views1 answer
Python replace negative infinity
Python
0 vote312 views1 answer
Bebražole
Python
0 vote321 views1 answer
How to get only one column from dataset in python
Python
0 vote294 views1 answer
Finns = False
Python