Getting column values from CSV file

Question

I am trying to print a single column name and the corresponding values for that column in Python from a CSV file using pandas. I am able to print the column names, but when I then try to print just one of the columns with the following code:

import pandas as pd

df = pd.read_csv('pokemon_data.csv')

print(df['name'])

I then get these errors:

Errors

Updated: I see that the error is a "key error" however a key named "Name" should exist as it does when I run:

print(df.columns) 

with output:

Index(['#,Name,Type 1,Type 2,HP,Attack,Defense,Sp. Atk,Sp. Def,Speed,Generation,Legendary'], dtype='object')

The column "name" does not exist in this DataFrame. You can use print(df.columns) to print out which columns do exist. — Tom Aarsen
– Tom Aarsen, Commented Jun 25, 2022 at 10:48
Post minimal reproducible example, incl. sample csv file. Also, print the df and post the output. — buran
– buran, Commented Jun 25, 2022 at 11:17

FlippingTook · Accepted Answer · 2022-06-25 10:49:35Z

1

"KeyError : name" It seems like you don't have a name column.

answered Jun 25, 2022 at 10:49

FlippingTook

1611 silver badge7 bronze badges

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

Comments

Tom Aarsen · Accepted Answer · 2022-06-25 11:06:28Z

0

To extend my comment below your question - your next issue is that the output of print(df.columns), which is Index(['#,Name,Type 1,Type 2,HP,Attack,Defense,Sp. Atk,Sp. Def,Speed,Generation,Legendary'], dtype='object'), is indicative that you only have 1 column.

The name of that 1 column is '#,Name,Type 1,Type 2,HP,Attack,Defense,Sp. Atk,Sp. Def,Speed,Generation,Legendary'. Maybe there is an issue with your .csv file, or perhaps messing with the read_csv settings (see docs here) may help. For example, changing the separator/delimiter to whatever your .csv file is using.

answered Jun 25, 2022 at 11:06

Tom Aarsen

1,1905 silver badges20 bronze badges

Collectives™ on Stack Overflow

Getting column values from CSV file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related