Coming into DataFrames, one of my biggest pain points was finding out where the NAN (Not A Number) or NAT (Not A Time) is in my plethora of data. I prefer not to drop these rows or ignore them during crucial calculations. Sometimes I may want to find out exactly where these values are so…

While Data Munging for my Weather Data Analysis blog, I skipped out a bunch of other valuable data which were all related converting to date_time. I managed to come across a solution today while playing with Pandas’ .apply() and .applymap() functions. Here’s how the raw data looked like prior human readable date time conversion. To…