PySpark code

>>> df[df.accounts.rlike('Inc$')]
+-------------+-------+-------+-------+------+------------+
| accounts    | Feb   | Jan   | Mar   | Apr  | datetime   |
+-------------+-------+-------+-------+------+------------+
| Orange Inc  | 210.0 | None  | None  | 250  | 04/01/2017 |
| Blue Inc    | 90.0  | 50    | 95    | 101  | 04/01/2017 |
| Yellow Inc  | 90.0  | None  | None  | None | 04/01/2017 |
| Red Inc     | 200.0 | 150   | 140   | None | 04/01/2017 |
+-------------+-------+-------+-------+------+------------+

teradatamlspk code

>>> df[df.accounts.rlike('.*Inc$')]
+-------------+-------+-------+-------+------+------------+
| accounts    | Feb   | Jan   | Mar   | Apr  | datetime   |
+-------------+-------+-------+-------+------+------------+
| Orange Inc  | 210.0 | None  | None  | 250  | 04/01/2017 |
| Blue Inc    | 90.0  | 50    | 95    | 101  | 04/01/2017 |
| Yellow Inc  | 90.0  | None  | None  | None | 04/01/2017 |
| Red Inc     | 200.0 | 150   | 140   | None | 04/01/2017 |
+-------------+-------+-------+-------+------+------------+