In [ ]:

    

from planet4 import get_data


    

In [ ]:

    

fname = get_data.get_current_database_fname()


    

In [ ]:

    

store= pd.HDFStore(fname)


    

In [ ]:

    

image_name = store.select_column('df','image_name')


    

In [ ]:

    

where=image_name[image_name.str.endswith('_0985')].index


    

In [ ]:

    

data = store.select('df', where=where)


    

In [ ]:

    

cleaned = data[~data.duplicated(subset='image_name')]


    

In [ ]:

    

times = pd.to_datetime(cleaned.acquisition_date)


    

In [ ]:

    

times.order()


    

In [ ]:

    

cleaned.columns


    

In [ ]:

    

year2 = pd.read_csv('/Users/maye/Dropbox/DDocuments/planet4/hireport_south_mars_zoo_v2/South_year_2-Table 1.csv')


    

In [ ]:

    

year2 = year2.dropna(how='all')


    

In [ ]:

    

year2.time = pd.to_datetime(year2.time)


    

In [ ]:

    

year2 = year2.drop(year2.filter(regex="Unnamed").columns, axis=1)


    

In [ ]:

    

year2['is_inca'] = year2.Comment.map(lambda x: True if 'INCA' in x.upper() else False)


    

In [ ]:

    

inca = year2[year2.is_inca]


    

In [ ]:

    

inca.Ls.describe()


    

In [ ]:

    

inca['ones']= 1


    

In [ ]:

    

inca = inca.set_index("Ls")


    

In [ ]:

    

%pylab inline


    

In [ ]:

    

inca.sort_index(inplace=True)


    

In [ ]:

    

inca.ones.plot(style='*')


    

In [ ]:

    

print inca.index


    

In [ ]:

    

inca.index.shape


    

In [ ]: