Move columns to the right in Pandas

Question

I have dataset:

Stop_ID	On_Demand	Tarif	Heading
1	T100	Station
2	DYes	T101	Gym
3	T101	River

I want to have:

Stop_ID	On_Demand	Tarif	Heading
1	DNo	T100	Station
2	DYes	T101	Gym
3	DNo	T101	River

I tried:

for index, row in sm.iterrows():
    if not row["On_Demand"].startswith("D"):
        sm.loc[index, "Tarif":] = row["On_Demand":]
        sm.loc[index, "On_Demand"] = "DNo"

but it doesnt bring any result. Any idea how can I achieve it?

try sm.at[index,'Tarif'] = row['On_Demand'] that is inplace of loc try if at solves the issue — Yadnesh Salvi
– Yadnesh Salvi, Commented Feb 7, 2022 at 10:10

jezrael · Accepted Answer · 2022-02-07 10:16:42Z

3

Use DataFrame.shift with axis=1 only filtered rows by inverted mask by ~ and then set column On_Demand by same mask:

m = df["On_Demand"].str.startswith("D")

df.loc[~m, "On_Demand":] = df.loc[~m, "On_Demand":].shift(axis=1)
df.loc[~m, "On_Demand"] = "DNo"

print (df)
   Stop_ID On_Demand Tarif  Heading
0        1       DNo  T100  Station
1        2      DYes  T101      Gym
2        3       DNo  T101    River

edited Feb 7, 2022 at 10:16

answered Feb 7, 2022 at 10:11

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Move columns to the right in Pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related