Can't call file from another - well correctly

Sayth Renshaw flebber.crue at
Sun Jul 5 02:23:04 CEST 2015

I was playing with odo(blaze and wanted to use it with a current script I have been using on the command line.

So my 2 scripts are below, I will explain here hopefully to keep question clearer what I have done. Script 2 works for me from the command line as

python some.csv

i wanted to use my script  to fix up a bad csv and then use odo to a dataframe and hopefully build upon this later.

When I run script 1 I get the error I need more than 1 value to unpack, which makes sense in that I have Script and Filename.

Traceback (most recent call last):
  File "", line 3, in <module>
    import clean
  File "C:\Users\sayth\Repos\Notebooks\", line 9, in <module>
ValueError: need more than 1 value to unpack

But if I change script2 to have just FILENAME = argv I get this error and I am not sure what to do.

Traceback (most recent call last):
  File "", line 3, in <module>
    import clean
  File "C:\Users\sayth\Repos\Notebooks\", line 62, in <module>
    MY_FILE = out_file_name(FILENAME)
  File "C:\Users\sayth\Repos\Notebooks\", line 15, in out_file_name
    file_parts = file_name.split(".",)
AttributeError: 'list' object has no attribute 'split'

What can i do?

######Scripts #######

# Script 1

from odo import odo
import pandas as pd
import clean

myFile = race_table('20150704RHIL0.csv')

odo(myFile, pd.DataFrame)

# Script 2

import csv
import re
from sys import argv
#FILENAME = argv

def out_file_name(file_name):
    """take an input file and keep the name with appended _clean"""
    file_parts = file_name.split(".",)
    output_file = file_parts[0] + '_clean.' + file_parts[1]
    return output_file

def race_table(text_file):
    """utility to reorganise poorly made csv entry"""
    output_table = []
    for record in text_file:
        if record[0] == 'Meeting':
            meeting = record[3]
            rail = record[6]
            weather = record[7]
            track = record[8]
        elif record[0] == 'Race':
            date = record[13]
            race = record[1]
            benchmark = record[4]
            distance = record[5]
        elif record[0] == 'Horse':
            number = record[1]
            name = record[2]
            jockey = record[6]
            barrier = record[7]
            weight = record[8]
            results = record[9]
            res_split = re.split('[- ]', results)
            starts = res_split[0]
            wins = res_split[1]
            seconds = res_split[2]
            thirds = res_split[3]
                prizemoney = res_split[4]
            except IndexError:
                prizemoney = 0
            trainer = record[4]
            location = record[5]
            b_rating = record[15]
            sex = record[16]
            print(name, wins, seconds)
            output_table.append((meeting, date, rail, weather, track, distance,
                                 benchmark, race, number, name, sex, b_rating,
                                 weight, barrier, starts, wins, seconds,
                                 thirds, prizemoney, trainer, location, jockey
    return output_table

MY_FILE = out_file_name(FILENAME)

# with open(FILENAME, 'r') as f_in, open(MY_FILE, 'w') as f_out:
#     for line in race_table(f_in.readline()):
#         new_row = line
with open(FILENAME, 'r') as f_in, open(MY_FILE, 'w') as f_out:
    CONTENT = csv.reader(f_in)
    # print(content)
    FILE_CONTENTS = race_table(CONTENT)
    # print new_name
    # f_out.write(str(FILE_CONTENTS))
    headers = ['MEETING', 'DATE', 'RAIL', 'WEATHER', 'TRACK', 'DISTANCE',
               'BENCHMARK', 'RACE', 'NUMBER', 'NAME', 'SEX', 'B_RATING',
               'WEIGHT', 'BARRIER', 'STARTS', 'WINS', 'SECONDS', 'THIRDS',

    f_csv = csv.writer(f_out)

# Old implementation for reference
#     input_table = [[item.strip(' "') for item in record.split(',')]
#                    for record in text_file.splitlines()]
# At this point look at input_table to find the record indices
#     identity = string.maketrans("", "")
#     print(input_table)
#     input_table = [s.translate(identity, ",'") for s
#                    in input_table]

if __name__ == '__main__':

many thanks for your time.


More information about the Python-list mailing list