CODEWITHSUNDEEP
pythonpandas
Pranab
Pranab

Reputation: 469

Insert space in Pandas Data Frame Column String for each character

I have a data frame look like below I need to give space between each letter of word in same column

import pandas as pd
df = pd.DataFrame({'sequence': ['ABCAD', 'DBAACR']})
df

Expected Output

sequence
A b C A D
D B A A C R

Upvotes: 2

Views: 1163

Answers (3)

usct01
usct01

Reputation: 898

You can use apply with lambda function to process columns in pandas data frame

df.sequence.apply(lambda x: ' '.join(list(x)))

Output:

0      A B C A D
1    D B A A C R

Upvotes: 1

user17112599
user17112599

Reputation: 

pd.DataFrame({'sequence':[' '.join('ABCAD'),' '.join('DBAACR')]})

Upvotes: 1

Rajesh Idumalla
Rajesh Idumalla

Reputation: 88

import pandas as pd
df = pd.DataFrame({'sequence':['ABCAD','DBAACR']})

A = []
for i in df['sequence']:
  a = (" ".join(i))
  A.append(a)

df = pd.DataFrame({'sequence':A})
df

If you execute above cell which will return the pandas DataFrame as below.

  sequence
0   A B C A D
1   D B A A C R

Thanks and don't forget to upvote :D

Upvotes: 4

Related Questions