You can also use the DataFrame.from_table() function to create a teradataml DataFrame from an existing table or view in Vantage.
Example 1: Create a teradataml DataFrame
>>> df = DataFrame.from_table("sales") >>> df Feb Jan Mar Apr datetime accounts Alpha Co 210.0 200 215 250 04/01/2017 Blue Inc 90.0 50 95 101 04/01/2017 Yellow Inc 90.0 None None None 04/01/2017 Jones LLC 200.0 150 140 180 04/01/2017 Red Inc 200.0 150 140 None 04/01/2017 Orange Inc 210.0 None None 250 04/01/2017
Example 2: Create a teradataml DataFrame with 'index_label'
>>> df = DataFrame.from_table("sales", index_label="Feb") >>> df accounts Jan Mar Apr datetime Feb 90.0 Blue Inc 50 95 101 04/01/2017 210.0 Orange Inc None None 250 04/01/2017 200.0 Red Inc 150 140 None 04/01/2017 90.0 Yellow Inc None None None 04/01/2017 200.0 Jones LLC 150 140 180 04/01/2017 210.0 Alpha Co 200 215 250 04/01/2017