I have this dataframe
| index | hour | minute | second | year | month | day |
|---|---|---|---|---|---|---|
| 0 | 0 | 0 | 0 | 2022 | 2 | 1 |
| 1 | 0 | 1 | 0 | 2022 | 2 | 1 |
| 2 | 0 | 2 | 0 | ... | ... | ... |
| 3 | 0 | 3 | 0 | ... | ... | ... |
| 4 | 0 | 4 | 0 | ... | ... | ... |
| 5 | 0 | 5 | 0 | ... | ... | ... |
| 6 | 0 | 6 | 0 | ... | ... | ... |
| 7 | 0 | 7 | 0 | ... | ... | ... |
| 8 | 0 | 8 | 0 | ... | ... | ... |
this table contains 100.000 rows
How can I create a new column that is having the full datetime using the columns that I wrote. What I mean is that I want a new column with the formation year-month-day hour-minutes-seconds