Create New Column in Pandas Using Values from Two Columns

Question

I hope everyone is well. I am trying to create a new column that requires the values from two different columns ("Task Start Date" and "Hours"). I am trying to use the apply function but i cant figure out the correct syntax.

def get_start_date(end_date, day):

    date_format = '%d-%b-%y'
    date = datetime.strptime(end_date, date_format)
    start_date = date - timedelta(days = day)
    return start_date

asana_filtered["Task Start Date"] = asana_filtered.apply(get_start_date(["Task Due Date"], ["Days"]))

score 0 · Answer 1 · answered Mar 03 '20 at 10:14

0

Found it!

python pandas- apply function with two arguments to columns

asana_filtered["Task Start Date"] = asana_filtered.apply(lambda x: get_start_date(x["Task Due Date"], x["Days"]), axis=1)

answered Mar 03 '20 at 10:14

dodoelhos

147
1
12

score 0 · Answer 2 · answered Mar 03 '20 at 10:14

0

You can use the native pandas time converters:

df["Task Start Date"] = pd.to_datetime(df["Task Due Date"]) - pd.to_timedelta(df["Days"], unit="D")

answered Mar 03 '20 at 10:14

Oleg O

1,005
6
11

Create New Column in Pandas Using Values from Two Columns

2 Answers2