Pandas concat yields ValueError: Plan shapes are not aligned

by

In case it helps, I have also hit this error when I tried to concatenate two data frames (and as of the time of writing this is the only related hit I can find on google other than the source code).

I don’t know whether this answer would have solved the OP’s problem (since he/she didn’t post enough information), but for me, this was caused when I tried to concat dataframe df1 with columns ['A', 'B', 'B', 'C'] (see the duplicate column headings?) with dataframe df2 with columns ['A', 'B']. Understandably the duplication caused pandas to throw a wobbly. Change df1 to ['A', 'B', 'C'] (i.e. drop one of the duplicate columns) and everything works fine.

More Related Contents:

  1. Pandas Merging 101
  2. Import multiple csv files into pandas and concatenate into one DataFrame
  3. Why does concatenation of DataFrames get exponentially slower?
  4. Import multiple excel files into python pandas and concatenate them into one dataframe
  5. pandas concat generates nan values
  6. How to convert DataFrame.append() to pandas.concat()?
  7. Split / Explode a column of dictionaries into separate columns with pandas
  8. Annotate bars with values on Pandas bar plots
  9. How do I concatenate text files in Python?
  10. plot different color for different categorical levels using matplotlib
  11. Counting consecutive positive values in Python/pandas array
  12. Pandas GroupBy and select rows with the minimum value in a specific column
  13. Pandas Dataframe: Replacing NaN with row average
  14. How to read a .xlsx file using the pandas Library in iPython?
  15. Pandas – Number of Months Between Two Dates
  16. Modify the legend of pandas bar plot
  17. How do I convert a list in a Pandas DF into a string?
  18. How to append rows in a pandas dataframe in a for loop?
  19. Interpolation on DataFrame in pandas
  20. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  21. Pandas Groupby / List to Multiple Rows
  22. Trying to merge 2 dataframes but get ValueError
  23. Pandas Latitude-Longitude to distance between successive rows [duplicate]
  24. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  25. Arithmetic and aligning DataFrames with same columns, different index levels
  26. Pandas DataFrame performance
  27. Add numpy array as column to Pandas data frame
  28. How to use ast.literal_eval in a pandas dataframe and handle exceptions
  29. Pandas Rolling Computations on Sliding Windows (Unevenly spaced)
  30. DataFrame object has no attribute append

Leave a Comment