# Just an idea

# Now we can put it in a pandas dataframe

converted_json = """[{"KEY3": "qux0", "KEY2": "baz0", "KEY1": "bar0", "KEY0": "foo0", "POS": 5, "CHROM": "chr3"},
{"KEY3": "qux1", "KEY2": "baz1", "KEY1": "bar1", "KEY0": "foo1", "POS": 6, "CHROM": "chr12"},
{"KEY3": "qux2", "KEY2": "baz2", "KEY1": "bar2", "KEY0": "foo2", "POS": 9, "CHROM": "chr1"},
{"KEY3": "qux3", "KEY2": "baz3", "KEY1": "bar3", "KEY0": "foo3", "POS": 8, "CHROM": "chr12"},
{"KEY3": "qux4", "KEY2": "baz4", "KEY1": "bar4", "KEY0": "foo4", "POS": 3, "CHROM": "chrX"},
{"KEY3": "qux5", "KEY2": "baz5", "KEY1": "bar5", "KEY0": "foo5", "POS": 2, "CHROM": "chrX"},
{"KEY3": "qux6", "KEY2": "baz6", "KEY1": "bar6", "KEY0": "foo6", "POS": 10, "CHROM": "chr3"},
{"KEY3": "qux7", "KEY2": "baz7", "KEY1": "bar7", "KEY0": "foo7", "POS": 9, "CHROM": "chr1"},
{"KEY3": "qux8", "KEY2": "baz8", "KEY1": "bar8", "KEY0": "foo8", "POS": 0, "CHROM": "chr12"},
{"KEY3": "qux9", "KEY2": "baz9", "KEY1": "bar9", "KEY0": "foo9", "POS": 3, "CHROM": "chr3"},
{"KEY3": "qux10", "KEY2": "baz10", "KEY1": "bar10", "KEY0": "foo10", "POS": 8, "CHROM": "chr12"},
{"KEY3": "qux11", "KEY2": "baz11", "KEY1": "bar11", "KEY0": "foo11", "POS": 7, "CHROM": "chrX"},
{"KEY3": "qux12", "KEY2": "baz12", "KEY1": "bar12", "KEY0": "foo12", "POS": 6, "CHROM": "chrX"},
{"KEY3": "qux13", "KEY2": "baz13", "KEY1": "bar13", "KEY0": "foo13", "POS": 10, "CHROM": "chr12"},
{"KEY3": "qux14", "KEY2": "baz14", "KEY1": "bar14", "KEY0": "foo14", "POS": 3, "CHROM": "chrX"},
{"KEY3": "qux15", "KEY2": "baz15", "KEY1": "bar15", "KEY0": "foo15", "POS": 10, "CHROM": "chr3"},
{"KEY3": "qux16", "KEY2": "baz16", "KEY1": "bar16", "KEY0": "foo16", "POS": 2, "CHROM": "chr12"},
{"KEY3": "qux17", "KEY2": "baz17", "KEY1": "bar17", "KEY0": "foo17", "POS": 0, "CHROM": "chr1"},
{"KEY3": "qux18", "KEY2": "baz18", "KEY1": "bar18", "KEY0": "foo18", "POS": 6, "CHROM": "chr3"},
{"KEY3": "qux19", "KEY2": "baz19", "KEY1": "bar19", "KEY0": "foo19", "POS": 0, "CHROM": "chr3"}]"""

# faking file, so everything stays in the notebook
import cStringIO

json_input = cStringIO.StringIO()
json_input.write(converted_json)

import pandas as pd

df = pd.read_json(json_input.getvalue())

df.info()

# sort by KEY1
df.sort(columns="KEY1")

# view only chr1
df[df.CHROM=="chr1"]