Python pandas TypeError tuple indices must be integers or slices not str

Question

Hi. Please help me solve this error. I am trying to print row values

import pandas as pd

df = pd.read_csv(“/home/user/data1”)

for row in df.iterrows():
    print (row['Email'])

Answer 1

df.iterrows() returns a tuple with index and the row value. So, you will have handle both the index and the value. Try this:

import pandas as pd

df = pd.read_csv(“/home/user/data1”)

for index, row in df.iterrows():
    print (row['Email'])

Hope this helps!!

If you need to learn more about Python, It's recommended to join Python Training today.

Thanks!

Answer 2

iterrows() method returns a tuple of form: (index, row)

so you'd have to use row[1]['Email'] to get what you're looking for

Comments

I get the following error when I try row[1]['Email']

TypeError: string indices must be integers, not str

Answer 3

In fact, I get a perfectly good output with this logic. Can you share your dataset's data structure?