[Pandas] 将某栏位中的值全小写/大写

导入数据

import pandas as pd
 
df = pd.DataFrame([['liver','E',89,21],
                   ['Arry','C',36,37],
                   ['Ack','A',57,60],
                   ['Eorge','C',93,96],
                   ['Oah','D',65,49]
                  ], 
                   columns = ['name','team','Q1','Q2'])

df

将df表中的name字段中的值全大写

df['name'] = df['name'].str.upper()

处理过后的df

将df表中的name字段中的值全小写 

df['name'] = df['name'].str.lower()

处理过后的df