{ "metadata": { "name": "", "signature": "sha256:1c9c0d174dc331d2feb2d83313cdd1b55ff0be3459b17d693386fc33f646bd3b" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "**Read in JSON and DataFrame Basics**" ] }, { "cell_type": "code", "collapsed": false, "input": [ "# read population in\n", "import json\n", "import requests\n", "from pandas import DataFrame\n", "\n", "# pop_json_url holds a \n", "pop_json_url = \"https://gist.github.com/rdhyee/8511607/raw/f16257434352916574473e63612fcea55a0c1b1c/population_of_countries.json\"\n", "pop_list= requests.get(pop_json_url).json()\n", "\n", "df = DataFrame(pop_list)\n", "df[:5]" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | 0 | \n", "1 | \n", "2 | \n", "
---|---|---|---|
0 | \n", "1 | \n", "China | \n", "1385566537 | \n", "
1 | \n", "2 | \n", "India | \n", "1252139596 | \n", "
2 | \n", "3 | \n", "United States | \n", "320050716 | \n", "
3 | \n", "4 | \n", "Indonesia | \n", "249865631 | \n", "
4 | \n", "5 | \n", "Brazil | \n", "200361925 | \n", "
5 rows \u00d7 3 columns
\n", "\n", " | NAME | \n", "P0010001 | \n", "state | \n", "
---|---|---|---|
0 | \n", "Alabama | \n", "4779736 | \n", "01 | \n", "
1 | \n", "Alaska | \n", "710231 | \n", "02 | \n", "
2 | \n", "Arizona | \n", "6392017 | \n", "04 | \n", "
3 | \n", "Arkansas | \n", "2915918 | \n", "05 | \n", "
4 | \n", "California | \n", "37253956 | \n", "06 | \n", "
5 rows \u00d7 3 columns
\n", "\n", " | NAME | \n", "P0010001 | \n", "state | \n", "
---|---|---|---|
0 | \n", "Alabama | \n", "4779736 | \n", "01 | \n", "
1 | \n", "Alaska | \n", "710231 | \n", "02 | \n", "
2 | \n", "Arizona | \n", "6392017 | \n", "04 | \n", "
3 | \n", "Arkansas | \n", "2915918 | \n", "05 | \n", "
4 | \n", "California | \n", "37253956 | \n", "06 | \n", "
5 | \n", "Colorado | \n", "5029196 | \n", "08 | \n", "
6 | \n", "Connecticut | \n", "3574097 | \n", "09 | \n", "
7 | \n", "Delaware | \n", "897934 | \n", "10 | \n", "
8 | \n", "District of Columbia | \n", "601723 | \n", "11 | \n", "
9 | \n", "Florida | \n", "18801310 | \n", "12 | \n", "
10 | \n", "Georgia | \n", "9687653 | \n", "13 | \n", "
11 | \n", "Hawaii | \n", "1360301 | \n", "15 | \n", "
12 | \n", "Idaho | \n", "1567582 | \n", "16 | \n", "
13 | \n", "Illinois | \n", "12830632 | \n", "17 | \n", "
14 | \n", "Indiana | \n", "6483802 | \n", "18 | \n", "
15 | \n", "Iowa | \n", "3046355 | \n", "19 | \n", "
16 | \n", "Kansas | \n", "2853118 | \n", "20 | \n", "
17 | \n", "Kentucky | \n", "4339367 | \n", "21 | \n", "
18 | \n", "Louisiana | \n", "4533372 | \n", "22 | \n", "
19 | \n", "Maine | \n", "1328361 | \n", "23 | \n", "
20 | \n", "Maryland | \n", "5773552 | \n", "24 | \n", "
21 | \n", "Massachusetts | \n", "6547629 | \n", "25 | \n", "
22 | \n", "Michigan | \n", "9883640 | \n", "26 | \n", "
23 | \n", "Minnesota | \n", "5303925 | \n", "27 | \n", "
24 | \n", "Mississippi | \n", "2967297 | \n", "28 | \n", "
25 | \n", "Missouri | \n", "5988927 | \n", "29 | \n", "
26 | \n", "Montana | \n", "989415 | \n", "30 | \n", "
27 | \n", "Nebraska | \n", "1826341 | \n", "31 | \n", "
28 | \n", "Nevada | \n", "2700551 | \n", "32 | \n", "
29 | \n", "New Hampshire | \n", "1316470 | \n", "33 | \n", "
30 | \n", "New Jersey | \n", "8791894 | \n", "34 | \n", "
31 | \n", "New Mexico | \n", "2059179 | \n", "35 | \n", "
32 | \n", "New York | \n", "19378102 | \n", "36 | \n", "
33 | \n", "North Carolina | \n", "9535483 | \n", "37 | \n", "
34 | \n", "North Dakota | \n", "672591 | \n", "38 | \n", "
35 | \n", "Ohio | \n", "11536504 | \n", "39 | \n", "
36 | \n", "Oklahoma | \n", "3751351 | \n", "40 | \n", "
37 | \n", "Oregon | \n", "3831074 | \n", "41 | \n", "
38 | \n", "Pennsylvania | \n", "12702379 | \n", "42 | \n", "
39 | \n", "Rhode Island | \n", "1052567 | \n", "44 | \n", "
40 | \n", "South Carolina | \n", "4625364 | \n", "45 | \n", "
41 | \n", "South Dakota | \n", "814180 | \n", "46 | \n", "
42 | \n", "Tennessee | \n", "6346105 | \n", "47 | \n", "
43 | \n", "Texas | \n", "25145561 | \n", "48 | \n", "
44 | \n", "Utah | \n", "2763885 | \n", "49 | \n", "
45 | \n", "Vermont | \n", "625741 | \n", "50 | \n", "
46 | \n", "Virginia | \n", "8001024 | \n", "51 | \n", "
47 | \n", "Washington | \n", "6724540 | \n", "53 | \n", "
48 | \n", "West Virginia | \n", "1852994 | \n", "54 | \n", "
49 | \n", "Wisconsin | \n", "5686986 | \n", "55 | \n", "
50 | \n", "Wyoming | \n", "563626 | \n", "56 | \n", "
51 rows \u00d7 3 columns
\n", "