Trying to merge 2 dataframes but get ValueError

by

In one of your dataframes the year is a string and the other it is an int64
you can convert it first and then join (e.g. df['year']=df['year'].astype(int) or as RafaelC suggested df.year.astype(int))

Edit: Also note the comment by Anderson Zhu: Just in case you have None or missing values in one of your dataframes, you need to use Int64 instead of int. See the reference here.

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  3. How to unnest (explode) a column in a pandas DataFrame, into multiple rows
  4. Error: pandas hashtable keyerror
  5. Writing a pandas DataFrame to CSV file
  6. Remove unwanted parts from strings in a column
  7. pandas: How do I split text in a column into multiple rows?
  8. Find row where values for column is maximal in a pandas DataFrame
  9. How to filter rows containing a string pattern from a Pandas dataframe [duplicate]
  10. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  11. Drop rows containing empty cells from a pandas DataFrame
  12. Why does my Pandas DataFrame not display new order using `sort_values`?
  13. python/pandas: convert month int to month name
  14. How to check if a column exists in Pandas
  15. How to form tuple column from two columns in Pandas
  16. Convert pandas Series to DataFrame
  17. Remove name, dtype from pandas output of dataframe or series
  18. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  19. pandas: combine two columns in a DataFrame
  20. How do I filter a pandas DataFrame based on value counts?
  21. Lambda including if…elif…else
  22. Pandas query function not working with spaces in column names
  23. Pandas DataFrame sort by categorical column but by specific class ordering
  24. Remove NaN values from pandas dataframe and reshape table [duplicate]
  25. Got continuous is not supported error in RandomForestRegressor
  26. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  27. Get the row corresponding to the max in pandas GroupBy [duplicate]
  28. Copy text between parentheses in pandas DataFrame column into another column
  29. Get frequency of item occurrences in a column as percentage [duplicate]
  30. Pandas explode multiple columns [duplicate]

Leave a Comment