Teradata Package for Python Function Reference | 20.00 - parse_url - Teradata Package for Python - Look here for syntax, methods and examples for the functions included in the Teradata Package for Python.
Teradata® Package for Python Function Reference - 20.00
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Teradata Package for Python
- Release Number
- 20.00.00.03
- Published
- December 2024
- ft:locale
- en-US
- ft:lastEdition
- 2024-12-19
- dita:id
- TeradataPython_FxRef_Enterprise_2000
- lifecycle
- latest
- Product Category
- Teradata Vantage
- teradataml.dataframe.sql.DataFrameColumn.parse_url = parse_url(self, url_part)
- DESCRIPTION:
Extracts a specific part from the URL.
PARAMETERS:
url_part:
Required Argument.
Specifies which part to be extracted.
Permitted Values: HOST, PATH, QUERY, REF, PROTOCOL, FILE, AUTHORITY, USERINFO
Type: str or ColumnExpression
Returns:
ColumnExpression
EXAMPLES:
# Load the data to run the example.
>>> load_example_data("teradataml", "url_data")
# Create a DataFrame on 'url_data' table.
>>> df = DataFrame("url_data")
>>> df
urls part
id
3 https://www.facebook.com HOST
6 smtp://user:password@smtp.example.com:21/file.txt USERINFO
4 https://teracloud-pod-services-pod-account-service.dummyvalu QUERY
2 https://example.net/path4/path5/path6?query4=value4#fragment REF
0 http://example.com:8080/path FILE
1 ftp://example.net:21/path PATH
5 http://pg.example.ml/path150#fragment90 AUTHORITY
7 https://www.google.com PROTOCOL
# Example 1: Extract components from column 'urls' using column 'part'
>>> df.assign(col = df.urls.parse_url(df.part))
urls part col
id
3 https://www.facebook.com HOST www.facebook.com
6 smtp://user:password@smtp.example.com:21/file.txt USERINFO user:password
4 https://teracloud-pod-services-pod-account-service.dummyvalu QUERY None
2 https://example.net/path4/path5/path6?query4=value4#fragment REF fragment
0 http://example.com:8080/path FILE /path
1 ftp://example.net:21/path PATH /path
5 http://pg.example.ml/path150#fragment90 AUTHORITY pg.example.ml
7 https://www.google.com PROTOCOL https
>>>