teradataml_quickstart_dataframe_creation_and_exploration.py

1import teradataml as tdml
2from teradataml import create_context, remove_context, DataFrame, load_example_data
3
4# 1. Establish a connection to Teradata Vantage
5# Replace placeholders with your actual connection details
6host = "YOUR_HOSTNAME"
7username = "YOUR_USERNAME"
8password = "YOUR_PASSWORD"
9
10con = create_context(host=host, username=username, password=password)
11
12# 2. Load example data (optional, used for demonstration)
13load_example_data("dataframe", "admissions_train")
14
15# 3. Create a teradataml DataFrame from an existing table
16df = DataFrame("admissions_train")
17
18# 4. Perform basic data exploration
19print("--- First 5 rows ---")
20print(df.head(5))
21
22print("\n--- Summary Statistics ---")
23print(df.describe())
24
25print("\n--- Column Names and Types ---")
26print(df.td_column_names_and_types)
27
28# 5. Clean up the connection
29remove_context()