I have a data frame that I’d like to filter
One other thing I thought about was the type mixing in Python. Based on what you have above, my guess is either you have col2 as string or float. If string, then go through the replace method to get rid of the string. If float, then you shouldn't need to replace the comma (that may be how Python shows thousands and millions but I can't remember specifics).
Run print(df.dtypes) to check.
On the column that I’d like to filter, the column contains data from two different sources. I’d like to normalize this data. We collected some data a certain way and the other rows of data contain data that was collected another way. There are rows that contain 1.2 2.3 3.4 and nothing over 5. I would like to multiply these numbers by 1,000 to match up with the others and remove the comma from the numbers above 1,000.




col1
col2




1
1.641


2
1.548


3
1,807.000


4
1,759.000