Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Reading a csv file
#1
I know this is a stupid question but I just can't solve the error I get.

So I've got a file called: Profiles.txt, and I want to open it with python and read what's inside.
This is inside the file:
Main,Henk,Klaas

with open('Profiles.txt', 'r') as file:
    reader = csv.reader(file, delimiter=',')

    for row in reader:
        profile_name = row[0]
        first_name = row[1]
        last_name = row[2]

print(profile_name)
print(first_name)
print(last_name)
So I want my code to return this:
profile_name = 'Main'
First_name = 'Henk'
Last_name = 'Klaas'
It doesn't need to print this out^^, but I want the variables to have those values. But i get this:

Error:
Traceback (most recent call last): File "FILEPATH", line 15, in <module> profile_name = row[0] IndexError: list index out of range
Does someone know how to fix this and how to give the variables the value I want them to have?
Reply
#2
look inside your Profiles.txt file
probably there are empty lines ate the end of the file or the format is not what you expect
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
Sad problems with reading csv file. MassiJames 3 618 Nov-16-2023, 03:41 PM
Last Post: snippsat
  Reading a file name fron a folder on my desktop Fiona 4 895 Aug-23-2023, 11:11 AM
Last Post: Axel_Erfurt
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,088 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Reading a file JonWayn 3 1,090 Dec-30-2022, 10:18 AM
Last Post: ibreeden
  Reading Specific Rows In a CSV File finndude 3 973 Dec-13-2022, 03:19 PM
Last Post: finndude
  Excel file reading problem max70990 1 890 Dec-11-2022, 07:00 PM
Last Post: deanhystad
  Replace columns indexes reading a XSLX file Larry1888 2 977 Nov-18-2022, 10:16 PM
Last Post: Pedroski55
  Failing reading a file and cannot exit it... tester_V 8 1,800 Aug-19-2022, 10:27 PM
Last Post: tester_V
  Reading .csv file doug2019 4 1,699 Apr-29-2022, 09:55 PM
Last Post: deanhystad
  Reading an Input File DaveG 1 1,243 Mar-27-2022, 02:08 AM
Last Post: deanhystad

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020