Ad

How To Insert White Spaces Between Certain Character Positions, Irrespective Of What The Character Is?

- 1 answer

The column is called df['Col1']. Where the number of characters within the column is equal to 10, I want to add 2 blank white spaces between the 5th and 6th character of each string, otherwise only add one space between the 5th and 6th character.

For example RPYHVBN56I becomes RPYHV__BN56I, and any strings with more or less characters only input one space, such as RPYHVBN56I00000 becomes RPYHV_BN56I00000

Ad

Answer

You can try:

df['Col1'] = df['Col1'].map(lambda s: s[:5] + ('  ' if len(s) == 10 else ' ') + s[5:])
Ad
source: stackoverflow.com
Ad