How to print a specific row of a pandas DataFrame

Question

I have a massive dataframe  and I m getting the error   TypeError    Empty  DataFrame   no numeric data to plot    occurred at index 159220    I ve already dropped nulls  and checked dtypes for the DataFrame so I have no guess as to why it s failing on that row   How do I print out just that row  at index 159220  of the data frame   Thanks

User · Accepted Answer

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

User · Answer

To print a specific row we have couple of pandas method   loc - It only get label i e column name or Features iloc - Here i stands for integer  actually row number  ix - It is a mix of label as well as integer   How to use for specific row   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      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

User · Answer

Sounds like you re calling df plot    That error indicates that you re trying to plot a frame that has no numeric data  The data types shouldn t affect what you print     Use print df iloc 159220

User · Answer

Use ix operator   print df ix 159220

User · Answer

If you want to display at row 159220 row 159220   To display in a table format display res loc row row   display res iloc row row 1     To display in print format display res loc row   display res iloc row

[python] How to print a specific row of a pandas DataFrame?

Examples related to python

Examples related to python-3.x

Examples related to pandas

Examples related to indexing