extract characters

extract character only

 

1)

 df['state'] = df['raw'].str.extract('([A-Z]\w{0,})', expand=True)

https://chrisalbon.com/python/data_wrangling/pandas_regex_to_create_columns/

2)

df['movie_title'] = df['movie_title'].astype(str)

#but it remove numbers in names of movies too

df['titles'] = df['movie_title'].str.extract('([a-zA-Z ]+)', expand=False).str.strip()

df['titles1'] = df['movie_title'].str.split('(', 1).str[0].str.strip()

df['titles2'] = df['movie_title'].str.replace(r'\([^)]*\)', '').str.strip()

print df

 

https://stackoverflow.com/questions/36028932/how-to-extract-specific-content-in-a-pandas-dataframe-with-a-regex

How to extract specific content in a pandas dataframe with a regex?

3) korean only

 

(r'[^ ㄱ-ㅣ가-힣]+',"")

reference:

https://jokergt.tistory.com/52

[Python] 정규식을 사용하여 한글만 가져오기

https://www.fun-coding.org/DS&AL3-4.html

파이썬 라이브러리 기본: 정규표현식 - 잔재미코딩