How to print a row in Pandas dataframe by its numerical index after assigning names to columns?

Question

In the following code I get a “KeyError: 0”.

import pandas as pd
import math

data = pd.read_csv(…) #file name and other parameters

data.columns=['UNIX_UTC_Time', 'Home_Team', …] #columns names

matches_number=len(data.index)

def check_data_quality():
    for x in range (matches_number):
        for y in range (11): #number of columns
            if y==1 or y==2: #these columns are strings
                continue     
            if math.isnan(data.at[x,y]):
                print('NaN in:',data.at[x,y],'row',data.iloc[x])

check_data_quality()

Using loc instead of iloc doesn't help either.

If I remove data.columns line, then everything works.

Please let me know how I can print (whole) rows with unintended NaNs here.

Thank you!

Does this answer your question? [Selecting pandas column by location](https://stackoverflow.com/questions/14941097/selecting-pandas-column-by-location) — Chris, Sep 05 '22 at 18:45

score 0 · Answer 1 · answered Sep 05 '22 at 18:46

0

Try replacing data.at[x,y] with data.iloc[x,y].

answered Sep 05 '22 at 18:46

constantstranger

9,176
2
5
19

Constantstranger, thank you, your solution worked! – DVS75 Sep 05 '22 at 18:52
It's even better to use data.iat here - for single cells. – DVS75 Sep 06 '22 at 22:26

How to print a row in Pandas dataframe by its numerical index after assigning names to columns?

1 Answers1