How can I print a specific row of a Pandas DataFrame?

How can I print a specific row of a Pandas DataFrame?

To print a specific row of a Pandas DataFrame, you can use the “iloc” function with the index number of the row you want to print. This will return a series object with the values of that particular row.

Print Specific Row of Pandas DataFrame


You can use the following methods to print a specific row of a pandas DataFrame:

Method 1: Print Row Based on Index Position

print(df.iloc[[3]])

Method 2: Print Row Based on Index Label

print(df.loc[['this_label']])

The following examples show how to use each method in practice with the following pandas DataFrame:

import pandas as pd

#create DataFrame
df = pd.DataFrame({'points': [18, 22, 19, 14, 10, 11, 20, 28],
                   'assists': [4, 5, 5, 4, 9, 12, 11, 8],
                   'rebounds': [3, 9, 12, 4, 4, 9, 8, 2]},
                    index=['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'])

#view DataFrame
print(df)

   points  assists  rebounds
A      18        4         3
B      22        5         9
C      19        5        12
D      14        4         4
E      10        9         4
F      11       12         9
G      20       11         8
H      28        8         2

Related:

Example 1: Print Row Based on Index Position

The following code shows how to print the row located at index position 3 in the DataFrame:

#print row located at index position 3
print(df.iloc[[3]])

   points  assists  rebounds
D      14        4         4

Notice that only the row located at index position 3 is printed.

To print multiple specific rows by index position, simply include multiple values in the iloc function:

#print rows located at index positions 3 and 5
print(df.iloc[[3, 5]])

   points  assists  rebounds
D      14        4         4
F      11       12         9

Notice that only the rows located at index positions 3 and 5 are printed.

Example 2: Print Row Based on Index Label

The following code shows how to print the row with an index label of ‘C’ in the DataFrame:

#print row with index label 'C'
print(df.loc[['C']])

   points  assists  rebounds
C      19        5        12

Notice that only the row with an index label of ‘C’ is printed.

To print multiple specific rows by index labels, simply include multiple labels in the loc function:

#print rows with index labels 'C' and 'F'
print(df.loc[['C', 'F']])

   points  assists  rebounds
C      19        5        12
F      11       12         9

Notice that only the rows with index labels ‘C’ and ‘F’ are printed.

The following tutorials explain how to perform other common operations in pandas:

Cite this article

stats writer (2024). How can I print a specific row of a Pandas DataFrame?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-print-a-specific-row-of-a-pandas-dataframe/

stats writer. "How can I print a specific row of a Pandas DataFrame?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-print-a-specific-row-of-a-pandas-dataframe/.

stats writer. "How can I print a specific row of a Pandas DataFrame?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-print-a-specific-row-of-a-pandas-dataframe/.

stats writer (2024) 'How can I print a specific row of a Pandas DataFrame?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-print-a-specific-row-of-a-pandas-dataframe/.

[1] stats writer, "How can I print a specific row of a Pandas DataFrame?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.

stats writer. How can I print a specific row of a Pandas DataFrame?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.

Download Post (.PDF)
Slide Up
x
PDF
Scroll to Top