使用pandas将字符串列转换为小数纬度和经度，跳过NaN值

import pandas as pd

data = {'Location': ['40.7128° N', '74.0060° W', 'NaN', '37.7749° N', '122.4194° W']}
df = pd.DataFrame(data)

def convert_to_decimal(coord):
    if coord != 'NaN':
        degrees, minutes, direction = coord.split('° ')
        degrees = float(degrees)
        minutes = float(minutes[:-2])
        decimal = degrees + minutes / 60
        if direction == 'S' or direction == 'W':
            decimal = -decimal
        return decimal
    else:
        return float('NaN')

df['Latitude'] = df['Location'].apply(lambda x: convert_to_decimal(x.split()[0]))
df['Longitude'] = df['Location'].apply(lambda x: convert_to_decimal(x.split()[1]))