Pandas join/merge/concat two dataframes

by

Does your index have duplicates x.index.is_unique? If so would explain the behavior you’re seeing:

In [16]: left
Out[16]: 
            a
2000-01-01  1
2000-01-01  1
2000-01-01  1
2000-01-02  2
2000-01-02  2
2000-01-02  2

In [17]: right
Out[17]: 
            b
2000-01-01  3
2000-01-01  3
2000-01-01  3
2000-01-02  4
2000-01-02  4
2000-01-02  4

In [18]: left.join(right)
Out[18]: 
            a  b
2000-01-01  1  3
2000-01-01  1  3
2000-01-01  1  3
2000-01-01  1  3
2000-01-01  1  3
2000-01-01  1  3
2000-01-01  1  3
2000-01-01  1  3
2000-01-01  1  3
2000-01-02  2  4
2000-01-02  2  4
2000-01-02  2  4
2000-01-02  2  4
2000-01-02  2  4
2000-01-02  2  4
2000-01-02  2  4
2000-01-02  2  4
2000-01-02  2  4

More Related Contents:

  1. Filter dataframe rows if value in column is in a set list of values [duplicate]
  2. Converting a Pandas GroupBy output from Series to DataFrame
  3. datetime dtypes in pandas read_csv
  4. Split a large pandas dataframe
  5. How can I obtain the element-wise logical NOT of a pandas Series?
  6. Plotting grouped data in same plot using Pandas
  7. Python pandas slice dataframe by multiple index ranges
  8. Parsing a JSON string which was loaded from a CSV using Pandas
  9. pandas left join and update existing column
  10. Using Pandas Value_Counts and matplotlib
  11. which is faster for load: pickle or hdf5 in python
  12. Resample Daily Data to Monthly with Pandas (date formatting)
  13. Saving plots (AxesSubPlot) generated from python pandas with matplotlib’s savefig
  14. Return multiple columns from pandas apply()
  15. Set order of columns in pandas dataframe
  16. ImportError: No module named pandas
  17. Python Pandas – Merge based on substring in string
  18. How to show a pandas dataframe into a existing flask html table?
  19. Merging two dataframes based on a date between two other dates without a common column
  20. How to update Pandas from Anaconda and is it possible to use eclipse with this last
  21. Pandas rolling values
  22. What is the fastest way to output large DataFrame into a CSV file?
  23. Using pandas crosstab to create a bar plot
  24. Add numpy array as column to Pandas data frame
  25. Python: How to drop a row whose particular column is empty/NaN?
  26. Discrete legend in seaborn heatmap plot
  27. How to use ast.literal_eval in a pandas dataframe and handle exceptions
  28. Why is NaN considered as a float?
  29. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  30. Wide to long data transform in pandas

Leave a Comment