w3resource

Pandas Practice Set-1: Read rows in positions 0 through 4, columns in positions 1 through 4 of diamonds DataFrame


56. Read Rows in Positions 0 Through 4, Columns in Positions 1 Through 4

Write a Pandas program to read rows in positions 0 through 4, columns in positions 1 through 4 of diamonds DataFrame.

Sample Solution:

Python Code:

import pandas as pd
diamonds = pd.read_csv('https://raw.githubusercontent.com/mwaskom/seaborn-data/master/diamonds.csv')
print("Original Dataframe:")
print(diamonds.head())
print("\nRows in positions 0 through 4, columns in positions 1 through 4:")
print(diamonds.iloc[0:4, 1:4])

Sample Output:

Original Dataframe:
   carat      cut color clarity  depth  table  price     x     y     z
0   0.23    Ideal     E     SI2   61.5   55.0    326  3.95  3.98  2.43
1   0.21  Premium     E     SI1   59.8   61.0    326  3.89  3.84  2.31
2   0.23     Good     E     VS1   56.9   65.0    327  4.05  4.07  2.31
3   0.29  Premium     I     VS2   62.4   58.0    334  4.20  4.23  2.63
4   0.31     Good     J     SI2   63.3   58.0    335  4.34  4.35  2.75

Rows in positions 0 through 4, columns in positions 1 through 4:
       cut color clarity
0    Ideal     E     SI2
1  Premium     E     SI1
2     Good     E     VS1
3  Premium     I     VS2

For more Practice: Solve these Related Problems:

  • Write a Pandas program to use iloc to select rows 0 to 4 and columns 1 to 4 from the diamonds DataFrame.
  • Write a Pandas program to slice the diamonds DataFrame for the specified row and column positions and display the extracted block.
  • Write a Pandas program to load the diamonds dataset and use integer-based slicing to extract rows 0-4 and columns 1-4.
  • Write a Pandas program to retrieve and print a sub-DataFrame from the diamonds data using positional indices for both rows and columns.

Go to:


Previous: Write a Pandas program to read rows in positions 0 and 1, columns in positions 0 and 3 of diamonds DataFrame.
Next: Write a Pandas program to read rows in positions 0 through 4 (exclusive) and all columns of diamonds DataFrame.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.