vDataFrame.regexp¶

In [ ]:

vDataFrame.regexp(column: str,
                  pattern: str,
                  method: str = "substr", 
                  position: int = 1,
                  occurrence: int = 1,
                  replacement: str = '',
                  return_position : int = 0,
                  name: str = "")

Computes a new vcolumn based on regular expressions.

Parameters¶

Name	Type	Optional	Description
column	str	❌	Input vcolumn to use to compute the regular expression.
pattern	str	❌	The regular expression.
method	str	✓	Method to use to compute the regular expressions. count : Returns the number times a regular expression matches each element of the input vcolumn. ilike : Returns True if the vcolumn element contains a match for the regular expression. instr : Returns the starting or ending position in a vcolumn element where a regular expression matches. like : Returns True if the vcolumn element matches the regular expression. not_ilike : Returns True if the vcolumn element does not match the case-insensitive regular expression. not_like : Returns True if the vcolumn element does not contain a match for the regular expression. replace : Replaces all occurrences of a substring that match a regular expression with another substring. substr : Returns the substring that matches a regular expression within a vcolumn.
position	int	✓	The number of characters from the start of the string where the function should start searching for matches.
occurrence	int	✓	Controls which occurrence of a pattern match in the string to return.
replacement	str	✓	The string to replace matched substrings.
return_position	int	✓	Sets the position within the string to return.
name	str	✓	New feature name. If empty, a name will be generated.

Returns¶

vDataFrame : self

Example¶

In [51]:

from verticapy import *
filmtv_movies = vDataFrame("filmtv_movies")
display(filmtv_movies)

	Abc Varchar(1048)	Abc Varchar(2218)	123 avg_vote Numeric(6,2)	Abc Varchar(486)	Abc Varchar(2232)	Abc genre Varchar(22)	Abc director Varchar(1066)	123 filmtv_id Int	123 duration Int	123 votes Int	123 year Numeric(8,2)	Abc country Varchar(208)
1			7.20			Comedy	Barry Levinson	18	95	15	1982.00	United States
2			7.80			Drama	Elio Petri	22	93	102	1967.00	Italy
3			6.50			Thriller	Ray Morrison (Angelo Dorigo)	24	80	3	1966.00	Italy
4			5.50			Adventure	Leon Klimovsky	30	101	2	1968.00	Italy
5			4.00			Comedy	Carol Wiseman	31	90	1	1990.00	United States
6			5.10			Drama	Joseph Ruben	32	96	107	1990.00	United States
7			8.00			Thriller	Brian Grant	33	100	2	1991.00	United States
8			5.90			Comedy	Marcello Fondato	37	100	42	1975.00	Italy
9			4.00			Drama	Vera Belmont	41	110	1	1985.00	France
10			8.00			Drama	Géza Beremenyi	42	110	1	1988.00	Hungary
11			6.00			Drama	Ian Sellar	46	88	1	1992.00	France, Great Britain
12			8.30			Drama	Sidney Lumet	49	110	68	1964.00	United States
13			7.00			Action	Liu Chia Yung	50	88	2	1990.00	United States, China
14			4.00			Adventure	Emilio Miraglia	53	94	6	1968.00	Italy
15			6.60			Comedy	Alan Metter	55	100	16	1986.00	United States
16			4.00			Comedy	Nico Mastorakis	56	89	1	1988.00	United States
17			7.10			Comedy	Bruce Beresford	58	100	171	1989.00	United States
18			4.00			Drama	Mark Rezyka	60	98	1	1987.00	Great Britain
19			7.00			Western	Sidney J. Furie	61	98	24	1966.00	United States
20			5.50			Crime	Mario Caiano	63	100	26	1975.00	Italy
21			4.00			Crime	Romolo Guerrieri	64	85	1	1991.00	Italy
22			4.00			Comedy	Les Rose	65	94	1	1981.00	Canada
23			6.00			Comedy	Gennaro Righelli	68	90	28	1945.00	Italy
24			6.00			Drama	Michael Miller	70	120	1	1986.00	United States
25			5.20			Adventure	Peter Yates	74	130	28	1977.00	United States
26			8.00			Drama	Milton Katselas	75	120	2	1979.00	United States
27			6.30			Biography	John Cromwell	77	110	9	1940.00	United States
28			3.50			Comedy	José Lopez Rubio, Primo Zeglio	82	88	3	1943.00	Italy, Spain
29			6.50			War	Georg Wilhelm Pabst	85	75	2	1955.00	Germany
30			6.50			Comedy	Andrew Marton	86	92	3	1962.00	United States
31			7.20			Comedy	William Dieterle	88	104	5	1950.00	United States
32			6.00			Comedy	Michael Schroeder	91	90	1	1988.00	United States
33			6.00			Comedy	James Frawley	93	97	1	1980.00	United States
34			4.50			Drama	Christine Allen	94	77	4	1987.00	France
35			8.00			Comedy	Gero Zambuto	96	68	1	1933.00	Italy
36			5.50			Drama	Nunzio Malasomma	100	80	3	1942.00	Italy
37			5.10			Crime	Craig R. Baxley	101	97	32	1988.00	United States
38			8.00			Drama	Koei Oguri	102	115	1	1990.00	Japan
39			4.00			Drama	Don Boyd	103	92	1	1977.00	Great Britain
40			6.50			Drama	Daniel Mann	107	109	5	1961.00	United States
41			5.00			Comedy	Mario Mattòli	108	90	7	1949.00	Italy
42			6.80			Comedy	Harold French	109	92	11	1949.00	Great Britain
43			6.70			War	Frank Borzage	111	78	16	1932.00	United States
44			6.00			Thriller	Jerrold Freedman	113	100	1	1990.00	United States
45			7.20			Drama	Ferdinando M. Poggioli	114	88	11	1940.00	Italy
46			6.00			Drama	William A. Wellman	115	95	3	1956.00	United States
47			4.00			Adventure	Jack Couffer	116	104	1	1969.00	Great Britain
48			7.30			Romantic	Sam Wood	117	114	23	1939.00	United States
49			8.30			Comedy	Anthony Asquith	118	90	14	1951.00	Great Britain
50			3.00			Drama	Roberto Bianchi Montero	119	86	2	1954.00	Italy
51			8.00			Drama	Daniel Mann	120	104	1	1954.00	United States
52			5.30			Comedy	Edouard Molinaro	122	108	10	1963.00	France
53			6.10			Comedy	Howard Zieff	123	100	14	1984.00	United States
54			6.00			Comedy	Fernandel	125	80	1	1943.00	France
55			6.00			Drama	Ingmar Bergman	127	93	16	1971.00	Sweden, United States
56			4.00			Drama	William Spier, Roy Kellino	128	82	1	1952.00	United States
57			5.50			Comedy	Pasquale Festa Campanile	129	95	33	1966.00	Italy
58			5.00			Comedy	Raffaello Matarazzo	130	90	4	1963.00	Italy
59			4.80			Spy	Raoul Levy	136	100	4	1966.00	United States
60			5.20			Comedy	Jim Abrahams	137	92	20	1988.00	United States
61			6.50			Crime	Mike Figgis	138	112	65	1990.00	United States
62			6.00			Drama	Sharron Miller	139	100	1	1988.00	United States
63			7.10			Comedy	Richard Quine	140	98	32	1962.00	United States
64			6.00			Drama	Lou Antonio	141	89	1	1991.00	United States
65			5.50			Adventure	Michele Lupo	145	95	20	1975.00	Italy
66			4.50			Adventure	Giovanni Roccardi	146	95	6	1952.00	Italy
67			7.30			Spy	Peter R. Hunt	153	140	145	1969.00	Great Britain
68			6.00			Spy	Guy Hamilton	155	122	107	1974.00	Great Britain
69			6.60			Spy	Lewis Gilbert	158	116	117	1967.00	Great Britain
70			7.00			Spy	Terence Young	159	132	130	1965.00	Great Britain
71			6.10			Spy	Guy Hamilton	162	122	116	1971.00	Great Britain
72			4.00			Spy	Maurice Labro	163	105	1	1964.00	France
73			3.90			Thriller	Louis King	164	75	5	1954.00	United States
74			3.20			Spy	Enrico Bomba	167	90	4	1965.00	Italy
75			3.80			Spy	Henry Bay	168	90	5	1966.00	Italy
76			4.70			Spy	David Greene	169	73	7	1972.00	Great Britain
77			4.00			Spy	Robert Vernay	171	97	1	1966.00	France
78			4.50			Spy	Claudio Guzman	172	108	2	1980.00	United States
79			6.90			Comedy	Charles Chaplin	173	42	13	1916.00	United States
80			5.30			Comedy	Anthony Harvey	174	102	10	1984.00	United States
81			4.00			Adventure	Gerardo Herrero	175	88	1	1988.00	Spain
82			4.90			Thriller	Riccardo Freda	176	88	6	1957.00	Italy
83			3.50			Crime	Andy Sidaris	178	96	5	1987.00	United States
84			5.00			Western	R. G. Springsteen	179	91	2	1967.00	United States
85			2.50			Adventure	Ivan Tors	180	91	2	1964.00	United States
86			4.50			Western	Jürgen Roland	181	86	2	1964.00	Germany
87			6.10			Drama	Norman Jewison	183	98	43	1985.00	United States
88			3.50			Fantasy	Aaron Lipstadt	185	78	2	1985.00	United States
89			5.40			Drama	Carlo Lizzani	186	95	9	1953.00	Italy
90			6.30			Comedy	Mario Mattòli	187	70	3	1939.00	Italy
91			6.00			Musical	Clemente Fracassi	188	97	7	1953.00	Italy
92			5.30			Adventure	Roger Spottiswoode	189	106	56	1990.00	United States
93			4.70			Action	Jerry Jameson	193	110	36	1977.00	United States
94			4.70			Comedy	Francis Schaeffer	194	100	8	1991.00	United States
95			4.00			Comedy	Burt Brickerhoff	196	60	1	1989.00	United States
96			4.40			Comedy	Luigi Filippo D'Amico	198	99	6	1961.00	Italy
97			5.10			Comedy	Francesco Massaro	199	100	103	1983.00	Italy
98			4.30			Thriller	Alessandro Lucidi	200	90	6	1992.00	Italy
99			6.50			Gangster	Richard Wilson	201	104	11	1959.00	United States
100			6.30			Drama	Daniel Taradash	202	87	9	1956.00	United States

Rows: 1-100 of 53397 | Columns: 12

In [52]:

# Retrieving the second actor
filmtv_movies.regexp(column = "actors", 
                     pattern = "[^,]+", 
                     method = "substr",
                     occurrence = 2,
                     name = "actor2").select(["actors", 
                                              "actor2"])

	Abc Varchar(2218)	Abc actor2 Varchar(2218)
1		Steve Guttenberg
2		Irene Papas
3		Mary Arden
4		Ennio Girolami
5		Stéphane Freiss
6		Patrick Bergin
7		Lenny Von Dohlen
8		Monica Vitti
9		Lambert Wilson
10		Judit Pogàny
11		Sandrine Bonnaire
12		Dan O'Herlihy
13		Mark Huston
14		Ira Fürstenberg
15		Keith Gordon
16		Gerald Okamura
17		Morgan Freeman
18		Lisa Blount
19		Anjanette Comer
20		Luciana Paluzzi
21		Massimiliano Pazzaglia
22		Howie Mandel
23		Nino Besozzi
24		Jason Bateman
25		Jacqueline Bisset
26		Gena Rowlands
27		Ruth Gordon
28		Germana Paolieri
29		Karl Ludwig Diehl
30		Trax Colton
31		Joseph Cotten
32		Perry Lang
33		Lisa Hartman
34		Marvin Sither
35		Andreina Pagnani
36		Mariella Lotti
37		Craig T. Nelson
38		Ittoku Kishibe
39		Judy Bowker
40		Dean Martin
41		Isa Barzizza
42		Jean Simmons
43		Helen Hayes
44		Margaret Colin
45		Adriano Rimoldi
46		Walter Brennan
47		Virgina McKenna
48		Greer Garson
49		Jean Kent
50		Tamara Lees
51		Robert Ryan
52		Brigitte Bardot
53		Nastassja Kinski
54		Paulette Dubost
55		Elliott Gould
56		June Havoc
57		Nino Manfredi
58		Luigi Giuliani
59		Hardy Krüger
60		Lily Tomlin
61		Andy Garcia
62		Frederic Forrest
63		Jack Lemmon
64		Nancy Everhard
65		Ursula Andress
66		Stephen Barclay
67		Diana Rigg
68		Christopher Lee
69		Akiko Wakabayashi
70		Claudine Auger
71		Jill St. John
72		Virna Lisi
73		Piper Laurie
74		Hélène Chanel
75		Mary Young
76		Robert Wagner
77		Christiane Minazzoli
78		Maud Adams
79		Albert Austin
80		Nick Nolte
81		Conrado Sanmartin
82		Geneviève Page
83		Hope Marie Carlton
84		Yvonne De Carlo
85		Robert Culp
86		Tony Kendall
87		Anne Bancroft
88		John Stockwell
89		Marina Berti
90		Vittorio De Sica
91		Lois Maxwell
92		Robert Downey jr.
93		James Stewart
94		Carol Kane
95		Ted Lange
96		Pierre Brice
97		Jerry Calà
98		Daniela Poggi
99		Rod Steiger
100		Brian Keith

Out[52]:

Rows: 1-100 of 53397 | Columns: 2

In [53]:

# Computing the Number of actors
filmtv_movies.regexp(column = "actors", 
                     pattern = ",", 
                     method = "count",
                     name = "nb_actors")
filmtv_movies["nb_actors"].add(1)
filmtv_movies.select(["actors", "nb_actors"])

	Abc Varchar(2218)	123 nb_actors Int
1		9
2		8
3		8
4		7
5		7
6		9
7		8
8		5
9		6
10		5
11		7
12		8
13		8
14		8
15		10
16		8
17		5
18		6
19		8
20		8
21		2
22		8
23		8
24		6
25		8
26		7
27		9
28		8
29		8
30		7
31		7
32		7
33		8
34		7
35		7
36		8
37		8
38		8
39		7
40		8
41		3
42		8
43		8
44		7
45		7
46		7
47		7
48		8
49		7
50		7
51		8
52		7
53		7
54		7
55		4
56		8
57		7
58		9
59		8
60		9
61		8
62		8
63		8
64		8
65		7
66		8
67		4
68		4
69		4
70		4
71		5
72		3
73		4
74		4
75		3
76		4
77		4
78		4
79		3
80		4
81		4
82		4
83		3
84		3
85		3
86		5
87		5
88		3
89		3
90		2
91		4
92		4
93		5
94		4
95		3
96		3
97		5
98		3
99		5
100		5

Out[53]:

Rows: 1-100 of 53397 | Columns: 2

vDataFrame.regexp¶

Parameters¶

Returns¶

Example¶

See Also¶