/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 vote313 views1 answer
Write a python program to find fibonacci series upto a certain limit using while loop
Python
5 votes255 views4 answers
Fahrenheit to celsius python program
Python
2 votes283 views1 answer
Split array into chunks python
Python
0 vote308 views1 answer
Django admin no such table user
Python Django
0 vote300 views1 answer
Get all methods of an instance
Python
0 vote267 views1 answer
Odoo sorted
Python
1 vote329 views3 answers
Come fare aprire una pagina web python
Python
0 vote345 views2 answers
Fetch api flask url redirect
Python Flask
2 votes273 views1 answer
Get list of all files in folder and subfolders python
Python
1 vote548 views1 answer
TypeError: unhashable type: 'list' python dictionary
Python