[PYTHON/PANDAS] StringMethods 클래스 : upper/lower/title 메소드를 사용해 문자열 컬럼 값 대소문자 변경 신규 컬럼 추가하기

■ StringMethods 클래스의 upper/lower/title 메소드를 사용해 문자열 컬럼 값을 대소문자 변경한 신규 컬럼을 추가하는 방법을 보여준다.

▶ main.py


import pandas as pd

dataFrame = pd.DataFrame({"String" : ["John Smith", "Jane Cook"]})

stringMethods = dataFrame["String"].str

dataFrame["upper"] = stringMethods.upper()
dataFrame["lower"] = stringMethods.lower()
dataFrame["title"] = stringMethods.title()

print(dataFrame)

"""
       String       upper       lower       title
0  John Smith  JOHN SMITH  john smith  John Smith
1   Jane Cook   JANE COOK   jane cook   Jane Cook
"""

import pandas as pd

dataFrame = pd.DataFrame({"String" : ["John Smith", "Jane Cook"]})

stringMethods = dataFrame["String"].str

dataFrame["upper"] = stringMethods.upper()

dataFrame["lower"] = stringMethods.lower()

dataFrame["title"] = stringMethods.title()

print(dataFrame)

"""

String upper lower title

0 John Smith JOHN SMITH john smith John Smith

1 Jane Cook JANE COOK jane cook Jane Cook

"""

▶ requirements.txt


numpy==2.1.3
pandas==2.2.3
python-dateutil==2.9.0.post0
pytz==2024.2
six==1.16.0
tzdata==2024.2

numpy==2.1.3

pandas==2.2.3

python-dateutil==2.9.0.post0

pytz==2024.2

six==1.16.0

tzdata==2024.2

※ pip install pandas 명령을 실행했다.