combine two rows of dataframe with different index

Question

For example, I have a dataframe which looks like this:

The wanted result is:

What should I do with pandas?

Does this answer your question? [How to drop rows of Pandas DataFrame whose value in a certain column is NaN](https://stackoverflow.com/questions/13413590/how-to-drop-rows-of-pandas-dataframe-whose-value-in-a-certain-column-is-nan) — mozway, Aug 01 '21 at 05:02

score 0 · Answer 1 · edited Aug 01 '21 at 05:28

0

Use a combination of dropna and fillna:

df=df.dropna(subset=['age']).fillna({'champions':1})

or, if you want to fill the values from the previous rows, use ffill:

df=df.dropna(subset=['age']).ffill()

edited Aug 01 '21 at 05:28

Anurag Dabas

answered Aug 01 '21 at 04:51

mozway

1

You're right, I had not seen the NaN in the second column! I'll fix the answer. Thanks! – mozway Aug 01 '21 at 05:22

1 Answers1