22 Dec Read CSV in Python Pandas
One of the major benefits of working on Python is the ease of reading and accessing CSV (comma-separated files). For this, Python has the Pandas library. In this lesson, we will learn how to read CSV in Python Pandas using the read_csv() method.
Let’s say we have the following CSV file Students.csv:
Read a CSV
Let us now see an example to read our CSV file Students.csv using the pandas.read_csv() method in Pandas. First, load the CSV file, read the data, and store it in a Pandas DataFrame:
|
1 2 3 4 5 6 7 8 9 10 |
import pandas as pd # Input CSV file # Loading CSV in the DataFrame df = pd.read_csv('Students.csv') # Display the CSV file records print("Our DataFrame =\n",df) |
Output
|
1 2 3 4 5 6 7 8 |
Student Rank Marks 0 Amit 1 95 1 Virat 2 90 2 David 3 80 3 Will 4 75 4 Steve 5 65 |
Display the top n rows of the DataFrame
The head() method will display the first n rows of a DataFrame. The default rows returned are 5.
Let us see an example to display only the top 2 rows. For that, set the parameter of the head() as 2. First, load the CSV file, read the data, and store it in a Pandas DataFrame:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
import pandas as pd # Input CSV file # Loading CSV in the DataFrame df = pd.read_csv('Students.csv') # Display the CSV file records print("Our DataFrame =\n",df) # Display the top n rows using the head() print("Top 2 rows\n",df.head(2)) |
Output
|
1 2 3 4 5 |
Student Rank Marks 0 Amit 1 95 1 Virat 2 90 |
Display the last n rows of a DataFrame
The tail() method will display the last n rows of a DataFrame. The default rows returned are 5.
Let us see an example to display only the bottom 2 rows. For that, set the parameter of the tail() as 2. First, load the CSV file, read the data, and store it in a Pandas DataFrame:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
import pandas as pd # Input CSV file # Loading CSV in the DataFrame df = pd.read_csv('Students.csv') # Display the CSV file records print("Our DataFrame =\n",df) # Display the bottom n rows using the tail() print(df.tail(2)) |
Output
|
1 2 3 4 5 |
Student Rank Marks 0 Will 4 75 1 Steve 5 65 |
If you liked the tutorial, spread the word and share the link and our website Studyopedia with others:
For Videos, Join Our YouTube Channel: Join Now
Read More:
No Comments