Dataframe splitting in Python

Question

i Have a dataframe DF , and column name DETAILS, i want the value which are in double quotes (""), will make new column VALUE

DF=

      DETAILS                      
   Username as "JOHN"           
   verifying the name             
   click UserBox                  
   Password as "345678"          
   Click login                   
   click checkbox                 
   Phonenumber as "34512345"     
   Checking data

I want my data frame look like this

DF=

     DETAILS                      VALUE
   Username as "JOHN"           "JOHN"
   verifying the name             NA
   click UserBox                  NA
   Password as "345678"          "3345678"
   Click login                    NA
   click checkbox                 NA
   Phonenumber as "34512345"     "34512345"
   Checking data                 NA

Serge Ballesta · Accepted Answer · 2022-02-08 09:25:15Z

2

The str accessor has an extract method for that kind of use case:

DF['VALUE'] = DF['DETAILS'].str.extract('(".*?")')

With your data, it gives as expected:

                     DETAILS       VALUE
0         Username as "JOHN"      "JOHN"
1         verifying the name         NaN
2              click UserBox         NaN
3       Password as "345678"    "345678"
4                Click login         NaN
5             click checkbox         NaN
6  Phonenumber as "34512345"  "34512345"
7              Checking data         NaN

answered Feb 8, 2022 at 9:25

Serge Ballesta

150k13 gold badges137 silver badges267 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Flavio · Accepted Answer · 2022-02-08 09:51:33Z

0

Here you go:

df['VALUE'] = df.apply(
    lambda x: '"' + x['DETAILS'].split('"')[1] + '"' 
                if len(x['DETAILS'].split('"')) > 1 
                else 'NA',
    1)

This will output:

                     DETAILS       VALUE
0         Username as "JOHN"      "JOHN"
1         verifying the name          NA
2              click UserBox          NA
3       Password as "345678"    "345678"
4                Click login          NA
5             click checkbox          NA
6  Phonenumber as "34512345"  "34512345"
7              Checking data          NA

with the column VALUES containing your values where present, else NA.

edited Feb 8, 2022 at 9:51

answered Feb 8, 2022 at 9:10

Flavio

1316 bronze badges

Collectives™ on Stack Overflow

Dataframe splitting in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related