Adding two pandas dataframes

by

How about x.add(y, fill_value=0)?

import pandas as pd

df1 = pd.DataFrame([(1,2),(3,4),(5,6)], columns=['a','b'])
Out: 
   a  b
0  1  2
1  3  4
2  5  6

df2 = pd.DataFrame([(100,200),(300,400),(500,600)], columns=['a','b'])
Out: 
     a    b
0  100  200
1  300  400
2  500  600

df_add = df1.add(df2, fill_value=0)
Out: 
     a    b
0  101  202
1  303  404
2  505  606

More Related Contents:

  1. How to deal with SettingWithCopyWarning in Pandas
  2. Apply multiple functions to multiple groupby columns
  3. GroupBy results to dictionary of lists
  4. Pandas timeseries plot setting x-axis major and minor ticks and labels
  5. How to remove nan value while combining two column in Panda Data frame?
  6. How do I operate on a DataFrame with a Series for every column?
  7. Improve subplot size/spacing with many subplots in matplotlib
  8. Pandas split column into multiple columns by comma
  9. Restart cumsum and get index if cumsum more than value
  10. How to use groupby to concatenate strings in python pandas?
  11. Add months to a date in Pandas
  12. Horizontal stacked bar plot and add labels to each section
  13. Python – How to convert JSON File to Dataframe
  14. How to change the datetime tick label frequency for matplotlib plots
  15. python pandas dataframe, is it pass-by-value or pass-by-reference
  16. Pandas expand rows from list data available in column
  17. Convert pandas DateTimeIndex to Unix Time?
  18. pandas dataframe select columns in multiindex [duplicate]
  19. Create Column with ELIF in Pandas
  20. Pandas – Compute z-score for all columns
  21. Selecting/excluding sets of columns in pandas [duplicate]
  22. pandas distinction between str and object types
  23. pandas filtering and comparing dates
  24. Find date range overlap in python
  25. Reverse a get_dummies encoding in pandas
  26. pandas divide row value by aggregated sum with a condition set by other cell
  27. Updating a value in a pandas dataframe in an iterrows loop
  28. Can you format pandas integers for display, like `pd.options.display.float_format` for floats?
  29. computing the mean for python datetime
  30. Pandas explode multiple columns [duplicate]

Leave a Comment