Hands-On Exploratory Data Analysis with Python

Refactoring timezones

Next, we want to refactor the timezone based on our timezone:

1. We can refactor timezones by using the method given here:

import datetime import pytzdef refactor_timezone(x):  est = pytz.timezone('US/Eastern')  return x.astimezone(est)

Note that in the preceding code, I converted the timezone into the US/Eastern timezone. You can choose whatever timezone you like.

2. Now that our function is created, let's call it:

dfs['date'] = dfs['date'].apply(lambda x: refactor_timezone(x))

3. Next, we want to convert the day of the week variable into the name of the day, as in, Saturday, Sunday, and so on. We can do that as shown here:

dfs['dayofweek'] = dfs['date'].apply(lambda x: x.weekday_name)dfs['dayofweek'] = pd.Categorical(dfs['dayofweek'], ...