import pandas as pd
import os
dataDir = r'C:\Users\Ian\Dropbox\ECON 407 - US Courts & Judges'
cm_data = pd.read_csv(os.path.join(dataDir,r'Carp-Manning.csv'))
cm_data = cm_data.rename(columns = {'judge':'Authoring Judge','crtpoint':'Court Location',
'numjudge':'Number of Judges','circuit':'Circuit',
'state':'State','statdist':'District','month':'Month',
'year':'Year','libcon':'Decision Ideology',
'casetype':'Case Type','category':'Case Category',
'casnum':'Case Number','apyear':'Year of Appointment',
'appres':'Appointing President','party':'Judge Party',
'gender':'Gender','race':'Race'})
cm_data.to_csv(os.path.join(dataDir,'Carp Manning Clean.csv'), index = False)