select() Method Requires Unique Column Names | Teradata Python Package - select() Method Requires Unique Column Names - Teradata Package for Python

Teradata® Package for Python User Guide

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Package for Python
Release Number
20.00
Publication Date
March 2025
Content Type
User Guide
Publication ID
B700-4006-200K
ft:locale
en-US
ft:lastEdition
2026-08-13
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
ft:sourceId
dita
dita:id
rkb1531260709148
Product Category
Teradata Vantage

The select method does not handle identical column names being passed as arguments.

For example:

>>> df = DataFrame('table1')
>>> df.select(['col1', 'col1'])

To work around, use the assign method to provide an alias.

# c1 and c2 both refer to the col1 column
>>> df.assign(c1 = df.col1, c2 = df.col1)