GOT API with Pandas

Add requests to installation requirements

# TinyURL to this script: https://tinyurl.com/gotpandas

# Interactive API: https://anapioficeandfire.com/

# https://raw.githubusercontent.com/joakimskoog/AnApiOfIceAndFire/master/data/characters.json
# https://tinyurl.com/gotchararacters

# Installation
# Requires: python, requests, pandas
# Optional: matplotlib

## Linux / Ubuntu
# sudo apt-get install python
# sudo apt-get install pip

## OSX
# brew install python

# Import statements
import requests     # pip install requests
import pandas as pd # pip install pandas

# Get the JSON blob
response = requests.request('GET', 'https://tinyurl.com/gotchararacters')
json_blob = response.text

# Load into pandas
df = pd.read_json(json_blob)

# What data do I have?
df.columns

# Optional: Save to csv
df.to_csv('characters.csv')

## Query examples
df[df.Culture=='Reach'].Name
df.query("Culture == 'Reach'")[['Name', 'Died']]

## Groupby examples
df.groupby('IsFemale').Id.count()
df.groupby('Culture').Id.count()
df.groupby(['Culture', 'IsFemale']).Id.count()

## Optional: Plotting examples
import matplotlib.pyplot as plt   # pip install matplotlib
plt.gcf() # So plotting shows by default. Alt, can use `plt.show()` every time you want to see the plot.
df.Culture.value_counts()[1:].plot()
df.IsFemale.value_counts().plot.bar()