아미(아름다운미소)

df['a'] = df['a'].str.split('-to-SCP-', expand=True)[1].fillna(df['a'].str.split('--', expand=True)[0])import pandas as pd# 예시 DataFrame 생성data = { 'a': [None, 'x', None, 'y', None], 'b': ['group1', 'group1', 'group2', 'group2', 'group1'], 'c': ['banana', 'apple', 'orange', 'kiwi', 'avocado']}df = pd.DataFrame(data)# a 컬럼이 null인 경우에 대해 처리df['a'] = df.apply( lambda row: df[df['b'] == ..

df['a'] = df['a'].str.split('-to-SCP-', expand=True)[1].fillna(df['a'].str.split('--', expand=True)[0])df['a'] = df['a'].str.split('-to-SAP-', expand=True).get(1).combine_first(df['a'].str.split('--', expand=True).get(0))