'Place the first value of Column B in Column C if Column A has same names in python pandas with loop [duplicate]
I have the following data set in python,
Input
I want to bring the first value of Column B that belongs to column Column A for a unique A value to be pasted in Column C.
For eg. value a in Column A has ABC, XYZ, and PQR, so in column C I want ABC, ABC, ABC Similarly for value b in Column A.
Expected Output:
I tried the following code in python.
df['C']=None
for i in range(len(df)):
if df['A'][i]==df['A'][i+1] and df['C'][i]==None:
df['C'][i]=df['B'][i]
if df['A'][i]==df['A'][i+1] and df['C'][i]!=None
I am stuck how to proceed with that. I will be really grateful for any help
Solution 1:[1]
df["C"] = df[df.index.isin(df.reset_index().groupby("A")["index"].first().to_list())]["B"]
df["C"].fillna(method='ffill', inplace=True)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | Alex |