How to add rows from one dataframe to another dataframe one after another using pandas

Question

i have two dataframe like df1

    time    kw
0   13:00   30
1   13:02   28
2   13:04   29

and df2

  time    kw
1   13:01   30
2   13:03   28
3   13:05   29

i want to add rows from one dataframe to another for end result like

  time    kw
1   13:00   30
2   13:01   30
3   13:02   28
4   13:03   28
5   13:04   29
6   13:05   29

Please help.. I concat both dataframeresult_df = pd.concat([df1, df2]), but it just put them side by side. Secondly i tried to append both dataframe, but still not what i am looking for Thanks in advance

Please do add your efforts in your question which is highly encouraged on SO. Thank you — RavinderSingh13
– RavinderSingh13, Commented Apr 10, 2021 at 14:36

Hussein Awala · Accepted Answer · 2021-04-10 14:42:42Z

3

import pandas as pd

df1 = pd.DataFrame([("13:00", 30), ("13:02", 28), ("13:04", 29)], columns=["time", "kw"])
df2 = pd.DataFrame([("13:01", 30), ("13:03", 28), ("13:05", 29)], columns=["time", "kw"])

df = pd.concat([df1, df2]).sort_values("time")

answered Apr 10, 2021 at 14:42

Hussein Awala

5,1932 gold badges13 silver badges28 bronze badges

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

Comments

Mayank Porwal · Accepted Answer · 2021-04-10 14:38:48Z

1

Use df.append with df.sort_values:

In [2362]: df1.append(df2).sort_values('time')
Out[2362]: 
    time  kw
0  13:00  30
1  13:01  30
1  13:02  28
2  13:03  28
2  13:04  29
3  13:05  29

answered Apr 10, 2021 at 14:38

Mayank Porwal

34.2k9 gold badges45 silver badges65 bronze badges

Collectives™ on Stack Overflow

How to add rows from one dataframe to another dataframe one after another using pandas

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related