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