[Pandas] 字段栏位名全小写

美图欣赏2022/06/16

---

import pandas as pd
 
df = pd.DataFrame([['A','Atest',123],
                   ['B','Btest',456],
                   ['C','Ctest',789]
                  ],columns=['Site','Test','Price'])
# 将df上的字段名称全小写
df.rename(columns=lambda x: str.lower(x), inplace=True)

df

处理后的df(字段栏位名全小写)

扩展

1.DataFrame和Series的列名类型是'Str'字符串类型

import pandas as pd
 
df = pd.DataFrame([['A','Atest',123],
                   ['B','Btest',456],
                   ['C','Ctest',789]
                  ],columns=['Site','Test','Price'])

# ['Site', 'Id', 'Price']
res = df.columns.tolist()

# DataFrame、Series中的列名类型为"Str"
print(type(res[0])) # <class 'str'>
print(type(res[1])) # <class 'str'>
print(type(res[2])) # <class 'str'>

2. 字段栏位名全大写处理

import pandas as pd
 
df = pd.DataFrame([['A','Atest',123],
                   ['B','Btest',456],
                   ['C','Ctest',789]
                  ],columns=['Site','Test','Price'])

# 将df上的字段名称全大写
df.rename(columns=lambda x: str.upper(x), inplace=True)