In the column ‘id’, I would like to split the string into every 6 digits and add a comma.
df = pd.pivot_table(df, values=['id'], index=['eu_crm'], aggfunc='sum')
df.loc[df[:, 1] for i in range(0, len(['id'], 6)
>Solution :
Code:
import pandas as pd
data = {'Column 1': ['a', 'b', 'c'],
'id': [2468938493843983, 345642232, 23343433]}
df = pd.DataFrame(data)
df['id'] = df['id'].astype(str)
df['fromleft'] = [','.join([df['id'][i][j:j+6] for j in range(0, len(df['id'][i]), 6)]) for i in range(len(df))]
print(df)
Output:
Column 1 id fromleft
0 a 2468938493843983 246893,849384,3983
1 b 345642232 345642,232
2 c 23343433 233434,33
