AttributeError: ‘Series’ object has no attribute ‘split’ error in sending emails

Let’s try str.split and str.join:

import pandas as pd

df = pd.DataFrame({'SENDFROM': {0: '[email protected]', 1: '[email protected]'},
                   'Test': {0: '[email protected];[email protected];[email protected]',
                            1: '[email protected];[email protected];[email protected]'}})

# Use str.split and str.join and astype
df['Test'] = df['Test'].str.split(';').str.join(',')

print(df.to_string())

Output:

       SENDFROM                                        Test
0  [email protected]  [email protected],[email protected],[email protected]
1    [email protected]       [email protected],[email protected],[email protected]