[pandas] replace

문자열 바꾸기 방법

github

기초 data

    datas = pd.DataFrame({'col1': [' ab_c_d_e_', 'b: cd', 'cde_ '],
                          'col2': ['a', 'a', 'c'],
                          'col3': [1, 2, 3],
                          'mydate': [pd.to_datetime('20200402'),
                                     pd.to_datetime('20200501')-pd.DateOffset(days=5),
                                     pd.to_datetime('20200502')]
                          },

                         index=[0, 1, 2])

 

Replace 방식

def f_pandas_replace(datas:DataFrame):


    print(datas.info())

    print(datas['col1'].str)
    print(datas['col1'].str.replace('_', ''))
    print(datas['col1'].str.replace('_', '', 1)) # 앞쪽 부터 1번을 제거
    print(datas['col1'].str.replace('_', '', 2)) # 앞쪽 부터 2번을 제거
    print(datas['col1'].str.replace('_', '', 3)) # 앞쪽 부터 3번을 제거

    pass

 

출력문

<pandas.core.strings.StringMethods object at 0x000001E7FED8B7F0>
0     abcde
1     b: cd
2      cde 
Name: col1, dtype: object
0     abc_d_e_
1        b: cd
2         cde 
Name: col1, dtype: object
0     abcd_e_
1       b: cd
2        cde 
Name: col1, dtype: object
0     abcde_
1      b: cd
2       cde 
Name: col1, dtype: object

Process finished with exit code 0

 

참조

https://yuddomack.tistory.com/entry/%ED%8C%8C%EC%9D%B4%EC%8D%AC-replace-%EB%AC%B8%EC%9E%90%EC%97%B4-%EC%A0%9C%EA%B1%B0-%EC%88%98%EC%A0%95%EB%B3%80%ED%99%98