how to solve the keyerror when I load a CSV file using pandas

Question

I use pandas to load a csv file and want to print out data of row, here is original data

I want to print out 'violence' data for make a bar chart, but it occuar a keyerror, here is my code

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

c_data=pd.read_csv('crime.csv')
print(c_data.head())

print (c_data['violence'])

and the error

error detail

I tried use capital VIOLENCE,print (c_data['VIOLENCE']),but also failed

error detail

can someone tell me how to work it out?

Gautam J · Accepted Answer · 2018-05-06 05:14:00Z

2

Try the following if your data is small:

with open('crime.csv', 'r') as my_file:
    reader = csv.reader(my_file)
    rows = list(reader)
    print rows[3]

If your data is big, try this:

from itertools import islice

with open('crime.csv', 'r') as my_file:
    reader = csv.reader(my_file)
    print next(islice(reader, 3, 4))

edited May 6, 2018 at 5:14

answered May 5, 2018 at 15:50

Gautam J

7291 gold badge7 silver badges14 bronze badges

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

6 Comments

Gautam J Over a year ago

Ok. I get it. You want to print out a row named 'VOILENCE'. However, the print function only prints the column with its name, and not a row. Let me check and I will give you a solution.

Gautam J Over a year ago

stackoverflow.com/questions/26197189/… Hope the above link helps

noobcat Over a year ago

with open(crime.csv, 'r') as csvfile: reader = csv.reader(csvfile) rows = list(reader) print (rows[3]) that is my new code, but it say name 'crime' is not defined

Gautam J Over a year ago

Type crime.csv between apostrophes. with open('crime.csv', 'r') as csvfile: ....

noobcat Over a year ago

it works, thank you so much Sir. Btw, I have one more question, do u know how to make a bar chart or line chart base on my data

|

Collectives™ on Stack Overflow

how to solve the keyerror when I load a CSV file using pandas

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related