I know similar questions have been asked already, but I haven't been able to get my answer from them. So here we go:
I have a dataset with timestamps that relate to the usage of a website (for example, person X started using Facebook at time x on day x.). The data is from the US, which covers different time zones. I have a state id (Basically, a state number (for example, Oklahoma = 37) and a time zone column (for example "US/Central"). I'd like to create a column with all timestamps converted to one time zone (for example, US Central, but it's irrelevant which one). how can I do that?
The timestamp is in this format: "2018-10-09 22:56:34"
Grateful for any hints.