Solve using REGEXP_REPLACE and REGEXP_EXTRACT in PySpark

Показать описание

Hello Geeks,

data=[(1,"Sagar-Prajapati"),(2,"Alex-John"),(3,"John Cena"),(4,"Kim Joe")]
schema="ID int,Name string"

If you want to build projects on Azure and Databricks, then check out the below courses

1. Delta-Lake using Databricks:

2. Azure Course:

3. Master in Python:

4. Git and Linux:

Join my telegram group
Telegram:

Follow me on Linkedin:

#interviewquestion #pysparkinterview

GeekCoders
Geekcoders
Sagarprajapati
Freecontent
Azure
Dataengineer

Рекомендации по теме

Комментарии

from pyspark.sql.functions import *
df1 = df.withColumn("FirstName", regexp_extract(col("Name"), r"(\w+)-? ?(\w+)", 1))\
.withColumn("LastName", regexp_extract(col("Name"), r"(\w+)-? ?(\w+)", 2))

df1.show()

Can we write like this?

ngozvze

Solve using REGEXP_REPLACE and REGEXP_EXTRACT in PySpark

Learn Regular Expressions In 20 Minutes

REGEX (REGULAR EXPRESSIONS) WITH EXAMPLES IN DETAIL | Regex Tutorial

Advanced SQL: REPLACE special characters in PHONE and check validity of data using REGEXP

How to Extract & Replace content with REGEX (Regular Expression)

Learn Regular Expressions (Regex) - Crash Course for Beginners

How to replace a pattern with other string in Python using RegEx #shorts

Regular Expression - Capture Text B/W Words |Uipath ExpoHub

Learn How to Replace Words using Regular Expression or RegEx | Uipath ExpoHub

automatically replace old with model statement using regular expressions (regex) in VSCode

JMeter Beginner Tutorial 21 - Correlation (with Regular Expression Extractor)

Regular Expressions in Python

C++ Regular Expression RegEx Replace by manual pattern

Regex Find and Replace - The Date Problem

String Operation |Regular Expression | Split String |Substring |Replace|Automation Anywhere A2019#14

Advanced String Searching including RegEx (Pandas Tutorials 06)

Regular Expression (RegEx)- Find Phone Number Exercise

UiPath Tutorial 32-Extract Invoice data from files with Matches Activity | Build Regex to Find Email

[5 Minute Tutorial] Regular Expressions (Regex) in Python

Python Regex: How To Split a String On Multiple Characters

Using Regular Expressions in SAS | Find and Replace a Pattern | PRXCHANGE

3. Solve using Regex using PySpark | Top 10 PySpark Scenario Based Interview Question|

Regular Expressions in Python | Python Tutorial - Day #95

string replace() with regEx - JavaScript | #shorts

Tosca Tutorial | Regex | Extracting Text | Tough Cookie Monster | Cookie Handling