Ad
How To Insert White Spaces Between Certain Character Positions, Irrespective Of What The Character Is?
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
Related Questions
- → What are the pluses/minuses of different ways to configure GPIOs on the Beaglebone Black?
- → Django, code inside <script> tag doesn't work in a template
- → React - Django webpack config with dynamic 'output'
- → GAE Python app - Does URL matter for SEO?
- → Put a Rendered Django Template in Json along with some other items
- → session disappears when request is sent from fetch
- → Python Shopify API output formatted datetime string in django template
- → Can't turn off Javascript using Selenium
- → WebDriver click() vs JavaScript click()
- → Shopify app: adding a new shipping address via webhook
- → Shopify + Python library: how to create new shipping address
- → shopify python api: how do add new assets to published theme?
- → Access 'HTTP_X_SHOPIFY_SHOP_API_CALL_LIMIT' with Python Shopify Module
Ad