This post is also available in: 日本語 (Japanese)
Using pandas, I wrote a sample code as a memo that replaces the comma(,) in numbers with the replace() function and then converts the data type.
As I wrote in the comments in the sample code, if the data type of the Series to be replaced is str, you can use the '.str' accessor, and if it is a float, you can use replace() directly.
When I use it occasionally, it is a specification that I have forgotten.
import pandas as pd # Sample data sample_list = {'sampleA':["1,000","2,000","3,000"], 'sampleB':["4,000","5,000","6,000"]} # Create dataframe df = pd.DataFrame(sample_list) print(df) """ sampleA sampleB 0 1,000 4,000 1 2,000 5,000 2 3,000 6,000 """ # Comfirm data type print(type(df['sampleA'][0])) """ <class 'str'> """ # If the data type is str, you can use '.str' accessor df['sampleA'] = df['sampleA'].str.replace(',','').astype(float) print(df) """ sampleA sampleB 0 1000.0 4,000 1 2000.0 5,000 2 3000.0 6,000 """ # If the data type is float, you can use replace function directly df['sampleA'] = df['sampleA'].replace(1000, 0) print(df) """ sampleA sampleB 0 0.0 4,000 1 2000.0 5,000 2 3000.0 6,000 """