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.