Sort, Slice & Wrangle Like A Pandas Boss

data_munge.py

import pandas as pd
import numpy as np
import random
from datetime import datetime as dt

t=pd.Timestamp
lu = pd.DataFrame({ 'name' : ['Bill','Elon','Larry','Jeff','Marissa'],
                    'feels' : ['charitable','Alcoa envy','Elon envy','like the number 7','sassy'],
                    'last ate' : [t('20151209'),t('20151201'),t('20151208'),t('20151208'),t('20151209')],
                    'boxers' : [True,True,True,False,True]})

af = pd.DataFrame({ 'name' : ['Bill','Elon','Larry','Elon','Jeff','Larry','Larry'],
                    'address' : ['in my computer','moon','internet','mars','cardboard box','autonomous car','every where'],
                    'sq_ft' : [2,2135,69,84535, 1.32, 54,168],
                    'forks' : [7,1,2,1,0,np.nan,1]})

rand_dates=[t('20141202'),t('20130804'),t('20120508'),t('20150411'),
            t('20141209'),t('20091023'),t('20130921'),t('20110102'),
            t('20130728'),t('20141119'),t('20151024'),t('20130824')]
                                        
df = pd.DataFrame({ 'name' : ['Elon','Bill','Larry','Elon','Jeff','Larry','Larry','Bill','Larry','Elon','Marissa','Jeff'],
                    'activity' : ['slept','tripped','spoke','swam','spooked','liked','whistled','up dog','smiled','donated','grant men paternity leave','fondled'],
                    'date' : rand_dates})