I want to multiply certain columns based on value of another column.
merged.loc[merged.check.str.contains('1'), 'price'] = merged['price']*100000.0
merged.head()
But I am getting this error.
ValueError: cannot reindex from a duplicate axis
Asked
Active
Viewed 29 times
0
sais
- 21
- 5
-
Did you have a look at [this](https://stackoverflow.com/questions/27236275/what-does-valueerror-cannot-reindex-from-a-duplicate-axis-mean)? – Georgy Kopshteyn May 29 '21 at 09:12
-
Yes. there are no duplicate indexes. – sais May 29 '21 at 09:21
-
I basically want to multiple *price* by 100000 if *check* contains 1 – sais May 29 '21 at 09:22
-
`merged.loc[merged.check.str.contains('1'), 'price'] *= 100000.0` – perl May 29 '21 at 09:30