get_dataframe_from_pairs.py

from ibmpairs import paw
import pandas as pd

PAIRS_SERVER      = "https://oxaihack2020.eu-gb.mybluemix.net"
PAIRS_USER        = ""
PAIRS_PASS        = ""
PAIRS_CREDENTIALS = ( PAIRS_USER, PAIRS_PASS )

query_json = {
    "layers" : [
        {"type" : "raster", "id" : "49443"}
    ],
    "spatial" : {"type" : "point",  "coordinates" : ["35.7", "139.7"]},
    "temporal" : {"intervals" : [
        {"start" : "2015-01-01T00:00:00Z", "end" : "2018-10-31T00:00:00Z"}
    ]}
}

query = paw.PAIRSQuery(query_json, PAIRS_SERVER, PAIRS_CREDENTIALS)
query.submit()

print(query)

pairs_data = pd.DataFrame(query.vdf)

print(pairs_data)

pairs_data.to_csv('data_1.csv')

# pd.DataFrame.to_csv(query.vdf, 'data.csv')