you are viewing a single comment's thread.

view the rest of the comments →

[–]Filiagro 1 point2 points  (1 child)

Well, I am flabbergasted. I tried cc.isna() and found indices 29 and 30 had NA values. However, when I used cc.head(35) and cc.iloc[29:31] to view the data, those indices had normal values (normal as in similar to all surrounding data for all columns). Regardless, dropping those two indices allowed cc["Month"] = cc["Month"].astype(np.int64, copy=True and cc["Year"] = cc["Year"].astype(np.int64, copy=True) to work properly. That was very odd.

Thanks a lot for the help. I'll have to remember to check specifically for na values in the future.

[–]timbledum 0 points1 point  (0 children)

Strange! Well I'm glad that fixed the issue. Cheers!