Increment a time and add it in data frame column

Question

Hi I am new to python and I am looking for below result.

I have From_Curr(3), To_Curr(3) and making currency pairs and adding new column in my data frame as time.

3*3 = 9 currency pairs created So I want same time for currency pairs and then increment by 1 hr again for same pairs as shown below.

Problem statement is time gets incremented after every row.

Actual df:

Expected df:

Thanks for any help and appreciate your time.

`

import pandas as pd
import datetime
from datetime import timedelta
data = pd.DataFrame({'From':["EUR","GBP",'USD'],
                    'To':["INR","SGD",'HKD'],
                    'time':''})


init_date = datetime.datetime(1, 1, 1)
for index, row in data.iterrows():
    row['time'] = str(init_date)[11:19]
    init_date = init_date + timedelta(hours=1.0)

`

Answer 1

I'm not understanding why you are repeating the combinations, and incrementing in one hour in the last half.

But for this case, you can do something like this:

import pandas as pd

data = pd.DataFrame({'From':["EUR","GBP",'USD'],
                    'To':["INR","SGD",'HKD'],
                    'time':''})
outlist = [ (i, j) for i in data["From"] for j in data["To"] ]*2 # Create double combinations
data = pd.DataFrame(data=outlist,columns=["From","To"])
data["time"] = "00:00:00"
data["time"].iloc[int(len(data)/2):len(data)] =  "01:00:00" # Assign 1 hour to last half
data["time"] = pd.to_datetime(data["time"]).dt.time

Update: After some clarifications

import pandas as pd

data = pd.DataFrame(
    {"From": ["EUR", "GBP", "USD"], "To": ["INR", "SGD", "HKD"], "time": ""}
)
outlist = [
    (i, j) for i in data["From"] for j in data["To"]
] * 2  # Create double combinations, i think that for your case it would be 24 instead of two
data = pd.DataFrame(data=outlist, columns=["From", "To"])
data["time"] = data.groupby(["From", "To"]).cumcount()  # Get counts of pairs values
data["time"] = data["time"] * pd.to_datetime("01:00:00").value # Multiply occurrences by the value of 1 hour
data["time"] = pd.to_datetime(data["time"]).dt.time # Pass to time

I think this script covers all your needs, happy coding :)

Regards,