adding row from one dataframe to another

Question

I am trying to insert or add from one dataframe to another dataframe. I am going through the original dataframe looking for certain words in one column. When I find one of these terms I want to add that row to a new dataframe.

I get the row by using. entry = df.loc[df['A'] == item] But when trying to add this row to another dataframe using .add, .insert, .update or other methods i just get an empty dataframe.

I have also tried adding the column to a dictionary and turning that into a dataframe but it writes data for the entire row rather than just the column value. So is there a way to add one specific row to a new dataframe from my existing variable ?

Answer 1

So the entry is a dataframe containing the rows you want to add? you can simply concatenate two dataframe using concat function if both have the same columns' name

import pandas as pd

entry = df.loc[df['A'] == item]
concat_df = pd.concat([new_df,entry])

pandas.concat reference:

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.concat.html