python - Passing a paremeter taken from a dataframe column to a pandas method

Question

Let's say I have a dataframe with two columns, a naive date, and it's corresponding timezone. I'd like to convert the naive date to a timezone aware date using the second column.

naive_date	timezone
24-01-2021 05:00:00	'Europe/London'
24-01-2021 06:00:00	'Europe/Amsterdam'
24-01-2021 00:00:00	'US/Eastern'

question from:https://stackoverflow.com/questions/65866411/passing-a-paremeter-taken-from-a-dataframe-column-to-a-pandas-method

Answer 1

Pablo's answer was spot on, this is what I ended up using:

df['local_date'] = df.apply(lambda x: x['naive_date'].tz_localize(tz=x['timezone']), axis=1)