Single positional indexer is out-of-bounds error reading from CSV

Asked Sep 07 '18 at 19:35

Active Sep 07 '18 at 20:11

Viewed 136 times

I'm attempting to read a .csv and write a new column. Whenever I call the function add(), the index error appears on Line 7.

def add():
    data = pd.read_csv('log.csv')
    for file in os.listdir('.'):
        if 'log' in file:
            continue
        df = pd.read_csv(open(file))
        val = data.loc[data['Num'] == file.split('.csv')[0], 'SAT'].iloc[0]
        ########more code using val#############
add()

edited Sep 07 '18 at 20:11

martineau

119,623
25
170
301

asked Sep 07 '18 at 19:35

defjamvan

could explain what you trying to do in line 7 . – Veera Samantula Sep 07 '18 at 19:55
I noticed that when I added a 'return' the error doesn't appear. However, it only returns one file. I have three files that I'm trying to read/write/display. – defjamvan Sep 07 '18 at 22:00
https://stackoverflow.com/a/42739634/8208006 please check your csv file – Naga kiran Sep 08 '18 at 01:26

Single positional indexer is out-of-bounds error reading from CSV

0 Answers0