在pandas数据帧中将度、分、秒(DMS)列转换为十进制度

import pandas as pd

# 创建示例数据帧
data = {'degrees': [45, 30, 60],
        'minutes': [30, 15, 45],
        'seconds': [0, 30, 15]}
df = pd.DataFrame(data)

# 定义转换函数
def dms_to_decimal(degrees, minutes, seconds):
    decimal_degrees = degrees + minutes/60 + seconds/3600
    return decimal_degrees

# 应用函数并创建新列
df['decimal_degrees'] = df.apply(lambda row: dms_to_decimal(row['degrees'], row['minutes'], row['seconds']), axis=1)

# 打印结果
print(df)

   degrees  minutes  seconds  decimal_degrees
0       45       30        0        45.500000
1       30       15       30        30.258333
2       60       45       15        60.754167