How to extract specific digit from pandas column using regex?

@cali_green 

You can extract specific digit from a pandas column using the str.extract method with regex pattern. Here's an example to extract a single digit from a column:

1
2
3
4
5
6
7
8
9

import pandas as pd

# Create a sample DataFrame
data = {'column_name': ['abc123def', 'xyz456uvw', '123456789']}
df = pd.DataFrame(data)

# Extract a single digit from the column
df['extracted_digit'] = df['column_name'].str.extract(r'(d)')
print(df)

In this example, we are extracting a single digit from the column_name using the regex pattern (d), which matches any single digit. The extracted digit is then stored in a new column called extracted_digit. You can modify the regex pattern to extract different patterns based on your requirement.