extracting date using regex from the cell in pandas dataframe

Question

I have a following dataframe

column 1   Description                          Extracted Data
date       January 15,2020 is important day

I want to get following result

column 1   Description                          Extracted Data
date       January 15,2020 is important day     January 15,2020

df.loc[df['column 1']=='date','Extracted Data']=df['Description'].str.extract(r'((January)|[/. ])|(\d{1,2}|[/., ]|\d{4})')

but I ma not getting desired result.Instead, i ma getting dataframe with all NaN values. How can I fix this?

check out this

Shubham Shaswat
– Shubham Shaswat

2020-02-11 07:09:38 +00:00
Commented Feb 11, 2020 at 7:09 — Shubham Shaswat
– Shubham Shaswat, Commented Feb 11, 2020 at 7:09

Zaraki Kenpachi · Accepted Answer · 2020-02-11 07:11:48Z

1

Use multi dot .* and digits.

import pandas as pd

df = pd.DataFrame({'column 1': ['date'], 'Description': ['January 15,2020 is important day']})
df['Extracted Data'] = df['Description'].str.extract(r'(.*,\d{4})')

Output:

  column 1                       Description   Extracted Data
0     date  January 15,2020 is important day  January 15,2020

answered Feb 11, 2020 at 7:11

Zaraki Kenpachi

5,7702 gold badges17 silver badges40 bronze badges

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

Comments

Strange · Accepted Answer · 2020-02-11 07:12:35Z

1

This works:(Oneliner)

df['Extracted data'] = [re.match('[A-Za-z]+ \d{2},\d{4}',x)[0] for x in df['Description']]

output:

  column1                              Desc   Extracted data
0    date  January 15,2020 is important day  January 15,2020

Regex Link: https://regex101.com/r/ICDJCp/1

answered Feb 11, 2020 at 7:12

Strange

1,5141 gold badge9 silver badges19 bronze badges

Comments

Rahul Verma · Accepted Answer · 2020-02-11 07:23:21Z

0

import dateutil.parser as dparser
import pandas as pd

df = pd.DataFrame({'column 1': ['date'], 'Description': ['January 15,2020 is important day']})
df['Extracted Data'] = df['Description'].apply(lambda x: dparser.parse(x,fuzzy=True).strftime('%B %d %Y'))
print(df)
  column 1                       Description   Extracted Data
0     date  January 15,2020 is important day  January 15 2020

answered Feb 11, 2020 at 7:23

Rahul Verma

3,2262 gold badges15 silver badges29 bronze badges

Collectives™ on Stack Overflow

extracting date using regex from the cell in pandas dataframe

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related