Nov-12-2020, 02:31 PM
Hi,
I have below data frame (multiple rows): I want to split rows at dilimiter to columns
My desiredoutpur:
I have below data frame (multiple rows): I want to split rows at dilimiter to columns
df_obj: 20;12;AA;2020/11/05 10:23:13;2020/11/05 10:25:13;12;LL 20;12;PT;2020/11/05 11:18:13;2020/11/05 11:23:43;34;KLY 20;12;BN;2020/11/09 11:18:13;2020/11/05 11:23:73;4;KMLY 34;2;DG;2020/11/11 11:18:13;2020/11/11 11:23:73;4;KYI want to split each row at ";" into columns
My desiredoutpur:
df_out: 20 12 AA 2020/11/05 10:23:13 2020/11/05 10:25:13 12 LL 20 12 PT;2020/11/05 11:18:13 2020/11/05 11:23:43 34 KLY 20 12 BN 2020/11/09 11:18:13 2020/11/05 11:23:73 4 KMLY 34 2 DG 2020/11/11 11:18:13 2020/11/11 11:23:73 4 KYI use the below line. It gives the "data frame object has no attribute split".
df_obj.split(";")any method to split data frame object rows.