/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 vote272 views1 answer
Filter a pandas dataframe by length of list in a column
Python
0 vote266 views1 answer
Python - How to execute a program or call a system command?
Python
0 vote285 views1 answer
Django model registration
Python Django
0 vote241 views1 answer
No module named 'fastai'
Python
0 vote280 views2 answers
Iris data pandas scatterplot
Python
0 vote264 views1 answer
If equal to key return value python
Python
0 vote259 views1 answer
Sum the items of an array
Python
2 votes274 views3 answers
Pandas split column into multiple columns by delimiter
Python
0 vote259 views1 answer
List(my_enumerate(your_sequence)) == list(enumerate(your_sequence))
Python
3 votes260 views2 answers
Discord.py make command admin only
Python