!load_remote_mapping_file.py -k 0AvglGXLayhG7dDNCWnUwSHhWNmxKODZISWx6VzBqU0E -o map1.tsv

from qiime.parse import parse_mapping_file_to_dict

qmap, comment_lines = parse_mapping_file_to_dict(open('map1.tsv'))

qmap.keys()

qmap['Stillton4R2']

qmap['Stillton4R2']['Latitude']

import pandas as pd

pmap = pd.read_csv('map1.tsv', sep='\t', index_col=0)

pmap['Latitude']['Stillton4R2']

pmap_t = pmap.transpose()
pmap_t['Stillton4R2']['Latitude']

pmap['Latitude']['Stillton4R2']

pmap['sample_pH'].median()

pmap.plot('estimated_elevation', 'sample_pH')

pmap.hist('sample_pH')

pmap.count()

pmap['estimated_years_since_submerged']['Stillton9R3']

pmap['gps_elevation']['Stillton9R3']

pmap = pmap.replace('no_data',nan)

pmap['gps_elevation']['Stillton9R3']

pmap