how to sum two dataframes python

Question

I have two dataframes

tickers                        dt  AAPL  AMC  AMZN  ...  TH  TSLA  VIAC  WKHS
0       2021-03-22 00:00:00+00:00     0    0     0  ...   0     1     0     0
1       2021-03-23 00:00:00+00:00     0    0     0  ...   0     1     0     0
2       2021-03-24 00:00:00+00:00     1    2     0  ...   0     0     0     0
3       2021-03-25 00:00:00+00:00     0    0     0  ...   0     0     0     0
4       2021-03-26 00:00:00+00:00     0    2     0  ...   0     4     0     0

tickers                        dt  AAPL  AMC  AMZN  ...  TH  TSLA  VIAC  WKHS
0       2021-03-19 00:00:00+00:00     0    0     0  ...   0     0     0     0
1       2021-03-20 00:00:00+00:00     0    0     0  ...   0     0     0     0
2       2021-03-21 00:00:00+00:00     0    0     0  ...   0     0     0     0
3       2021-03-22 00:00:00+00:00     0    0     0  ...   0     3     0     0
4       2021-03-23 00:00:00+00:00     0    0     0  ...   0     3     0     0

I want to sum each row by corresponding row from another dataframe. You can see that some time from one dataframe doesn't exist in another dataframe. I also want to consider them and include in the new dataframe

Try this: stackoverflow.com/a/23361783/2612429

S2L
– S2L

2021-08-17 09:40:21 +00:00
Commented Aug 17, 2021 at 9:40 — S2L
– S2L, Commented Aug 17, 2021 at 9:40
yeah but I also want to consider when they don't intersect

YanRemes
– YanRemes

2021-08-17 09:47:48 +00:00
Commented Aug 17, 2021 at 9:47 — YanRemes
– YanRemes, Commented Aug 17, 2021 at 9:47

Deepak Tatyaji Ahire · Accepted Answer · 2021-08-17 09:52:04Z

3

Try this:

df = pd.concat([df1, df2]).groupby(['dt']).sum().reset_index()

print(df)

PS: This is ensure all datetimes to exist.

answered Aug 17, 2021 at 9:52

Deepak Tatyaji Ahire

5,3915 gold badges21 silver badges47 bronze badges

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

2 Comments

YanRemes Over a year ago

also, how would I divide one data by another keeping all the time rows

Deepak Tatyaji Ahire Over a year ago

I request you to kindly ask a separate question as it will involve invalid division operation if the values are missing in either of the data frame.

Ayush Goel · Accepted Answer · 2021-08-17 11:03:46Z

2

One way would be to first merge the dataframes, and then carry out the sum.

df1 = df1.merge(df2, left_on='dt', right_on='dt', how='outer')

The column names may end with an '_x' or '_y' to allow you to differentiate. You can then do a normal dataframe sum.

edited Aug 17, 2021 at 11:03

answered Aug 17, 2021 at 9:41

Ayush Goel

3751 silver badge8 bronze badges

3 Comments

YanRemes Over a year ago

I tried this one but it remove row with 2021-03-19 time. And I want to keep it as well

Ayush Goel Over a year ago

In that case, I think you can just set how='outer'. This will take the union of both keys, so they won't be removed.

YanRemes Over a year ago

the dataset doesn't have 2021-03-19 00:00:00+00:00 1 2021-03-20 00:00:00+00:00 2 2021-03-21 00:00:00+00:00

Collectives™ on Stack Overflow

how to sum two dataframes python

2 Answers 2

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related