Why do I get: “Length of values does not match length of index” error?

My best guess relies in this part:

myTempData ['Actuals'] = [True] * len(MyActualData.index)
myTempData ['Actuals'] = [False] * len(MyExpectedData.index)

It first says that myTempData['Actuals'] is a column of size len(MyActualData.index) containing only True values. Next, it replaces everything by another column of size len(MyExpectedData.index) (which I expect to be different) containing False values.

You can first create a column of True values and, only then, replace False ones:

myTempData['Actuals'] = True
myTempData.iloc[MyExpectedIndex] = False

Related Posts:

  1. Renaming column names in Pandas
  2. Delete a column from a Pandas DataFrame
  3. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  4. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  5. Writing a pandas DataFrame to CSV file
  6. Adding new column to existing DataFrame in Python pandas
  7. Modifing data while using iterrows() does not work
  8. How to change the order of DataFrame columns?
  9. What does `ValueError: cannot reindex from a duplicate axis` mean?
  10. Pandas DataFrame Groupby two columns and get counts
  11. How to show all columns’ names on a large pandas dataframe?
  12. ValueError: Unknown label type: ‘continuous’
  13. How to fix IndexError: invalid index to scalar variable
  14. How to deal with SettingWithCopyWarning in Pandas
  15. ImportError: No module named pandas
  16. Create a Pandas Dataframe by appending one row at a time
  17. How do I select rows from a DataFrame based on column values?
  18. How do I get the row count of a Pandas DataFrame?
  19. Python Pandas Counting the Occurrences of a Specific value
  20. Convert pandas dataframe to NumPy array
  21. Count unique values per groups with Pandas
  22. Convert pandas Series to DataFrame
  23. Error:cannot convert float NaN to integer in pandas
  24. Replacing column values in a pandas DataFrame
  25. How to iterate over rows in a DataFrame in Pandas
  26. How do I get the row count of a Pandas DataFrame?
  27. Pandas “Can only compare identically-labeled DataFrame objects” error
  28. Pandas: ValueError: cannot convert float NaN to integer
  29. Get list from pandas dataframe column or row?
  30. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  31. ‘DataFrame’ object has no attribute ‘sort’
  32. ‘DataFrame’ object has no attribute ‘sort’
  33. pandas: merge (join) two data frames on multiple columns
  34. TypeError: cannot unpack non-iterable int objec
  35. Pandas DataFrame column to list
  36. Rename Pandas DataFrame Index
  37. why should I make a copy of a data frame in pandas
  38. Pandas, merging two dataframes on multiple columns, and multiplying result
  39. How to customize a scatter matrix to see all titles?
  40. What is dtype(‘O’), in pandas?
  41. What is dtype(‘O’), in pandas?
  42. Python TypeError: cannot convert the series to when trying to do math on dataframe
  43. ValueError: ‘object too deep for desired array’
  44. What does axis in pandas mean?
  45. How to take column-slices of dataframe in pandas
  46. Combine two columns of text in pandas dataframe
  47. Group by index + column in pandas
  48. Pandas: change data type of Series to String
  49. Normalize data in pandas
  50. Convert a Pandas DataFrame to a dictionary
  51. Create a Pandas Dataframe by appending one row at a time
  52. module ‘pandas’ has no attribute ‘rolling_mean’
  53. Modify the legend of pandas bar plot
  54. Count unique values using pandas groupby
  55. Ignoring NaNs with str.containsv
  56. Count unique values per groups with Pandas [duplicate]
  57. Map to List error: Series object not callable
  58. Pandas DataFrame: replace all values in a column, based on condition
  59. How to convert string to datetime format in pandas python?
  60. No numeric types to aggregate – change in groupby() behaviour?
  61. Pandas – How to flatten a hierarchical index in columns
  62. Pandas OR statement ending in series contains
  63. Solution for SpecificationError: nested renamer is not supported while agg() along with groupby()
  64. ValueError: Expected object or value when reading json as pandas dataframe
  65. How to check if a column exists in Pandas
  66. How to get a value from a cell of a dataframe?
  67. Pandas split DataFrame by column value
  68. Groupby value counts on the dataframe pandas
  69. AttributeError: ‘Series’ object has no attribute ‘reshape’
  70. Pandas – Drop function error (label not contained in axis)
  71. Pandas index column title or name
  72. Building multi-regression model throws error: `Pandas data cast to numpy dtype of object. Check input data with np.asarray(data).`
  73. datetime to string with series in pandas
  74. import pandas_datareader gives ImportError: cannot import name ‘is_list_like’
  75. How to add pandas data to an existing csv file?
  76. Importing Pandas gives error AttributeError: module ‘pandas’ has no attribute ‘core’ in iPython Notebook
  77. Find the unique values in a column and then sort them
  78. pandas groupby sort within groups
  79. if else function in pandas dataframe
  80. cannot convert the series to
  81. Read data (.dat file) with Pandas
  82. How to convert index of a pandas dataframe into a column
  83. Replacing Pandas or Numpy Nan with a None to use with MysqlDB
  84. pandas replace multiple values one column
  85. Boolean Series key will be reindexed to match DataFrame index
  86. Converting Pandas dataframe into Spark dataframe error
  87. Convert floats to ints in Pandas?
  88. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  89. Difference between data type ‘datetime64[ns]’ and ‘
  90. Merging two DataFrames
  91. pandas: multiple conditions while indexing data frame – unexpected behavior
  92. Extract first and last row of a dataframe in pandas
  93. How to print a specific row of a pandas DataFrame?
  94. Logical operators for Boolean indexing in Pandas
  95. How to update Pandas from Anaconda and is it possible to use eclipse with this last
  96. vectorize conditional assignment in pandas dataframe
  97. Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
  98. Extracting specific selected columns to new DataFrame as a copy
  99. Compare two columns using pandas
  100. alueError: ordinal must be >= 1

Leave a Comment