Selecting a row of pandas series/dataframe by integer index

by

echoing @HYRY, see the new docs in 0.11

http://pandas.pydata.org/pandas-docs/stable/indexing.html

Here we have new operators, .iloc to explicity support only integer indexing, and .loc to explicity support only label indexing

e.g. imagine this scenario

In [1]: df = pd.DataFrame(np.random.rand(5,2),index=range(0,10,2),columns=list('AB'))

In [2]: df
Out[2]: 
          A         B
0  1.068932 -0.794307
2 -0.470056  1.192211
4 -0.284561  0.756029
6  1.037563 -0.267820
8 -0.538478 -0.800654

In [5]: df.iloc[[2]]
Out[5]: 
          A         B
4 -0.284561  0.756029

In [6]: df.loc[[2]]
Out[6]: 
          A         B
2 -0.470056  1.192211

[] slices the rows (by label location) only

More Related Contents:

  1. How are iloc and loc different?
  2. How to convert index of a pandas dataframe into a column
  3. How to reset index in a pandas dataframe? [duplicate]
  4. What rules does Pandas use to generate a view vs a copy?
  5. Pandas split DataFrame by column value
  6. What is the difference between using squared brackets or dot to access a column?
  7. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  8. Get column index from column name in python pandas
  9. Python Pandas: Get index of rows where column matches certain value
  10. Python: Removing Rows on Count condition
  11. Using replace efficiently in pandas
  12. In Python pandas, start row index from 1 instead of zero without creating additional column
  13. Selecting a range of columns in a dataframe
  14. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  15. start index at 1 for Pandas DataFrame
  16. Combine two columns of text in pandas dataframe
  17. Convert DataFrame column type from string to datetime
  18. How to apply a function to two columns of Pandas dataframe
  19. How to convert an XML file to nice pandas dataframe?
  20. Dynamically evaluate an expression from a formula in Pandas
  21. Find column whose name contains a specific string
  22. How to calculate mean values grouped on another column in Pandas
  23. Pandas index column title or name
  24. Making heatmap from pandas DataFrame
  25. Count occurrences of each of certain words in pandas dataframe
  26. Python/Pandas convert string to time only
  27. Anti-Join Pandas
  28. Convert pandas DataFrame into list of lists [duplicate]
  29. Got continuous is not supported error in RandomForestRegressor
  30. Get max value from row of a dataframe in python [duplicate]

Leave a Comment