这是你的解决方案。我用一个示例csv文件测试了这个问题，如下所示：

sizes_in_string
1.0 MB
2.10 MB
12 GB
1.2 GB
1.232 GB
2 KB
2.1 MB

下面是如何将sizes in string列转换为数字：

import pandas as pd
import re 

# This method will convert the size strings into bytes as float
def convert_to_bytes(size_str):
    size_str = size_str.lower()
    units = {'kb': 1024, 'mb': 1024 ** 2, 'gb': 1024 ** 3, 'tb': 1024 ** 4}
    
    for unit, multiplier in units.items():
        if unit in size_str:
            return int(float(size_str.replace(unit, '').strip()) * multiplier)
    
    return float(re.sub(r'[^\d]', '', size_str))

# Read CSV file into a DataFrame
df = pd.read_csv('sizes.csv')

# Apply size conversion to the 'size' column
df['size_in_bytes'] = df['sizes_in_string'].apply(convert_to_bytes)

print(df)

输出量：

sizes_in_string  size_in_bytes
0          1.0 MB        1048576
1         2.10 MB        2202009
2           12 GB    12884901888
3          1.2 GB     1288490188
4        1.232 GB     1322849927
5            2 KB           2048
6          2.1 MB        2202009