dataframe duplicate column values in one column

Question

I have the following dataframe

column1	column1
None	value 1
None	value 1
None	value 1
None	value 1
value2	None

Both columns have the same name. I want to make these two columns into one column and fill them with values. like this

column1
value1
value1
value1
value1
value2

What should I do?

Note that only one of the duplicate columns has a value.

ThePyGuy · Accepted Answer · 2022-11-03 04:18:12Z

2

Replace None string values by NaN float values, then stack which will convert the data to a single column dropping na values as dropna=True by default for stack, then finally unstack:

df.replace('None', float('nan')).stack().unstack()

OUTPUT:

   column1
0  value 1
1  value 1
2  value 1
3  value 1
4   value2

answered Nov 3, 2022 at 4:18

ThePyGuy

18.5k5 gold badges24 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

dataframe duplicate column values in one column

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