CODEWITHSUNDEEP
pythonpandasdataframeappend
segfaultshurtme
segfaultshurtme

Reputation: 25

appending in pandas - row wise

I'm trying to append two columns of my dataframe to an existing dataframe with this: dataframe.append(df2, ignore_index = True)

and this does not seem to be working. This is what I'm looking for (kind of) --> a dataframe with 2 columns and 6 rows:

enter image description here

although this is not correct and it's using two print statements to print the two dataframes, I thought it might be helpful to have a selection of the data in mind.

I tried to use concat(), but that leads to some issues as well. dataframe = pd.concat([dataframe, df2]) but that appears to concat the second dataframe in columns rather than rows, in addition to gicing NaN values: enter image description here

any ideas on what I should do?

Upvotes: 1

Views: 1019

Answers (1)

AdibP
AdibP

Reputation: 2939

I assume this happened because your dataframes have different column names. Try assigning the second dataframe column names with the first dataframe column names.

df2.columns = dataframe.columns
dataframe_new = pd.concat([dataframe, df2], ignore_index=True)

Upvotes: 1

Related Questions