How to insert a dataframe into another dataframe?

Question

I have two pandas dataframe like below.
df1:

  col1 col2    col3    col4
0   45   69  string  string

df2:

   col5    col8
0    45      37
1  data  random

I want to combine these two into one dataframe.
resultant df:

col1 col2    col3    col4
  45   69  string  string
--------- 1 or 2 empty rows here -------------
col5    col8
   45      37
 data  random

I tried the append method but that puts col5 and col8 as columns. I want to combine df1 and df2. col1, col2 and other column names don't even have to be column names in the resultant dataframe. They can be values in a row. I am trying to create a summary in the resultant dataframe.

Any help is appreciated. Thank you.

Have you read the docs? Pandas has concat, join and merge methods, have a look pandas.pydata.org/pandas-docs/stable/reference/api/… — alec_djinn
– alec_djinn, Commented Jun 14, 2022 at 15:41
A dataframe isn't ever going to be formatted like your desired output... they don't have randomly blank lines with new column names, that's just not how a dataframe works. Are you talking about exporting two dataframes in this format to a CSV or something? — BeRT2me
– BeRT2me, Commented Jun 14, 2022 at 15:44
This is not a code-writing or tutoring service. We can help solve specific, technical problems, not open-ended requests for code or advice such as "Any help is appreciated." With that as a caveat, the use of a dataframe for your expected results doesn't make sense. A DF is a collection of rows with arranged as columns of simial information. Leaving rows blank doesn't make sense in this context, nor does having a Column labeled Col1 with row data containing a col5 header. While it is valid to have mixed data types in a column this makes processing a df much more difficult. — itprorh66
– itprorh66, Commented Jun 14, 2022 at 15:45
@alec_djinn, Hi. I checked those methods too. Couldn't make it work. — Frank Shrestha
– Frank Shrestha, Commented Jun 14, 2022 at 16:03

BeRT2me · Accepted Answer · 2022-06-14 16:50:56Z

1

# write first dataframe
df1.to_csv('file.csv')

# append empty line
with open('file.csv', 'a') as f:
    f.write('\n\n')

# append second dataframe
df2.to_csv('file.csv', mode='a')

Output:

,col1,col2,col3,col4
0,45,69,string,string

,col5,col8
0,45,37
1,data,random

edited Jun 14, 2022 at 16:50

answered Jun 14, 2022 at 16:11

BeRT2me

13.3k2 gold badges18 silver badges39 bronze badges

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

1 Comment

Frank Shrestha Over a year ago

This worked well except it didn't add an empty row. Thanks. I added an empty row with df1=df1.append(pd.DataFrame([[''] * len(df1.columns)], columns=df1.columns)).

Collectives™ on Stack Overflow

How to insert a dataframe into another dataframe?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related