首页 > 解决方案 > 如何从 Python Pandas 字符串中解析一个字符?

问题描述

我有一个数据框,想将第 9 个字符解析为第二列。不过,我在某处缺少语法。

#develop the data
df = pd.DataFrame(columns = ["vin"], data = ['LHJLC79U58B001633','SZC84294845693987','LFGTCKPA665700387','L8YTCKPV49Y010001',
                                             'LJ4TCBPV27Y010217','LFGTCKPM481006270','LFGTCKPM581004253','LTBPN8J00DC003107',
                                             '1A9LPEER3FC596536','1A9LREAR5FC596814','1A9LKEER2GC596611','1A9L0EAH9C596099',
                                             '22A000018'])

df['manufacturer'] = ['A','A','A','A','B','B','B','B','B','C','C','D','D']

def check_digit(df):
    df['check_digit'] = df['vin'][8]
    print(df['checkdigit'])]

出于某种原因,这会将第 8 行 VIN 放在每一行中。

标签: python-3.xpandas

解决方案


正确的方法是:

def check_digit(df):
   df['check_digit'] = df['vin'].str[8]
   print(df)

推荐阅读