0

df=

****Condition A B C **

A a1. b1. c1.
B a2. b2. c2.
A a3. b3 c3.
B a4. b4. c4.
C a5. b5. c5.
A a6. b6. c6.

df=

**Condition A B C result **

A a1. b1. c1. should be a1 B a2. b2. c2. should be b2 A a3. b3 c3. should be a3 B a4. b4. c4. should be b4 C a5. b5. c5. should be c5 A a6. b6. c6. should be a6

ChristineK
  • 23
  • 2
  • read [Looking up values by index/column labels](https://pandas.pydata.org/docs/user_guide/indexing.html#indexing-lookup): `idx, cols = pd.factorize(df['Condition']) ; df.reindex(cols, axis=1).to_numpy()[np.arange(len(df)), idx]` – mozway Nov 24 '22 at 07:14

0 Answers0