In [1]:

    

import pandas as pd
import datetime


    

In [2]:

    

my_dir = "/Volumes/dax/seals/Kaggle-NOAA-SeaLions/"
my_file = '2017-06-24_submission.csv'


    

In [3]:

    

old_form_d = pd.read_csv(my_dir + my_file)

new_index = []
for i in old_form_d['Unnamed: 0']:
    new_index.append(i[:-4])

del old_form_d['Unnamed: 0']

old_form_d['test_id'] = new_index

new_form_d = old_form_d[['test_id', 'adult_males', 'subadult_males', 'adult_females', 'juveniles', 'pups']]

new_form_d.to_csv(my_dir + datetime.date.today().isoformat() + '_submission_stripped.csv', index = False)