Pandas merge two dataframes with different columns

by

I think in this case concat is what you want:

In [12]:

pd.concat([df,df1], axis=0, ignore_index=True)
Out[12]:
   attr_1  attr_2  attr_3  id  quantity
0       0       1     NaN   1        20
1       1       1     NaN   2        23
2       1       1     NaN   3        19
3       0       0     NaN   4        19
4       1     NaN       0   5         8
5       0     NaN       1   6        13
6       1     NaN       1   7        20
7       1     NaN       1   8        25

by passing axis=0 here you are stacking the df’s on top of each other which I believe is what you want then producing NaN value where they are absent from their respective dfs.

More Related Contents:

  1. Good alternative to Pandas .append() method, now that it is being deprecated?
  2. Filter pandas DataFrame by substring criteria
  3. Binning a column with Python Pandas
  4. Compare two DataFrames and output their differences side-by-side
  5. Selecting a row of pandas series/dataframe by integer index
  6. How do I find the closest values in a Pandas series to an input number?
  7. Remove reverse duplicates from dataframe
  8. How do I count the NaN values in a column in pandas DataFrame?
  9. How to split text in a column into multiple rows
  10. getting the index of a row in a pandas apply function
  11. How to flatten a pandas dataframe with some columns as json?
  12. Tilde sign in pandas DataFrame
  13. Drop columns whose name contains a specific string from pandas DataFrame
  14. Shift column in pandas dataframe up by one?
  15. Pandas get frequency of item occurrences in a column as percentage [duplicate]
  16. Appending a list or series to a pandas DataFrame as a row?
  17. In Pandas, does .iloc method give a copy or view?
  18. Convert Pandas Series to DateTime in a DataFrame
  19. Python – Delete duplicates in a dataframe based on two columns combinations?
  20. Why is np.where faster than pd.apply
  21. Extract column value based on another column in Pandas
  22. Python Pandas: Get index of rows where column matches certain value
  23. Change the color of text within a pandas dataframe html table python using styles and css
  24. Scraping dynamic data selenium – Unable to locate element
  25. Python Pandas: Convert “.value_counts” output to dataframe
  26. Remove substring from column based on another column
  27. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  28. Get the row corresponding to the max in pandas GroupBy [duplicate]
  29. Selecting a range of columns in a dataframe
  30. Pandas explode multiple columns [duplicate]

Leave a Comment