How to replace one column name with multiple column names in existing pandas dataframe?

Question

I have a dataframe that looks like this: print(df)

				0
0	01-Dec	92	1,475.60	0.00
1	02-Dec	106	0.00	0.00
3		03-Dec	0.00	75.00

I would like to be able to get my dataframe to look like this (add in the column names and shift the 3rd row to the left):

	Process_Date	Transactions	Net_Sales
0	01-Dec	92	1,475.60
1	02-Dec	106	0.00
3	03-Dec	0.00	75.00

This is my code to add in the column names:

df.columns = ["Process_Date", "Transactions", "Net_Sales", "Third_Party"]

def shifter(row):
    return np.hstack((delete(np.array(row), [1]), [np.nan]))

mask = df['Transactions'] == '03-Dec'
df.loc[mask, :] = df.loc[mask, :].apply(shift, axis=1)

This is the Output:

ValueError: Length mismatch: Expected axis has 1 elements, new values have 4 elements

Naveed · Accepted Answer · 2022-10-28 13:58:33Z

1

here is one way to do it

# filter the rows, as per your question
mask = df['Transactions'] == '03-Dec'

# shift the values left along the axis (row), and fill NaN with zero
df.loc[mask]=df.loc[mask].shift(-1,axis=1).fillna(0, axis=1)
df

    Process_Date    Transactions    Net_Sales   Third_Party
0   01-Dec                 92        1,475.60         0.0
1   02-Dec                106            0.00         0.0
3   03-Dec                  0.00        75.0          0

answered Oct 28, 2022 at 13:58

Naveed

11.7k2 gold badges16 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

How to replace one column name with multiple column names in existing pandas dataframe?

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