In [9]:
import pandas as pd
import numpy as np

import matplotlib.pyplot as plt


%load_ext autoreload
%autoreload 2
%matplotlib inline

In [3]:
db = pd.read_csv('SCDB.csv')

In [5]:
db.columns


Out[5]:
Index([u'caseId', u'docketId', u'caseIssuesId', u'voteId', u'dateDecision',
       u'decisionType', u'usCite', u'sctCite', u'ledCite', u'lexisCite',
       u'term', u'naturalCourt', u'chief', u'docket', u'caseName',
       u'dateArgument', u'dateRearg', u'petitioner', u'petitionerState',
       u'respondent', u'respondentState', u'jurisdiction', u'adminAction',
       u'adminActionState', u'threeJudgeFdc', u'caseOrigin',
       u'caseOriginState', u'caseSource', u'caseSourceState',
       u'lcDisagreement', u'certReason', u'lcDisposition',
       u'lcDispositionDirection', u'declarationUncon', u'caseDisposition',
       u'caseDispositionUnusual', u'partyWinning', u'precedentAlteration',
       u'voteUnclear', u'issue', u'issueArea', u'decisionDirection',
       u'decisionDirectionDissent', u'authorityDecision1',
       u'authorityDecision2', u'lawType', u'lawSupp', u'lawMinor',
       u'majOpinWriter', u'majOpinAssigner', u'splitVote', u'majVotes',
       u'minVotes'],
      dtype='object')

In [14]:
area = db['issueArea'].tolist()

In [21]:
{i: area.count(i) for i in range(1, 15)}


Out[21]:
{1: 2635,
 2: 2150,
 3: 1143,
 4: 587,
 5: 168,
 6: 137,
 7: 512,
 8: 2552,
 9: 1996,
 10: 681,
 11: 109,
 12: 394,
 13: 66,
 14: 3}

In [ ]:
# procedural: