Skip to content

Instantly share code, notes, and snippets.

@renaud
Created March 11, 2014 08:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save renaud/9481884 to your computer and use it in GitHub Desktop.
Save renaud/9481884 to your computer and use it in GitHub Desktop.
adding two Pandas dataframes
import numpy as np
import pandas as pd
df1 = pd.DataFrame([(1,2),(2,4),(5,6)], columns=['a','b'])
df1
df2 = pd.DataFrame([(100,200),(300,400),(500,600)], columns=['a','b'])
df2
df_add = df1.add(df2, fill_value=0)
df_add
# df3 = pd.DataFrame([(1,10),(2,20),(3,30)], columns=['a','b']).groupby('a')
# df4 = pd.DataFrame([(1,100),(2,200),(3,300)], columns=['a','b']).groupby('a')
# df_add2 = df3.add(df4, fill_value=0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment