df[['A', 'B']] = df['AB'].str.split('@', 1, expand=True) #'@' - Split at @ #1 = Axis 1 i.e on column level