python - 如何一次删除多个列的字符串中的第一个字符？

Question

我有 6 列是我想变成浮点数的对象(19.99 美元、25.99 美元等)(19.99、25.99 等)。我必须做的第一件事是删除所有这些列的第一个字符。我能够做到这一点。

df['Subtotal_'] = df['Subtotal'].str[1:]
df['Shipping Charge_'] = df['Shipping Charge_'].str[1:]
df['Tax Before Promotions_'] = df['Tax Before Promotions_'].str[1:]
df['Total Promotions_'] = df['Total Promotions_'].str[1:]
df['Tax Charged_'] = df['Tax Charged_'].str[1:]
df['Total Charged_'] = df['Total Charged_'].str[1:]

我想知道是否有办法一次完成所有这些。我试过这个，但它没有用，我得到了错误，“AttributeError: 'DataFrame' object has no attribute 'str'”。

df[['Subtotal_', 'Shipping Charge_', 'Tax Before Promotions_',
    'Total Promotions_', 'Tax Charged_', 'Total Charged_']] = df.loc[:, 'Subtotal':'Total Charged'].str[1:]

Answer 1

尝试这个:

cols = ('Subtotal_', 'Shipping Charge_', 'Tax Before Promotions_', 'Total Promotions_', 'Tax Charged_', 'Total Charged_')
for col in cols:
    df[col] = df[col].str[1:]