DataFrame.from_table() Function | Teradata Python Package - 17.00 - DataFrame.from_table() Function - Teradata Package for Python

Teradata® Package for Python User Guide

Product
Teradata Package for Python
Release Number
17.00
Release Date
November 2021
Content Type
User Guide
Publication ID
B700-4006-070K
Language
English (United States)
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