How To Create Multiple Columns From Single Column using Pandas in Jupyter

1. import pandas as pd
2. import tensorflow as tf
3. from pandas import DataFrame
4. s = pd.read_excel('SaroojWork.xlsx')
5. s = s.BelowPMandatory.str.split(',', expand=True)
6. s.columns = ['A','B','C','D','E']
7. s[['A','A1']] = s.A.str.split(r'[',n=1, expand =True)
8. s['A1']= s['A1'].str.replace(']','')
9. 
   
10. s[['B','B1']] = s.B.str.split(r'[',n=1, expand =True)
11. s['B1']= s['B1'].str.replace(']','')
12. 
    
13. s[['C','C1']] = s.C.str.split(r'[',n=1, expand =True)
14. s['C1']= s['C1'].str.replace(']','')
15. 
    
16. s[['D','D1']] = s.D.str.split(r'[',n=1, expand =True)
17. s['D1']= s['D1'].str.replace(']','')
18. 
    
19. s[['E','E1']] = s.E.str.split(r'[',n=1, expand =True)
20. s['E1']= s['E1'].str.replace(']','')
21. cols = s.columns.tolist()
22. 
    
23. cols.insert(1, cols.pop(cols.index('A1')))
24. cols.insert(3, cols.pop(cols.index('B1')))
25. cols.insert(5, cols.pop(cols.index('C1')))
26. cols.insert(7, cols.pop(cols.index('D1')))
27. cols.insert(9, cols.pop(cols.index('E1')))
28. s = s.reindex(columns= cols)
29. 
    
30. writer = pd.ExcelWriter('BookSarooj.xlsx')
31. 
    
32. 
    
33. s.to_excel(writer,'Sheet1')
34. 
    
35. writer.save()