open a csv file in python using pandas code example

Example 1: how to import csv in pandas

import pandas as pd

df = pd.read_csv (r'Path where the CSV file is stored\File name.csv')
print (df)

Example 2: read a csv file in pandas

you should be in the same dir as .py file 

df = pd.read_csv('your_file_name.csv')