JavaScript
x
9
1
columnA columnB2
0 a1|a2|a3|a4|a5|a6|a7|a8|a9|a10 03
1 b1|b2|||||||| 84
2 c1|c2|c3||||||| 75
3 d1|d2|||||||| 86
4 e1|e2|||||||| 87
5 f1|f2|f3|f4|f5|f6|f7||| 38
6 g1|g2|g3|g4|||||| 69
i want the first line to remove 0 characters to the right, the second line to remove 8 characters to the right, The resulting data will have the following form
JavaScript
1
9
1
columnA columnB2
0 a1|a2|a3|a4|a5|a6|a7|a8|a9|a10 03
1 b1|b2 84
2 c1|c2|c3 75
3 d1|d2 86
4 e1|e2 87
5 f1|f2|f3|f4|f5|f6|f7 38
6 g1|g2|g3|g4 69
Thank you very much everyone. I am a newbie and my English is not very good. Hope everyone can help me
Advertisement
Answer
You can use Pandas’ string methods on column 'columnA'
rstrip
JavaScript
1
11
11
1
df.columnA.str.rstrip('|')2
3
0 a1|a2|a3|a4|a5|a6|a7|a8|a9|a104
1 b1|b25
2 c1|c2|c36
3 d1|d27
4 e1|e28
5 f1|f2|f3|f4|f5|f6|f79
6 g1|g2|g3|g410
Name: columnA, dtype: object11
Not altering df
JavaScript
1
11
11
1
df.assign(columnA=df.columnA.str.rstrip('|'))2
3
columnA columnB4
0 a1|a2|a3|a4|a5|a6|a7|a8|a9|a10 05
1 b1|b2 86
2 c1|c2|c3 77
3 d1|d2 88
4 e1|e2 89
5 f1|f2|f3|f4|f5|f6|f7 310
6 g1|g2|g3|g4 611
overwriting df
JavaScript
1
12
12
1
df['columnA'] = df.columnA.str.rstrip('|')2
df3
4
columnA columnB5
0 a1|a2|a3|a4|a5|a6|a7|a8|a9|a10 06
1 b1|b2 87
2 c1|c2|c3 78
3 d1|d2 89
4 e1|e2 810
5 f1|f2|f3|f4|f5|f6|f7 311
6 g1|g2|g3|g4 612