Adding data to a dataframe, from multiple other dataframes

Question

Edit: I think i've solved it, leaving it here incase anyone finds it helpful (or can improve what I have done) My solution was:

totalYield2017.loc['Q1'] = [fishLandingsQ1_df['Landed Weight (tonnes)'].sum(), fishLandingsQ1_df['Value(£)'].sum()]

I have created a blank dataframe

I want to populate it with sums of columns from other dataframes.

I have 4 other dataframes (one for each quarter, Q1, Q2 etc) that have columns for weight and value. I want to create a sum of each of those columns for the first row in my blank dataframe.

I have included a picture of one of the quarters dataframes, its the last 2 columns I want the sums of to be inputted into the blank dataframe

You can post the solution as answer rather than at the top of question. — Ynjxsjmh
– Ynjxsjmh, Commented Jun 7, 2022 at 11:25

lwoodcock · Accepted Answer · 2022-06-07 11:29:58Z

1

I think i've solved it, leaving it here in case anyone finds it helpful (or can improve what I have done) My solution was;

totalYield2017.loc['Q1'] = [fishLandingsQ1_df['Landed Weight (tonnes)'].sum(), fishLandingsQ1_df['Value(£)'].sum()]

answered Jun 7, 2022 at 11:29

lwoodcock

231 silver badge6 bronze badges

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

Collectives™ on Stack Overflow

Adding data to a dataframe, from multiple other dataframes

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related