Pandas: Replacing a row with another data frame

Question

I have two data frames: df1

and df2

Now I want to replace one of rows of df1 (highlighted in red colour) with all values of df2. I try with following codes but didn't give the desired result. Here is the code:

df1[df1['Category_2']=='Specified Functionality'].update(df2)

I also tried:

df1[df1['Category_2']=='Specified Functionality'] = df2

Could anyone guide me where I am making the mistake?

Can you please post the actual data as text instead of pictures of the data? — Nathaniel
– Nathaniel, Commented Mar 20, 2019 at 0:16

Nathaniel · Accepted Answer · 2019-03-20 00:14:08Z

1

You can insert the rows like this:

row = 13
df2 = df2.rename(columns = {'Functionality': 'Category_2')
df = pd.concat([df1[0:row], df2, df1[row+1:]]).reset_index(drop=True)

answered Mar 20, 2019 at 0:14

Nathaniel

3,32013 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Pandas: Replacing a row with another data frame

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related