import pandas as pd ... df['売上高(百万)'] = pd.to_numeric(df['売上高(百万)'], errors='coerce') / 1000000 df['営業利益(百万)'] = pd.to_numeric(df['営業利益(百万)'], errors='coerce') / 1000000 df['経常利益(百万)'] = pd.to_numeric(df['経常利益(百万)'], errors='coerce') / 1000000 df['当期純利益(百万)'] = pd.to_numeric(df['当期純利益(百万)'], errors='coerce') / 1000000