: : : : : : : : : : - - - - - - - the category field contains comma-separated list of codes indicating the type of messagein [ ]data['category'][: out[ ] urgences emergency public health urgences emergency urgences logistiques urgences logistiques vital lines autre urgences emergency urgences emergency communication lines downnamecategory if you notice above in the data summarysome of the categories are missingso we might want to drop these data points additionallycalling describe shows that there are some aberrant locationsin [ ]data describe(out[ ]serial latitude count mean std min max longitude - - - - - cleaning the bad locations and removing the missing categories is now fairly simplein [ ]data data[(data latitude (data latitude (data longitude - (data longitude - data category notnull()now we might want to do some analysis or visualization of this data by categorybut each category field may have multiple categories additionallyeach category is given as code plus an english and possibly also french code name thusa little bit of wrangling is required to get the data into more agreeable form firsti wrote these two functions to get list of all the categories and to split each category into code and an english namedef to_cat_list(catstr)stripped ( strip(for in catstr split(',')plotting mapsvisualizing haiti earthquake crisis data www it-ebooks info