Getting 'None' Output when reading from CSV file

Question

Here is the code I am using:

import csv
import os

filename = "studentinfo.csv"
filedir = ""
csv_file = os.path.join(filedir, filename)

names = []
ages = []
emails = []

with open(csv_file) as file:
    reader = csv.DictReader(file)
    for row in reader:
        names.append(row.get('name'))
        ages.append(row.get('age'))
        emails.append(row.get('email'))

print(names, ages, emails)

and this is the CSV file:

name, age, email
fin harris, 14,email1
harvey green, 14, email2

I am getting this output:

['fin harris', 'harvey green'] [None, None] [None, None]

Why am I getting the output None?

Remove all the whitespaces from both the header line and the data lines — DeepSpace
– DeepSpace, Commented Nov 7, 2019 at 12:01

Nurullah Macun · Accepted Answer · 2019-11-07 11:56:25Z

1

It is because of whitespaces before column name. You can use row.get(' age') or remove whitespaces from column names.

answered Nov 7, 2019 at 11:56

Nurullah Macun

5527 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

DeepSpace Over a year ago

The better solution is to remove the whitespaces. If not for the csv """standards""" then for the consistency of the column names. Whitespaces should also be removed from the data rows

Collectives™ on Stack Overflow

Getting 'None' Output when reading from CSV file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related