{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [], "source": [ "from pandas import DataFrame" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [], "source": [ "# JSON (JavaScript Object Notation) のサンプル。\n", "json_obj = \"\"\"\n", "{ \"zoo_animal\": \"Lion\",\n", " \"food\": [\"Meat\", \"Veggies\", \"Honey\"],\n", " \"fur\": \"Golden\",\n", " \"clothes\": null, \n", " \"diet\": [{\"zoo_animal\": \"Gazelle\", \"food\":\"grass\", \"fur\": \"Brown\"}]\n", "}\n", "\"\"\"" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [], "source": [ "# jsonモジュールをimport\n", "import json\n", "# JSON形式の文字列から、オブジェクトを作ります。\n", "data = json.loads(json_obj)" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "{'clothes': None,\n", " 'diet': [{'food': 'grass', 'fur': 'Brown', 'zoo_animal': 'Gazelle'}],\n", " 'food': ['Meat', 'Veggies', 'Honey'],\n", " 'fur': 'Golden',\n", " 'zoo_animal': 'Lion'}" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "[{'food': 'grass', 'fur': 'Brown', 'zoo_animal': 'Gazelle'}]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data['diet']" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "'{\"diet\": [{\"fur\": \"Brown\", \"zoo_animal\": \"Gazelle\", \"food\": \"grass\"}], \"fur\": \"Golden\", \"clothes\": null, \"zoo_animal\": \"Lion\", \"food\": [\"Meat\", \"Veggies\", \"Honey\"]}'" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# PythonのオブジェクトをJSON形式の文字列にすることもできます。\n", "json.dumps(data)" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false }, "outputs": [], "source": [ "# DataFrameと一緒にも使えます。\n", "dframe = DataFrame(data['diet'])" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | food | \n", "fur | \n", "zoo_animal | \n", "
---|---|---|---|
0 | \n", "grass | \n", "Brown | \n", "Gazelle | \n", "