CODEWITHSUNDEEP
pandasdataframetext-extractiondata-extraction
venkatesh_Babu
venkatesh_Babu

Reputation: 61

need to all extract the content inside the brackets in pandas dataframe

I need to extract only the content inside the brackets in pandas dataframe. I tried using str.exratct() but its not working . I need help with the extraction

DATA: ( IS IN DATA FRAME, This is a sample data from one row )

By:Chen TX (Chen Tianxu)[ 1 ] ; Tribbitt MA (Tribbitt Mark A.)[ 2 ] ; Yang Y (Yang Yi)[ 3 ] ; Li XM (Li Xiaomei)[ 4 ]

Upvotes: 3

Views: 3186

Answers (1)

niraj
niraj

Reputation: 18208

You can use the regular expression:

import pandas as pd
import re

dataset = pd.DataFrame([{'DATA': 'By:Chen TX (Chen Tianxu)[ 1 ] ; Tribbitt MA (Tribbitt Mark A.)[ 2 ] ; Yang Y (Yang Yi)[ 3 ] ; Li XM (Li Xiaomei)[ 4 ]'}])
print(dataset)

Dataframe is:

   DATA
0  By:Chen TX (Chen Tianxu)[ 1 ] ; Tribbitt MA (Tribbitt Mark A.)[ 2 ] ; Yang Y (Yang Yi)[ 3 ] ; Li XM (Li Xiaomei)[ 4 ]

Then, using regular expression with lambda function, such that you extract names and save it to different column named names:

# regular expression from: https://stackoverflow.com/a/31343831/5916727
dataset['names'] = dataset['DATA'].apply(lambda x: re.findall('\((.*?)\)',x))
print(dataset['names'])

Output of names column would be:

0    [Chen Tianxu, Tribbitt Mark A., Yang Yi, Li Xiaomei]

Upvotes: 3

Related Questions