Pandas Introduction

• One-way pandas allow you to work with data is a dataframe.
• Let’s go through the process to go from a comma-separated values (.csv) file to a dataframe.
• This variable csv_path stores the path of the .csv, that is used as an argument to the read_csv function.
• The result is stored in the object df; this is a common short form used for a variable referring to a Pandas dataframe.

read CSV python pandas

	import pandas as pd

df = pd.read_csv('books.csv') # read .csv file.
	

			
	
			

		
	

	# Print first five rows of the dataframe
df.head()
	

			
	
			

		
	

Read data from CSV File and print the first five rows

	# Read data from CSV file

path = 'abcd.csv'
df = pd.read_csv(path)
	

			
	
			

		
	

• We can use the method head() to examine the first five rows of a dataframe.

	# Print first five rows of the dataframe
df.head()
	

			
	
			

		
	

Read data from Excel File and print the first five rows.

	# Read data from CSV file

path = 'abcd.xlsx'
df = pd.read_excel(path)
df.head()
	

			
	
			

		
	

• We use the path of the excel file and the function read_excel.

	# Print first five rows of the dataframe
df.head()
	

			
	
			

		
	

• The result is a data frame as above