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

Teradata® Package for Python User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for Python
Release Number
20.00
Published
March 2024
Language
English (United States)
Last Update
2024-04-09
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
Product Category
Teradata Vantage
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