Breaking News: Grepper is joining You.com. Read the official announcement!

get value numeric value and created new column pyspark

Jon Oliveira answered on September 8, 2022 Popularity 1/10 Helpfulness 3/10

answer get value numeric value and created new column pyspark

get value numeric value and created new column pyspark

Comment

from pyspark.sql import functions as F
df.withColumn("product1_num", F.regexp_extract("productname", "([0-9]+)",1)).show()

+------+-------------------+------------+
|    id|        productname|product1_num|
+------+-------------------+------------+
|234832|EXTREME BERRY SAUCE|            |
|419836|  BLUE KOSHER SAUCE|            |
|350022|         GUAVA (1G)|           1|
|123213|           GUAVA G5|           5|
|125513|           3GULA G5|           3|
|127143|          GUAVA G50|          50|
|124513|         LAAVA C2L5|           2|
+------+-------------------+------------+

Popularity 1/10 Helpfulness 3/10 Language whatever

Source: stackoverflow.com

Tags: get numeric pyspark whatever

Link to this answer
Share Copy Link