w3resource

Pandas Practice Set-1: Read a csv file from a specified source and print the first 5 rows


1. Read CSV and Print First 5 Rows

Write a Pandas program to read a csv file from a specified source and print the first 5 rows.

Sample Solution :

Python Code :

import pandas as pd
pd.set_option('display.max_rows', 50)
pd.set_option('display.max_columns', 50)
diamonds = pd.read_csv('https://raw.githubusercontent.com/mwaskom/seaborn-data/master/diamonds.csv')
print("First 5 rows:")
print(diamonds.head())

Sample Output:

First 5 rows:
   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


For more Practice: Solve these Related Problems:

  • Write a Pandas program to load the diamonds CSV from a URL and display the first 5 rows with a custom separator.
  • Write a Pandas program to read the diamonds CSV, ensuring proper parsing of date columns if present, then print the first 5 rows.
  • Write a Pandas program to load the diamonds CSV and print the first 5 rows with the index reset.
  • Write a Pandas program to read the diamonds CSV file and display the first 5 rows along with the DataFrame’s summary statistics.

Go to:


Previous: Python Pandas dataset1 Home.
Next: Write a Pandas program to read a dataset from diamonds DataFrame and modify the default columns values and print the first 6 rows.

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.