hello all i’m trying to solve the sorting for multi-character. below is the couple for lines from the data.
data = pandas.read_csv('data.csv')
data
001@|@02@|@ABC@|@IND123
002@|@02@|@ABC@|@IND223
003@|@02@|@ABC@|@IND333
004@|@02@|@ABC@|@IND443
i am trying with the below code:
res = re.split('@|@',data)
print(res)
001@|@02@|@ABC@|@IND123
['001', '|', '02', '|', 'ABC', '|', 'IND123']
please suggest, thanks in advance
>Solution :
pd.read_csv('data.csv', header = None, sep='@\\|@', engine = 'python')
0 1 2 3
0 1 2 ABC IND123
1 2 2 ABC IND223
2 3 2 ABC IND333
3 4 2 ABC IND443