如何小写数据框中除特定列之外的所有值

Question

我已经搜索了一段时间，但似乎找不到这个小问题的答案。

我有这段代码来为小写值创建一个函数：

df = {'name':['AL', 'EL', 'NAILA', 'DORI', 'KAKAEKA', 'GENTA', 'RUBY'],
      'living':['lagoa','sangiang','penjaringan','warakas','jonggol','cikarang', 'cikarang'],
      'food':['PIZZA','MEATBALL','CHICKEN','CAKE','CAKE','ONION','NOODLE'],
      'sub':['KOTA','KAB','WILAYAH','KAB','DAERAH','KOTA','WILAYAH'],
      'job':['Chef','Teacher','Police','Doctor','Students','Programmer','Lecturer'],
      'side_job':['Designer','Nurse','Designer','Programmer','Programmer','Teacher','Mentor'],
      'status':['Single','Single','Married','Single','Single','Divorced','Married'],
      'age':[20,25,20,18,25,40,37]
}

df = pd.DataFrame(df)

def content_consistent(df):
    cols = df.select_dtypes(object).columns
    df[cols] = df[cols].apply(lambda x: x.str.lower())
    return df

df = content_consistent(df)

结果显示所有值都是小写的，但我想要的是一些列不要像“sub”和“status”列一样小写

但我实际上期望这个输出简单的代码不使用循环

    name       living        food       sub      job        side_job    status     age
0   al         lagoa         pizza     KOTA      chef       designer    Single     20
1   el        sangiang      meatball    KAB     teacher     nurse       Single     25
2   naila    penjaringan    chicken   WILAYAH   police      designer    Married    20
3   dori       warakas       cake       KAB     doctor      programmer  Single     18
4   kakaeka    jonggol       cake      DAERAH   students    programmer  Single     25
5   genta     cikarang       onion      KOTA    programmer  teacher     Divorced   40
6   ruby      cikarang      noodle    WILAYAH   lecturer    mentor      Married    37

Answer 1

使用 Index.difference 用于按列表排除一些非数字列：

def content_consistent(df):
    cols = df.select_dtypes(object).columns.difference(['sub', 'status'])
    df[cols] = df[cols].apply(lambda x: x.str.lower())
    return df

Answer 2

您可以使用列表理解排除那些列，如下所述

df = pd.DataFrame(df)

def content_consistent(df):
    cols = df.select_dtypes(object).columns
    cols = [x for x in cols if x not in ['sub', 'status']]
    df[cols] = df[cols].apply(lambda x: x.str.lower())
    return df

df = content_consistent(df)

Answer 3

选择除 sub 和 Age 之外的列。将它们全部降低然后更新 df

df.update(df.filter(regex='[^subage]', axis=1).apply(lambda x:x.str.lower()))