How to print a specific row of a pandas DataFrame?

Solution 1:

When you call loc with a scalar value, you get a pd.Series. That series will then have one dtype. If you want to see the row as it is in the dataframe, you'll want to pass an array like indexer to loc.

Wrap your index value with an additional pair of square brackets

print(df.loc[[159220]])

Solution 2:

To print a specific row we have couple of pandas method

1. loc - It only get label i.e column name or Features
2. iloc - Here i stands for integer, actually row number
3. ix - It is a mix of label as well as integer

How to use for specific row

1. loc

df.loc[row,column]

For first row and all column

df.loc[0,:]

For first row and some specific column

df.loc[0,'column_name']

2. iloc

For first row and all column

df.iloc[0,:]

For first row and some specific column i.e first three cols

df.iloc[0,0:3]

Solution 3:

Use ix operator:

print df.ix[159220]