Use the itertuples() method to iterate over teradataml DataFrame rows as namedtuples.
This method returns iterator, an object to iterate over namedtuples for each row in the DataFrame.
Optional Parameters
- name
- Specifies the name of the returned namedtuples.
When set to None, the method returns the row in a list instead of namedtuple.
The default value is 'Row'.
- num_rows
- Specifies the number of rows to retrieve from the DataFrame.
When set to None, the method retrieves all the records. This is the default value.
Example 1: Retrieve all records from a teradataml DataFrame
>>> df = DataFrame("titanic")
>>> rows = df.itertuples()
>>> next(rows) Row(passenger=78, survived=0, pclass=3, name='Moutal Mr. Rahamin Haim', gender='male', age=None, sibsp=0, parch=0, ticket='374746', fare=8.05, cabin=None, embarked='S')
>>> next(rows) Row(passenger=93, survived=0, pclass=1, name='Chaffee Mr. Herbert Fuller', gender='male', age=46, sibsp=1, parch=0, ticket='W.E.P. 5734', fare=61.175, cabin='E31', embarked='S')
>>> next(rows) Row(passenger=5, survived=0, pclass=3, name='Allen Mr. William Henry', gender='male', age=35, sibsp=0, parch=0, ticket='373450', fare=8.05, cabin=None, embarked='S')
Example 2: Retrieve the first 20 records from a teradataml DataFrame in a list, when DataFrame is ordered
This example retrieves the first 20 records from a teradataml DataFrame in a list, when the DataFrame is ordered by column "passenger".
>>> df = DataFrame("titanic")
>>> rows = df.sort("passenger").itertuples(name=None, num_rows=20)
>>> next(rows) [1, 0, 3, 'Braund, Mr. Owen Harris', 'male', 22, 1, 0, 'A/5 21171', 7.25, None, 'S']
>>> next(rows) [2, 1, 1, 'Cumings, Mrs. John Bradley (Florence Briggs Thayer)', 'female', 38, 1, 0, 'PC 17599', 71.2833, 'C85', 'C']
>>> next(rows) [3, 1, 3, 'Heikkinen, Miss. Laina', 'female', 26, 0, 0, 'STON/O2. 3101282', 7.925, None, 'S']