Hi ,
I have very subjected data in one column . here goes the sample data
Ex:for first string I need union square
2nd string I need 7-Elven
3rd string I need JCPenncy.
In sql I can use case statement on that column
by using like operators ex: %Union Square%' ,%7-Elven%',%JCPenncy.%'
so output should be
Union square
7-Elven
JCPENNY...
Only merchants names I need and want to remove unwanted data.
Like that I have 800 rows with different merchants names
ex:as show below..
I have very subjected data in one column . here goes the sample data
Output:PURCHASE AUTHORIZED ON 09/28 UA UNION SQUARE 14 NEW YORK NY S388272071655085 CARD 0057
PURCHASE AUTHORIZED ON 09/28 7-ELEVEN 18594 ARVADA CO S588272206422481 CARD 7621
PURCHASE AUTHORIZED ON 09/30 JCPENNEY 1330 CORPUS CHRIST TX S468273721740671 CARD 8143
from that string I need only specific names.Ex:for first string I need union square
2nd string I need 7-Elven
3rd string I need JCPenncy.
In sql I can use case statement on that column
by using like operators ex: %Union Square%' ,%7-Elven%',%JCPenncy.%'
so output should be
Union square
7-Elven
JCPENNY...
Only merchants names I need and want to remove unwanted data.
Like that I have 800 rows with different merchants names
ex:as show below..
Output:RECURRING PAYMENT AUTHORIZED ON 09/30 Netflix.com netflix.com CA S308273592350001 CARD 9296
RECURRING PAYMENT AUTHORIZED ON 09/30 GOOGLE *YouTube Pr 855-836-3987 CA S588274040027644 CARD 8785
RECURRING PAYMENT AUTHORIZED ON 09/30 GEICO *AUTO 800-841-3000 DC S388273506944188 CARD 7336
RECURRING PAYMENT AUTHORIZED ON 09/30 FARMERS INS BILLIN 877-327-6392 CA S308273417047853 CARD 1421
I want to implement in python .Please can any one help in code .thank in advance .