Lesson 3 Rossman notebook

I am following lesson 3 rossman notebook. When I try to join the dataframes: joined and googletrends, I do not get a 0 for nan as mentioned in the notebook output of cell 18.

When I tried debugging the issue, I found that googletrends has a None category for the State field. This None category was generated because googletrends.file has Rossmann_DE as a category:
googletrend['State'] = googletrend.file.str.split('_',expand=True)[2]

I tried deleting the rows of googletrend with Rossmann_DE in googletrend.file but I am still getting missing values.

Problem fixed. I had the Date in googletrends messed up.